1. 给表创建索引
CREATE [unique] INDEX index_name ON table_name(column_list);
unique:指定索引列中值必须是唯一的(主键id)
index_name:索引名称
table_name:将要建立索引的表
column_list:将要建立索引的列,可以是多列,那样的索引叫组合索引
2. 给表添加字段
alter table table_name add column_name varchar(20) default null ;
3.增删改查语句
插入语句
写法1:
insert into table_name(column_name1,column_name2,column_name3) values(?,?,?);
写法2:
insert into table_name set column_name1 = ?,column_name2 = ?,column_name3 = ?;
删除语句
delete from table_name where id = ?
更新语句
update table_name set column_name1 = ?,column_name2 = ?,column_name3 = ? where id = ?;
查询语句
select * from table_name where id = ?;