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? As soon as importing data to the database, there is a problem. ------ solution ------------------ obviously no database is selected ------ solution ------------------ no database is selected. Before import: usedatabase; ------ solution -------------------- The table is to be created. what happened to 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?

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.