随笔分类 -  mysql

mysql查看，创建，删除索引
摘要：查看表的索引show keys from tablename为表添加索引create index indexname on tablename ( column1, column2)删除表的索引drop index indexname on tablename添加主键索引alter table tablename add primary key ( column1 ) 阅读全文
posted @ 2012-04-09 14:02 呆头鱼 阅读(200) 评论(0) 推荐(0)