alter 用法总结

添加唯一索引alter table TG_FRIENDSHIPS add index index_friendships_followerId(followerId); 添加普通所以alter table TG_FRIENDSHIPS add unique index(friendId,followerId); 添加mysql主键alter table Books add primary key(id); 设置自增alter table Books auto_increment=1; alter