這篇文章主要介紹了mysql的增刪改查語句簡單實現的相關資料,需要的朋友可以參考下
Mysql的增刪改查語句簡單實現
增加記錄:
insert?into?tablename(...)?values(...) //如果增加的記錄包括所有的列，則不需要寫數據列表 insert?into?tablename?values(...)
刪除記錄:
delete?from?tablename?where?condition?;
修改記錄:
update?tablename?set?xx=xx?,?xx=xx...?where?condition?; alter?table?tablename?set?xx=xx?,?xx=xx...?where?condition?;
查詢記錄:
select?(...)?from?tablename?where?condition?; select?*?from?tablename?where?condition?;
刪除整個表:
drop?table?tablename?;
添加列:
alter?table?tablename?add?column?columnname?columntype?...?;
刪除列:
alter?table?tablename?drop?column?columnname?;
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
