mysql加索引和常用sql语句

alter table baominginfo表名 add unique (id_card,gg,gh,..)字段名 ; 添加索引
ALTER TABLE baominginfo ADD INDEX sex索引名( sex列名 ) 添加普通索引
ALTER TABLE baominginfo DROP INDEX sex; 删除普通索引

insert into testb (name) VALUES (‘ba’);
DELETE from testb where id=3

alter table testb drop COLUMN id 删除列,删除字段
ALTER table testb add COLUMN id int not null PRIMARY key auto_increment; 添加字段