create table member (
id int(10),
name VARCHAR(10),
cardid VARCHAR(20),
phone int(14),
address VARCHAR(50),
remark text,
INDEX name_index (name), # 创建索引
INDEX phone_index (phone), # 创建索引
PRIMARY key (id)); # 创建主键
insert into member values (1,‘dingning’,123,137707251,‘南京’,12);
insert into member values (2,‘hzh’,123,337707251,‘南京’,14);
insert into member values (3,‘chenwei’,123,237707251,‘上海’,13);
insert into member values (4,‘yunyang’,123,537707251,‘上海’,15);
insert into member values (5,‘WL’,123,437707251,‘杭州’,16);
show index from member; #查看索引;
drop index name_index on member; #删除索引,删除主键索引使用alter table;
alter table member add FULLTEXT (remark); # 添加fulltext的文本索引;
select * from member where MATCH(remark) AGAINST(‘vip’); #全表根据文本索引查询;