1、create table t_name select ...
2、create table t_name like ...
第一种会取消掉原来表的有些定义,且引擎是系统默认引擎。
手册上是这么讲的:Some conversion of data types might occur. For example, the AUTO_INCREMENT attribute is not preserved, and VARCHAR columns can become CHAR columns.
第二种就完全复制原表。
先建立测试表:
mysql> create database dbtest;
Query OK, 1 row affected (0.03 sec)
mysql> use dbtest;
Database changed
mysql> create table t_old
-> id serial,
-> content varchar(8000) not null,
-> `desc` varchar(100) not null)
-> engine innodb;
Query OK, 0 rows affected (0.04 sec)
mysql> show create table t_old;
+-------+-------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------+
| t_old | CREATE TABLE `t_old` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`content` varchar(8000) NOT NULL,
`desc` varchar(100) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------+
1 row in set (0.00 sec)
第一种方式:
mysql> create table t_select select * from t_old where 1 = 0;
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show create table t_select;
+----------+--------------------------------------------+
| Table | Create Table +----------+---------------------------------------------+
| t_select | CREATE TABLE `t_select` (
`id` bigint(20) unsigned NOT NULL default '0',
`content` varchar(8000) NOT NULL,
`desc` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+----------+-------------------------------------------+
1 row in set (0.00 sec)
第二种方式:
mysql> create table t_like like t_old;
Query OK, 0 rows affected (0.02 sec)
mysql> show create table t_like;
+--------+-------------------------------------------------+
| Table | Create Table |
+--------+-------------------------------------------------+
| t_like | CREATE TABLE `t_like` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`content` varchar(8000) NOT NULL,
`desc` varchar(100) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+--------+-------------------------------------------------+
1 row in set (0.00 sec)
mysql>
(责任编辑:卢兆林)
Facebook称中文网用户已达28万
2008-06-25 10:08
如何正确理解PHP程序错误信息的表示含义
2008-06-25 08:32
微软专家预测2008安全趋势 多数已获证实
2008-06-25 08:11
善用防火墙 让Windows Vista网络更安全
2008-06-25 08:06
专家称应警惕国外软件留尾巴
2008-06-25 08:01
近期警惕黑客利用高考查分信息散播病毒木马
2008-06-25 07:56
Sun:预计年底之前将公开全部Java源代码
2008-06-24 09:06
Linux与Windows系统相结合 IBM Akka问世
2008-06-24 07:59
科技时代意见反馈留言板
电话:010-82628888-5595 欢迎批评指正
新浪简介
|
About Sina
|
广告服务
|
联系我们
|
招聘信息
|
网站律师
|
SINA English
|
会员注册
|
产品答疑