V2EX = way to explore V2EX 是一个关于分享和探索的地方
Sign Up Now For Existing Member Sign In
MySQL 5.5 Community Server MySQL 5.6 Community Server Percona Configuration Wizard XtraBackup 搭建主从复制 Great Sites on MySQL Percona MySQL Performance Blog Severalnines 推荐管理工具 Sequel Pro phpMyAdmin 推荐书目 MySQL Cookbook
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html 
This topic created in 3416 days ago, the information mentioned may be changed or developed.
class Student(db.Model):
tablename = 'students'
id = db.Column(db.Integer, primary_key=True)
student_name = db.Column(db.String(32), index=True)
mysql> alter table students drop index student_name;
提示错误： ERROR 1091 （ 42000 ）： can't drop 'student_name'; check that column/key exists
用 show index from students 看了，明明 student_name 有加索引啊，怎么去除 drop 不掉呢？(考虑到有会有很多名字重复，就不加索引了）
 | 1 nomaka Dec 22, 2016  1 show index from students 你要看 key name 是啥 你要删索引的名字 不是 字段的名字啊 |
Select Language