MySQL 新建表

/*
**新建表
*/
CREATE TABLE IF NOT EXISTS TUser
(
    FID INT PRIMARY KEY AUTO_INCREMENT,
    FName VARCHAR(50) DEFAULT '',
    FAddTime DATETIME DEFAULT NOW()
    /* ,PRIMARY KEY (FID) */
) 
ENGINE = INNODB DEFAULT CHARSET=utf8;

 

-- 复制表
CREATE TABLE TUser_bak
SELECT * FROM TUser;


-- 复制表(如果新表名称还不存在)
CREATE TABLE IF NOT EXISTS TUser_bak
SELECT * FROM TUser;

 

 

/*
**复制表
*/
CREATE TABLE TUser_bak
LIKE TUser;

INSERT INTO TUser_bak
SELECT * FROM TUser;