MySQL Note 4 Data sheet Operations 1

1 Viewing the structure of a table

(1) Show create TABLE + database name

(2) desc+ database name

2 Modifying a table

(1) Add a column to the table

ALTER TABLE database name add column addr varchar (20)//Add Address column

(2) Modifying a table column technician type

ALTER TABLE database name modify column sname varchar (20)

(3) Modify the name of a column

ALTER TABLE database name change addr work_add varchar (20)

(4) Modify the name of the table

ALTER TABLE database name rename new database table name

(5) View table structure

Show tables;

(6) Modifying the character set of a table

ALTER TABLE users DEFAULT CHARACTER SET UTF8;

(7) Delete a table

drop table + tables name

　　

MySQL Note 4 Data sheet Operations 1