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

Can I directly execute an SQL statement to insert and update the data code? #117

Open
hs205118 opened this issue Jan 8, 2024 · 2 comments

Comments

@hs205118
Copy link

hs205118 commented Jan 8, 2024

Can I directly execute an SQL statement to insert and update the data code?
For example:
Just execute
INSERT INTO t_Table(id,name) VALUES (1,'Test');

Because I need to update an existing database table with many fields, I don't want to spend a lot of time implementing its matching relationship, I just want to execute it directly with an SQL statement.

Thanks

@QxOrm
Copy link
Owner

QxOrm commented Jan 9, 2024

Hello,

Yes, you can execute custom SQL with : qx::dao::call_query()
This is explained here : https://www.qxorm.com/qxorm_en/manual.html#manual_3610

@hs205118
Copy link
Author

hs205118 commented Jan 9, 2024

Thanks, I have success to insert the data

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

2 participants