Absolute novice MYSQL entry

xiaoxiao2021-03-06  15

Install RH9, select the mysql package. Log in to the shell, run mysql (lowercase) to enter the MySQL environment.

Just come in, I don't understand anything, you can use / h to display help information.

There is a command very good show. Come use:

Show database; (to use; indicate the end of the command, otherwise waiting for you to enter)

You can now see all databases in the system

Take a query:

Use DatabaseName; The default is called TEST, and a named mysql.

After the USE command, set the database to the current database. Ok, you can use the following command:

Show tables Displays all table names.

The situation inside is very clear now. You can do the first query:

SELECT * FROM table name. . . .

Now, complete the first query is not! ! ! Haha.

转载请注明原文地址:https://www.9cbs.com/read-46996.html

New Post(0)