1:只要已经存在表结构的
第一种方式:
CREATE TABLET1SELECT * FROM mysql.user
WHERE 1=2;
第二种方式:
CREATE TABLET2LIKE mysql.user;
mysql> CREATE TABLE t1
-> LIKE mysql.user;
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE TABLE t2
-> SELECT * FROM mysql.user
-> WHERE 1=2;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
2:表结构和数据都要的
CREATE TABLE T1
SELECT * FROM mysql.user
3:需要100W的数据量
DROP TABLE IF EXISTS testdata;
CREATE TABLE testdata
(id int,name varchar(10));
DROP PROCEDURE IF EXISTS pro_testdata;
DELIMITER &&
CREATE PROCEDURE pro_testdata(IN inr int)
BEGIN
DECLARE i INT DEFAULT 0;
START TRANSACTION;
WHILE i
INSERT INTO testdata(i