diver
15.06.19, 15:32
hallo und guten Abend,
Auf einem Webadmin - Frontend will ich die folgenden sql-Statements absetzen - aber keiner der Befehle funktioniert.
USE jo ;
SHOW GLOBAL VARIABLES LIKE 'PORT';
gibt zurück
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 :
USE jo ;
SHOW GRANTS FOR CURRENT_USER;
folgendes zurückgibt:
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 i es laufen die versionen auf dem Server
- MySQL version 5.5.33
- PHP 5.6.39
Auf einem Webadmin - Frontend will ich die folgenden sql-Statements absetzen - aber keiner der Befehle funktioniert.
USE jo ;
SHOW GLOBAL VARIABLES LIKE 'PORT';
gibt zurück
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 :
USE jo ;
SHOW GRANTS FOR CURRENT_USER;
folgendes zurückgibt:
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 i es laufen die versionen auf dem Server
- MySQL version 5.5.33
- PHP 5.6.39