执行sql：
INSERT INTO user_info(name, age) VALUES (( SELECT u.name FROM user_info u where u.id = 4), 10)
操作成功
执行sql：
INSERT INTO user_info(name, age) VALUES (( SELECT u.name,u.age FROM user_info u where u.id = 4))报错[SQL] INSERT INTO user_info(name, age) VALUES (( SELECT u.name,u.age FROM user_info u where u.id = 4))[Err] 1241 - Operand should contain 1 column(s)
问题insert into（c1,c2…… c10） values （v1，v2, (select c3,c4……，c9) from table where 1=1), v10 ）,
（v1，v2, (select c3,c4……，c9) from table where 1=1), v10 ）, （v1，v2, (select c3,c4……，c9) from table where 1=1), v10 ） …… sql语句不能执行！？
-- ------------------------------ Table structure for `user_info`-- ----------------------------DROP TABLE IF EXISTS `user_info`;CREATE TABLE `user_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `age` int(11) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='用户表';-- ------------------------------ Records of user_info-- ----------------------------INSERT INTO `user_info` VALUES ('1', 'aaa', '44');INSERT INTO `user_info` VALUES ('2', 'bbb', '55');INSERT INTO `user_info` VALUES ('3', 'ccc', '66');INSERT INTO `user_info` VALUES ('4', 'aaa', '55');INSERT INTO `user_info` VALUES ('5', 'bbb', '66');INSERT INTO `user_info` VALUES ('6', 'aaa', '10');INSERT INTO `user_info` VALUES ('7', 'aaa', '10');