- ql语句:show create table tablename;
- 例如:
- 要查看jos_modules表结构的命令:
- show create table jos_modules;
- 查看结果:
- mysql> show create table jos_modules;
- jos_modules | CREATE TABLE `jos_modules` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` text NOT NULL,
- `content` text NOT NULL,
- `ordering` int(11) NOT NULL DEFAULT '0',
- `position` varchar(50) DEFAULT NULL,
- `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
- `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `published` tinyint(1) NOT NULL DEFAULT '0',
- `module` varchar(50) DEFAULT NULL,
- `numnews` int(11) NOT NULL DEFAULT '0',
- `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `params` text NOT NULL,
- `iscore` tinyint(4) NOT NULL DEFAULT '0',
- `client_id` tinyint(4) NOT NULL DEFAULT '0',
- `control` text NOT NULL,
- PRIMARY KEY (`id`),
- KEY `published` (`published`,`access`),
- KEY `newsfeeds` (`module`,`published`)
- ) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=utf8
- 3、use information_schema;select * from columns where table_name='tablename'
- 例如:
- 要查看jos_modules表结构的命令:
- use information_schema;
- select * from columns where table_name='jos_modules';
- 查看结果:
- 略。
查看mysql表结构和表创建语句的方法
最新推荐文章于 2024-06-22 21:31:42 发布