mysql与oracle
char为定长字符串
var为可变字符串
修改表名:rename table1 to table2;(mysql)
alter table1 rename to table2(oracle)
新增列名:alter table product(表名)add column product_1 varchar(40) not null,add column product_2;(mysql)
alter table product (表名) add (product_1 varchar(40) not null,product_2);(oracle)
alter table product (表名) drop column product_1,drop column product_2;
alter table product (表名) drop (prodict_1,product_2);