Python Forum
basic MySQL-statements fail - all the time
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
basic MySQL-statements fail - all the time
#1
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 1
while

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 1
hmm - 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
Wordpress - super toolkits a. http://wpgear.org/ :: und b. https://github.com/miziomon/awesome-wordpress :: Awesome WordPress: A curated list of amazingly awesome WordPress resources and awesome python things https://github.com/vinta/awesome-python
Reply
#2
This appears to be more a MySQL issue rather than python.
Recommended Tutorials:
Reply
#3
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?
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020