展开全部
下面这个不知是否可行:create table books(`32313133353236313431303231363533e4b893e5b19e31333332643834id` int, `name` varchar(16),`type` varchar(16));
insert into books(`id`,`name`,type)
select 1 as `id`, 'book11' as `name`, 'type1' as `type`
union all
select 2, 'book12', 'type1'
union all
select 3, 'book13', 'type1'
union all
select 4, 'book14', 'type1'
union all
select 5, 'book15', 'type1'
union all
select 6, 'book21', 'type2'
union all
select 7, 'book22', 'type2'
union all
select 8, 'book23', 'type2'
union all
select 9, 'book24', 'type2'
union all
select 10, &