MySQL (MARIADB) Table structure Add Modify Delete method summary

1, Add table field

ALTER TABLE table1 add Ptel varchar (+) not Null;

ALTER TABLE table1 add ID int unsigned not Null auto_increment primary key;

ALTER TABLE table1 add TJ Int (1) Not Nul default ' 1 ';

2, modify table field

ALTER TABLE name change field Name field Name field type [whether non-null allowed];

ALTER TABLE name modify field Name field type [allow non-null];

ALTER TABLE name modify field Name field type [allow non-null];

3. Delete table field

ALTER TABLE table1 DROP field name

Above from the Nine Lok Network (96net.com.cn)

MySQL (MARIADB) Table structure Add Modify Delete method summary