Using Knex to query the problem of error reporting in Mysql Database

clipboard.png
is a project written by Mini Program. "mysql" is cited from the official qcloud.js of Tencent. If you make a query like this, you will report an error

.

{"code":-1, "error": "select books . *, cSessionInfo . uesr_info from books inner join cSessioninfo on books . opnid = cSessionInfo . open_id -ER_BAD_FIELD_ERROR: Unknown column "cSessionInfo.uesr_info" in" field list""}

could you tell me how to solve this error?


solved that it should be the new knex that changed the syntax of the query

Menu