-
Notifications
You must be signed in to change notification settings - Fork 520
Description
code: 'ER_NO_SUCH_TABLE',
errno: 1146,
sqlMessage: "Table 'bnhcp.teacher' doesn't exist",
sqlState: '42S02',
index: 0,
sql: 'SELECT i.institutionsName,e.gradeId,w.gradeTwoId,t.teacherName,t.evalPerson, p.campusesName, c.*,\n' +
" date_format(open_date,'%Y-%m-%d') open_date1, \n" +
" date_format(end_date,'%Y-%m-%d') end_date1 \n" +
' from course c \n' +
' left join teacher t on c.teacher_id = t.thacherId\n' +
' left join campuses p on t.schoolId = p.campusesId\n' +
' left join institutions i on p.campusesParentId = i.institutionsId\n' +
' left join gradeThree h on c.course_id = h.gradeThreeId\n' +
' left join gradeTwo w on h.pid = w.gradeTwoId\n' +
' left join gradeOne e on w.pid = e.gradeId\n' +
' where e.gradeId=15963594 \n' +
' ORDER BY RAND()\n' +
' limit 0,15'
}
[nodemon] app crashed - waiting for file changes before starting...
[nodemon] restarting due to changes...
[nodemon] starting babel-node server/index.js
数据库不全 能否传个全的 貌似缺少了 teacher 的表