select 1 as a
union select 1 as a
union select 1 as a
union select 1 as a
union select 1 as a
union select 1 as a
union select 1 as a
union select 1 as a
我问的问题是 允许这个多少条语句合并
没看语法?上面写的[ ...n ] ] ,,,意思就是官方没限制,只要你觉得你性能允许
追问INSERT INTO mytemp VALUES(1,2),
( 1 , 0 ),
( 2 , 1 ),
( 3 , 2 ),
( 4 , 3 ),
( 5 , 4 ),
....同样这个语句的(6,5)有限制数量吗?
写的[ ...n ] ] ,,,
n的最大值没有说,但是肯定有的
有这样的语法?insert into 表 values(1,2)
insert into 表 values(2,1)如果你用values都是一行一行插入的,,,
而
INSERT
[ TOP ( expression ) [ PERCENT ] ]
[ INTO]
{ | rowset_function_limited
[ WITH ( [ ...n ] ) ]
}
{
[ ( column_list ) ]
[ ]
{ VALUES ( { DEFAULT | NULL | expression } [ ,...n ] )
| derived_table
| execute_statement
}
}
| DEFAULT VALUES
你可以看到,他的n是指里面的字段数目是n
我想问 一个语句最多可以用 多少个union.
追答。。。只能给你说官方写的是n,,,