---建表
CREATE?TABLE?temp(
id?INT
);
----查詢表
SELECT?*?FROM?temp_t;
---刪表
DROP?TABLE?temp;
---修改表名
ALTER?TABLE?temp_tt?RENAME?temp;
ALTER?TABLE?temp?RENAME?TO?temp_t;
ALTER?TABLE?temp?RENAME?AS?temp_tt;
---常用字段
CREATE?TABLE?temp(
id?INT(4),NAME?CHAR(20),address?VARCHAR(20),degreed?DOUBLE(5,2),money?FLOAT,birthday?DATE,insertTime?TIME,courrentTime?DATETIME
);---添加字段
ALTER?TABLE?temp?ADD?COLUMN?age?INT(2);//標準寫法
ALTER?TABLE?temp?ADD?age?INT(2);//可以這樣寫
ALTER?TABLE?temp?ADD?COLUMN?age?INT(2)?AFTER?NAME;
---刪除字段
ALTER?TABLE?temp?DROP?COLUMN?age;
ALTER?TABLE?temp?DROP?age;
---修改字段名
ALTER?TABLE?temp?CHANGE?COLUMN?age?age_t?INT(4)?CHARSET?utf8?COLLATE?utf8_general_ci?NULL;//標準寫法
ALTER?TABLE?temp?CHANGE?age_t?age?INT(4);
---修改字段屬性
ALTER?TABLE?temp?MODIFY?COLUMN?age_t?INT(6)?FIRST;//定義在第一列
ALTER?TABLE?temp?MODIFY?COLUMN?age_t?INT(6)?AFTER?money;//定義某列與莫列之后