How is this MYSQL? As soon as importing data to the database is concerned
Source: Internet
Author: User
What's wrong with MYSQL? A problem occurs when importing data to the database. what happened to MYSQL? It is also a problem when importing data to the database. it is obvious that no database is selected and no database is selected. Before import: usedatabase;, tables must be created in the database. you must first create a database, then use the database, and then execute the preceding SQL. what's wrong with MYSQL? A problem occurs when importing data to the database,
What's wrong with MYSQL? A problem occurs when importing data to the database,
------ Solution --------------------
Obviously, no database is selected.
------ Solution --------------------
No database is selected. Before import: use database;
------ Solution --------------------
To create a table in the database, you must first create a database, then use the database, and then execute the preceding SQL statement.
------ Solution --------------------
#1046 no database selected
Because you did not export data by database, you must first enter the database where you want to import the table before importing the data.
------ Solution --------------------
The error message is clear.
------ Solution --------------------
Add the following to your database. SQL file:
Create database /*! 32312 if not exists */'mydb '/*! 40100 default character set utf8 */;
USE 'yourdb ';
------ Solution --------------------
Yes. you should first enter the database and then import
But does your zj table already exist?
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.