View MySQL database and table encoding format

1. View the database encoding format

1	mysql> show variables like‘character_set_database‘;

2. View the encoding format of the data table

1	mysql> show createtable <表名>;

3. Specify the character set of the database when creating the database

Mysql>create databases < database name > character set UTF8;

4. Specify the encoding format of the data table when creating the data table

CREATE TABLE Tb_books (name varchar) is not NULL, the price double is not    null, Bookcount int is not    null,    author varchar () NOT NULL) default CharSet = UTF8;

5. Modify the encoding format of the database

Mysql>alter databases < database name > character set UTF8;

6. Modify the data table encoding format

Mysql>alter Table < name > character set UTF8;

7. Modify the field encoding format

Mysql>alter Table < name > Change < Field name > < Field name > < type > Character set utf8;mysql>alter table user Cha Nge username username varchar (character set UTF8 not null;

8. Add a FOREIGN key

Mysql>alter table tb_product Add constraint fk_1 foreign key (Factoryid) references tb_factory (Factoryid);mysql> ALTER TABLE < table name > Add constraint < foreign key name > Foreign key< Field name > REFERENCES < outer table name >< field name >;

9. Delete foreign keys

Mysql>alter table tb_people drop foreign key Fk_1;mysql>alter table < table name > drop FOREIGN Key < foreign key name >;

View MySQL database and table encoding format