CREATE TABLE t1
(
dt DATETIME
)
INSERT INTO t1 VALUES ('2001-01-01 11:12:13');
INSERT INTO t1 VALUES ('2001-01-02 11:12:13');
SELECT * FROM t1;CREATE TABLE t2
(
dt DATETIME
)
INSERT INTO t2 VALUES ('2011-11-11 11:12:13');
INSERT INTO t2 VALUES ('2011-11-12 11:12:13');
SELECT * FROM t2;-- 把t2内的所有数据全部插入到t1中
-- 求语句:.......DROP TABLE t1;
DROP TABLE t2;
(
dt DATETIME
)
INSERT INTO t1 VALUES ('2001-01-01 11:12:13');
INSERT INTO t1 VALUES ('2001-01-02 11:12:13');
SELECT * FROM t1;CREATE TABLE t2
(
dt DATETIME
)
INSERT INTO t2 VALUES ('2011-11-11 11:12:13');
INSERT INTO t2 VALUES ('2011-11-12 11:12:13');
SELECT * FROM t2;-- 把t2内的所有数据全部插入到t1中
-- 求语句:.......DROP TABLE t1;
DROP TABLE t2;
select * from t2
CREATE TABLE t1
(
dt DATETIME
)
INSERT INTO t1 VALUES ('2001-01-01 11:12:13');
INSERT INTO t1 VALUES ('2001-01-02 11:12:13');CREATE TABLE t2
(
dt DATETIME
)
INSERT INTO t2 VALUES ('2011-11-11 11:12:13');
INSERT INTO t2 VALUES ('2011-11-12 11:12:13');
-- 把t2内的所有数据全部插入到t1中
insert into t1
select * from t2
-- 求语句:.......
SELECT * FROM t1;
/*
dt
-----------------------
2001-01-01 11:12:13.000
2001-01-02 11:12:13.000
2011-11-11 11:12:13.000
2011-11-12 11:12:13.000
*/
DROP TABLE t1;
DROP TABLE t2;
(
dt DATETIME
)
INSERT INTO t1 VALUES ('2001-01-01 11:12:13');
INSERT INTO t1 VALUES ('2001-01-02 11:12:13');CREATE TABLE t2
(
dt DATETIME
)
INSERT INTO t2 VALUES ('2011-11-11 11:12:13');
INSERT INTO t2 VALUES ('2011-11-12 11:12:13');insert into t1 select * from t2SELECT * FROM t2;
/*
dt
------------------------------------------------------
2011-11-11 11:12:13.000
2011-11-12 11:12:13.000(所影响的行数为 2 行)
*/DROP TABLE t1;
DROP TABLE t2;
select * from t2
select * from t2