各种sql语句

索引

唯一索引

ALTER TABLE `schooldb`.`student` 
ADD UNIQUE INDEX `only_phone`(`phone`) USING BTREE COMMENT '唯一手机号';

全局索引

ALTER TABLE `schooldb`.`student` 
ADD FULLTEXT INDEX `only_phone`(`phone`) USING BTREE COMMENT '唯一手机号';

一般索引

ALTER TABLE `schooldb`.`student` 
ADD INDEX `only_phone`(`phone`) USING BTREE COMMENT '唯一手机号';

空间索引

ALTER TABLE `schooldb`.`student` 
ADD SPATIAL INDEX `only_phone`(`phone`) USING BTREE COMMENT '唯一手机号';

新建数据库

CREATE DATABASE `schoolDb` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';