页次: 1
使用show 命令可以查看
show create database www_ipbbs_net; show create table www_ipbbs_net.tb_001;
上面代码, 第一行用来查看 数据库 www_ipbbs_net 创建的语句,
第二句用来查看 创建表tb_001 的语句
常用show 还有
查看错误的警告
show errors ; show warnings;
测试代码
mysql> use www_ipbbs_net; Database changed mysql> create table tb_001 (name varchar(80)); Query OK, 0 rows affected (0.09 sec) mysql> show create database www_ipbbs_net; +---------------+--------------------------------------------------------------------------+ | Database | Create Database | +---------------+--------------------------------------------------------------------------+ | www_ipbbs_net | CREATE DATABASE `www_ipbbs_net` /*!40100 DEFAULT CHARACTER SET latin1 */ | +---------------+--------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show create table www_ipbbs_net.tb_001; +--------+--------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------+--------------------------------------------------------------------------------------------------+ | tb_001 | CREATE TABLE `tb_001` ( `name` varchar(80) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +--------+--------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
ipbbs.net
离线
页次: 1