增加记录:
|
1
2
3
|
insert into tablename(...) values(...)//如果增加的记录包括所有的列，则不需要写数据列表insert into tablename values(...) |
删除记录:
|
1
|
delete from tablename where condition ; |
修改记录:
|
1
2
3
|
update tablename set xx=xx , xx=xx... where condition ;alter table tablename set xx=xx , xx=xx... where condition ; |
查询记录:
|
1
2
3
|
select (...) from tablename where condition ;select * from tablename where condition ; |
删除整个表:
|
1
|
drop table tablename ; |
添加列:
|
1
|
alter table tablename add column columnname columntype ... ; |
删除列:
|
1
|
alter table tablename drop column columnname ; |
感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！
原文链接：http://blog.csdn.net/qq_27905183/article/details/52951131
