插入多行数据时误用小括号包裹了数据所致!
INSERT INTO t_scores ( `id`, `stu_number`, `score` )
VALUES
( ( 10000, 100000, 100 ), ( 10001, 100001, 100 ), ( 10002, 100002, 100 ) )
因为用了小括号包裹,SQL判断数据应该分成单个的,报 1241 -Operand should contain 1 column(s)!
修正之后:
插入多行数据时误用小括号包裹了数据所致!
INSERT INTO t_scores ( `id`, `stu_number`, `score` )
VALUES
( ( 10000, 100000, 100 ), ( 10001, 100001, 100 ), ( 10002, 100002, 100 ) )
因为用了小括号包裹,SQL判断数据应该分成单个的,报 1241 -Operand should contain 1 column(s)!
修正之后: