Shulou(Shulou.com)06/01 Report--

Today, what the editor shares with you is what it means to appear no database selected in the database. Many people don't quite understand it. Today, in order to make you understand better, the editor summarizes the following contents. Let's look down together. I'm sure you'll get something.

What does no database selected mean?

Because you have not selected the database where the newly created table is located, no database selected means that you have not selected the database.

Method 1:

Solution: use the use statement in the format: use database_name before creating the table, so that the database is opened and you can manipulate the database.

Method 2:

When a no database selected error occurs in the operation, the database does not exist or the use database name is not used, as shown in the figure:

Solution:

1. Check whether your input data name is correct or use database name

Use mysql; / / mysql change your database name

2. If you think there is no error, you can look up all the databases in Mysql.

Select user,password,host from user

3. If you do not have the database you want in the result, you can create a new database

Use testdb

If the above methods have not solved your problem, you can also purchase cloud data products, our technicians will help solve the problem for you.

Extended data:

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

These are the details of what no database selected means, please pay more attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.