mysql 复制表

https://www.runoob.com/mysql/mysql-clone-tables.html
https://www.cnblogs.com/jpfss/p/10410928.html

复制表

create table c select * from users;

create table d select user_name,user_pass from users where id=1;

另一种完整复制表的方法:

CREATE TABLE targetTable LIKE sourceTable;
INSERT INTO targetTable SELECT * FROM sourceTable;

其他:

可以拷贝一个表中其中的一些字段:

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
)

https://www.runoob.com/mysql/mysql-clone-tables.html

information_schema.COLUMNS

select COLUMN_NAME from information_schema.COLUMNS where table_name = ‘your_table_name‘ and table_schema = ‘your_db_name‘;

mysql datetime

select now();
SELECT curdate();

select date_sub(curdate(),interval 1 day);

原文：https://blog.51cto.com/11114389/2537803