1. 下面这个语句会拷贝表结构到新表newadmin中。 (不会拷贝表中的数据)
CREATE TABLE newadmin LIKE admin
2. 下面这个语句会拷贝数据到新表中。 注意:这个语句其实只是把select语句的结果建一个表。所以newadmin这个表不会有主键,索引。
- CREATE TABLE newadmin AS
- (
- SELECT *
- FROM admin
- )
- CREATE TABLE newadmin LIKE admin;
- INSERT INTO newadmin SELECT * FROM admin;
- CREATE TABLE newadmin AS
- (
- SELECT username, password FROM admin
- )
- CREATE TABLE newadmin AS
- (
- SELECT id, username AS uname, password AS pass FROM admin
- )
- CREATE TABLE newadmin AS
- (
- SELECT * FROM admin WHERE LEFT(username,1) = 's'
- )
- CREATE TABLE newadmin
- (
- id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
- )
- AS
- (
- SELECT * FROM admin
- )