mysql - eclipse中mysql的错误语法是什么

Question

String queryString = "select DISTINCT students.firstName, teacher.firstName, Course.title" + 
  " from Student,Faculty,Course ,(select Student.ssn, Student.firstName, Enrollment.courseId" + 
  "from Enrollment, Student" + 
  "where Enrollment.ssn = Student.ssn )as students," + 
  "(select Faculty.ssn, Faculty.firstName, TaughtBy.courseId" + 
  "from TaughtBy, Faculty where TaughtBy.ssn = Faculty.ssn )as teacher" +
  "where Student.ssn = ?  and Faculty.ssn = ? and students.courseId = teacher.courseId" ;

此 sql 查询在 sql server 中有效，但在 mysql 中无效。请帮助我!

Answer 1

你必须遇到空格，请尝试在双引号之后或之前使用空格，例如:

String queryString = "select DISTINCT students.firstName, teacher.firstName, Course.title"+ " from Student,Faculty,Course ,(select Student.ssn, Student.firstName, Enrollment.courseId"+ " from Enrollment, Student"+" where Enrollment.ssn = Student.ssn )as students,"+" (select Faculty.ssn, Faculty.firstName, TaughtBy.courseId"+ " from TaughtBy, Faculty where TaughtBy.ssn = Faculty.ssn )as teacher"+ " where Student.ssn = ? and Faculty.ssn = ? and students.courseId = teacher.courseId" ;