MySQL database---Encoding format basic operation

1. View the database encoding format

Mysql> Show variables like ' character_set_database ';

2. View the encoding format of the data table

Mysql> Show CREATE TABLE <tableName>;

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

Mysql>create database <databaseName> 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 database <databaseName> character set UTF8;

6. Modify the data table encoding format

Mysql>alter table <tableName> character set UTF8;

7. Modify the field encoding format

Mysql>alter table <tableName> Change <column_name> <column_name> <type> character set UTF8; Mysql>alter Table User change username username varchar (n) 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 <tableName> add constraint <F_keyName> foreign key<column_name> REFERENCES <f_ tablename><column_name>;

9. Delete foreign keys

Mysql>alter table tb_people drop foreign key fk_1;mysql>alter table <tableName> drop foreign key <f_keyname >;

MySQL database---Encoding format basic operation