INSERT INTO 表1 (字段1,字段2,字段3,字段4) VALUES((select 字段1,字段2 from 表2 ),'字段3','字段4')
字段3,字段4是手写的,但是报错:Column count doesn't match value count at row 1
INSERT INTO 表1 (字段1,字段2,字段3,字段4)select 字段1,字段2,'111' as 字段3 ,'222' as 字段4 from 表2
也会报错:Truncated incorrect INTEGER value
咋办啊,5555555!