Question

When two tables are collated, the ............................ key of one table becomes the ........................... key of the other​

Answer 1

Answer:

hii I think that it helps you

Explanation:

To change the default character set and collation of a table including those of existing columns (note the convert to clause): alter table <some_table> convert to character set utf8 collate utf8_unicode_ci; To apply this to all tables in database you have to execute alter command for each table.

On the other hand, the foreign key is just the primary key of another table. In a relational database, two tables can be related to each other like Employee and Department, those cases, the primary key of one table becomes the foreign key of another table.