2013年5月16日

mysql key mul - 看不懂

摘要: http://dev.mysql.com/doc/refman/5.1/en/show-columns.htmlThe Key field indicates whether the column is indexed:If Key is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, non-unique index.If Key is PRI, the column is a PRIMARY KEY or is one of the 阅读全文

posted @ 2013-05-16 22:38 simhare 阅读(1326) 评论(0) 推荐(0) 编辑

mysql show create table `tablename` 查看建表语句

摘要: mysql> show create table tb_common_member;+------------------+----------------------------------------------------+| Table | Create Table |+------------------+----------------------------------------------------+| tb_common_member | CREATE TABLE `tb_common_member` ( `uid` mediumint(8) unsigned NO 阅读全文

posted @ 2013-05-16 22:27 simhare 阅读(11765) 评论(0) 推荐(0) 编辑

导航