Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

多表查询报错 #21

Open
Lkx2217 opened this issue Oct 14, 2022 · 1 comment
Open

多表查询报错 #21

Lkx2217 opened this issue Oct 14, 2022 · 1 comment

Comments

@Lkx2217
Copy link

Lkx2217 commented Oct 14, 2022

sql.table({'node_table1': 'a', 'node_table2': 'b'}).where('id=1').select()

完全复制的示例,运行报错:(node:23224) UnhandledPromiseRejectionWarning: TypeError: opt.indexOf is not a function

@Lkx2217 Lkx2217 changed the title 联表查询报错 多表查询报错 Oct 14, 2022
@Lkx2217
Copy link
Author

Lkx2217 commented Oct 14, 2022

在补充一个:
mysql.union(mysql.table("table_1").select()).union(mysql.table("table_2").select()).select(),
这个运行的结果是:((SELECT * FROM table_1 ))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant