hallo und guten Abend,
Auf einem Webadmin - Frontend will ich die folgenden sql-Statements absetzen - aber keiner der Befehle funktioniert.
1 2 3 | USE jo ; SHOW GLOBAL VARIABLES LIKE 'PORT'; |
gibt zurück
1 2 | 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 |
während :
1 2 | USE jo ; SHOW GRANTS FOR CURRENT_USER; |
folgendes zurückgibt:
1 | 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 |
Anmerkung: jo - das ist der Name der DB
hier das manual zu diesem sql-commando:
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 es laufen die versionen auf dem Server - MySQL version 5.5.33 - PHP 5.6.39