建表
CREATE TABLE example_autoincrement (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
data VARCHAR(100)
);
删除表
DROP TABLE table_name;
插入
INSERT INTOtbl_name
() VALUES();
删除
DELETE FROM table_name
WHERE column_name = some_value
更新
UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value
创建索引
Create [unioun|fulltext|spatial] index indexname[using indextype] on tablename( tablenamecol)
index_col_name:
col_name[ (length)][asc |desc]
create index cityname on city(city(2));
删除索引
Drop indexname on tablename
drop index cityname on city;
修改表的属性名
修改某个表的字段类型及指定为空或非空 :
>alter table 表名称 change 原字段名称 新字段名称 新字段类型 [是否允许非空];
例如:alter table pet change name name varchar(20) not null;