//虚拟数据库
+----------+
1 row in set (0.00 sec)
mysql> use mytest;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql> CREATE TABLE IF NOT EXISTS `user` (
-> `id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
-> `name` varchar(20) NOT NULL DEFAULT '' COMMENT '姓名',
-> `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
-> PRIMARY KEY (`id`)
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Query OK, 0 rows affected (0.08 sec)
Database changed
mysql> show tables;
+----------------+
(北联网教程,专业提供视频软件下载)
……