错误1064-MySQL中用于INSERT语句的SQL语法

||                                                                                                                       
已邀请:
        除非MySQL支持非常奇怪的语法,否则这不是您编写INSERT语句的方式。它采用以下形式:
INSERT INTO <TableName> (<Column1,Column2,..,ColumnN>) VALUES (<Value1,Value2,..,ValueN>)
所以你会
INSERT INTO database_charts.university_has_single_user (
  university_id_university, 
  single_user_users_id_user, 
  course_id_course,year) 
VALUES (
  (SELECT id_university FROM university WHERE university = \'xxx\'),
  (SELECT users_id_user FROM single_user WHERE users_id_user = \'1\' ),
  (SELECT id_course FROM course WHERE course = \'yyy\'),
  \'2000\'
)
警告:我不确定MySQL是否会为每个列值实际处理嵌套的SELECT,但是以上是通常编写INSERT语句的方式。     
        
INSERT INTO TABLE2 (TABLE2_FIELD)
  SELECT TABLE1_FIELD
  FROM TABLE1 
  WHERE TABLE1_SOMEFIELD IS \'SOMETHING\'
更多内容请参见http://dev.mysql.com/doc/refman/5.6/en/insert-select.html     

要回复问题请先登录注册