Jun-15-2019, 02:12 PM
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
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
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
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