摘要:
1、创建表 create table if not exists table_name( id int, name varchar(20), ...... ); 2、修改表 2.1、修改列名:alter table table_name change [column] old_column_name 阅读全文
摘要:
1、删除表中指定的某条记录:delete from table where delete_condition; 2、多表删除操作: 1 delete table1 as t1,[table2 as t2] 2 from table1 as t1 3 inner join tables as t2 4 阅读全文