1.插入多条记录
insert into test.new_table(t1) values('1'), ('2');
2.复制表结构及数据 create table test.tb2 SELECT * FROM test.new_table; 3.连接字符串函数 select concat(t1,t2) from test.new_table
4.limit 函数分页
SELECT * FROM test.new_table limit 0,2;
1.插入多条记录
insert into test.new_table(t1) values('1'), ('2');
2.复制表结构及数据 create table test.tb2 SELECT * FROM test.new_table; 3.连接字符串函数 select concat(t1,t2) from test.new_table
4.limit 函数分页
SELECT * FROM test.new_table limit 0,2;