In fact, I made a very serious mistake, and this mistake can only be reported for two reasons.
Reason 1: There is an extra space after your account password, which means you have the wrong database.
Fix: If it is a login password, report this error, as shown in the figure below:
It would be possible to have an extra space between p and 123, and then you would remove the space in between. You put p and 123 together and you type in p123
Reason 2: Your syntax is wrong, because use can only be followed by the database name, never the table name. An incorrect or incorrect table name will report the following error.
Solution: Double check your database to see if it has TB_EMP6.
Check your table again to see if it is your table name.
The name of the table is confused with the database name.
Summary is to confirm the database name is not exist, there are no spelling mistakes, if not again to see your grammar is not wrong.
This is better to locate your problem, in fact, to put it bluntly this is I made a stupid mistake, but also eat a catty gain a wisdom.
Hope to help you, welcome to leave a message to exchange ~
Reason 1: There is an extra space after your account password, which means you have the wrong database.
Fix: If it is a login password, report this error, as shown in the figure below:
It would be possible to have an extra space between p and 123, and then you would remove the space in between. You put p and 123 together and you type in p123
Reason 2: Your syntax is wrong, because use can only be followed by the database name, never the table name. An incorrect or incorrect table name will report the following error.
Solution: Double check your database to see if it has TB_EMP6.
Check your table again to see if it is your table name.
The name of the table is confused with the database name.
Summary is to confirm the database name is not exist, there are no spelling mistakes, if not again to see your grammar is not wrong.
This is better to locate your problem, in fact, to put it bluntly this is I made a stupid mistake, but also eat a catty gain a wisdom.
Hope to help you, welcome to leave a message to exchange ~
Read More:
- MySQL appears: ERROR 1049 (42000): Unknown database’XXX’ solution
- An error is reported when kettle connects Oracle database and MySQL database
- How to view the version of MySQL database
- Solve the database connection failure of Discuz! Database error (1045) notconnect Forum
- Unknown error (SQLite code 14): could not open database (How to Fix)
- Solve MySQL installation error: initializing database prompts an error when installing mysql
- How to Solve mybatis returns null when querying Oracle database with char type field
- Solve the problem of MySQL database report 1055 error
- 1716438 – Error :” Failed to load database information Details: The Database connector crdb_bwquery.
- Hive: How to Solve dearby database initialization error
- PHP connection to MySQL database error: call to undefined function MySQL_ connect()
- An error is reported when logging into mysql. The error message is error 1049 (42000): unknown database ‘XXXXXX’
- The problem of MySQL database connection failure errno: 1049 error
- (error when importing database): MySQL 2006-mysql server has gone away
- java.lang.ClassNotFoundException : com.mysql.jdbc . driver project cannot connect to database, exception, lack of MySQL driver
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mysql’
- An error is reported when the jeecg boot project connects to the MySQL database running on docker
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used
- An error occurs when superstet connects to the Clickhouse database: error: could not load database driver: Clickhouse
- How to Fix Error in module RSQL of the database interface