增加記錄:
|
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
