basic MySQL-statements fail - all the time - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Forum & Off Topic (https://python-forum.io/forum-23.html) +--- Forum: Bar (https://python-forum.io/forum-27.html) +--- Thread: basic MySQL-statements fail - all the time (/thread-19155.html) |
basic MySQL-statements fail - all the time - apollo - Jun-15-2019 hello dear staff - hello dear user - running webadmin for years now - and having troubles for months - and posting here for weeks. But the support seems to be not the best... want to run sql-commands on the newest version - but it fails all the time USE jo ; SHOW GLOBAL VARIABLES LIKE 'PORT';gives back the following Failed to execute SQL : SQL USE jo ; SHOW GLOBAL VARIABLES LIKE 'PORT'; failed : 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 'SHOW GLOBAL VARIABLES LIKE 'PORT'' at line 1while USE jo ; SHOW GRANTS FOR CURRENT_USER;gives back the following Failed to execute SQL : SQL USE jo ; SHOW GLOBAL VARIABLES LIKE 'PORT'; failed : 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 'SHOW GLOBAL VARIABLES LIKE 'PORT'' at line 1hmm - i have no ideas why the comands fail all the time!? see the manual on this sql-command: https://beginner-sql-tutorial.com/sql-use-database.htm SQL USE Statement The USE Statement is used to select a database and perform SQL operations into that database. The database remains default until end of session or execution of another USE statement with some other database. SQL USE DATABASE Statement: The Syntax for the USE Statement is: USE database_name; database_name - is the name of the database to be selected USE DATABASE Example: If you want to use database MyDatabase, the statement would be like USE MyDatabase ; btw i am running the versions - MySQL version 5.5.33 - PHP 5.6.39 look forward to see your reply RE: basic MySQL-statements fail - all the time - metulburr - Jun-16-2019 This appears to be more a MySQL issue rather than python. RE: basic MySQL-statements fail - all the time - nilamo - Jun-19-2019 How are you executing the queries? Maybe not all adapters can handle multiple queries at once? What do you get if you run it through an interactive mysql session? Or phpmyadmin? |