Kate SQL help: QMYSQL3 constant syntax errors

Rahul Singh <[email protected]>
Newsgroups gmane.comp.kde.devel.kwrite
Message-ID <AM8P193MB1156E2F6B5FFB9D2C8050D06FBC79@AM8P193MB1156.EURP193.PROD.OUTLOOK.COM>
Greetings team,

At the outset I would like to say a big thank you to everyone for developing such a powerful yet 
lightweight application like Kate, it truly is a work of art!

Given the powerful functionality of Kate, I am trying to use it as my front-end for my SQL 
training. As a part of this, I’m required to connect to a remote MySQL server and execute 
queries on a database. I am unable to do this, however, because of the following:

1) I connect to the MySQL server without a problem using the QMYSQL driver,
2) I execute ‘show databases;’ without a problem and am returned the databases on the server 
that I created,
3) I try to execute ‘use db_name;’, but each and every time regardless of driver (I tried QMYSQL, 
QMYSQL3, QIBASE, QMARIADB) I get returned the error “*You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the right syntax to use 
near ‘use db_name’ at line 2 QMYSQL3: Unable to prepare statement*”

I have checked online and I haven’t been able to find out why this error occurs; the only 
resource describing such an error is specific to MythTV and other resources discuss other issues 
unrelated to this one.

I’m sure I’m missing something relatively elementary, but any help with this would be greatly 
appreciated, Kate is too much fun to be forced to use another SQL frontend!

System information:
EndeavourOS kernel 5.17.5-arch1-1 (hostnamectl)
KDE plasma version 5.24.5-1 (pacman -Q plasma-desktop)
Kate version 22.04.0-1 (pacman -Q kate)
Mariadb version 10.7.3-1 (pacman -Q mysql returns mariadb(?))


PS: I read on https://kate-editor.org/support/[1] that I should request to be CC’d in answers in 
case I’m not subscribed. I would like to request that I be CC’d in answers. :)
-- 
Best regards,
*Rahul Singh*

--------
[1] https://kate-editor.org/support/
signature.asc (application/pgp-signature, 488 B)
-----BEGIN PGP SIGNATURE-----

iQEzBAABCAAdFiEEZkC+ZqKv6scmjOQNGcYDC0WZZEwFAmJ3ZeQACgkQGcYDC0WZ
ZEz9eQf9FdzdYPRq0leM57aIHVHF7GnAGVgbZUbm5cEbFHFAEXmue+U7sLihJB5I
yPCmEMmJL0fNHJ1PltWVW1T91K28FZEIazGNfmVktX3aywZqcDM64fW7g7dUDzEZ
9a4Hgav551mn7X8+F1ov90UDHRQsMBLY0pvtpz5LfYttB+fomSCXhjZrnf0xlVHU
FZg7eLHqHgvgRKOYrVNJ1CxvllNJ1EnhlxZTttVUftP7uFPF5FACnTzVWP60BJ8R
e4aUUuzdcbSBCtvNDuzaD9T+he2e11Qop2E2g1bL/Z/kZ0+SUCnt5isA88n+6oIW
FxBntjWAPtLV263QjYua+FIR/db1oQ==
=7wVY
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.