Mysql入门Mysql的增删改查语句简单实现

MYSQL数据库
insert into tablename(...) values(...)
//如果增加的记录包括所有的列,则不需要写数据列表
insert into tablename values(...)

MYSQL数据库
delete from tablename where condition ;

MYSQL数据库
update tablename set xx=xx , xx=xx... where condition ;
alter table tablename set xx=xx , xx=xx... where condition ;

MYSQL数据库
select (...) from tablename where condition ;
select * from tablename where condition ;

MYSQL数据库
drop table tablename ;

MYSQL数据库
alter table tablename add column columnname columntype ... ;

MYSQL数据库
alter table tablename drop column columnname ;