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

Below to bring you the main 10 sentences of Mysql related content, I believe you must have read similar articles. What's the difference between what we bring to everyone? Let's take a look at the text. I'm sure you'll get something after reading the 10 main sentences of Mysql.

1. Check what libraries (database) are under the current CVM?

A: show databases

two。 How do I create a database?

Answer: the database name is written at the end of create database; the semicolon ends

3. Select a database

When doing relevant operations on tables and rows, you should first select the database

Answer: write the database name after use; / / choose the corresponding database, which is strange without a semicolon.

4. You have to select a database to view the table. how to view all the tables under the library?

A: show tables

5. How to delete a database

Answer: drop database finally writes the name of the database

6. Modify the database

Can you change the name of the database?

A: no.

Does phpMyAdmin seem to have this function? He built a new library, copied all the tables to the new library, and finished deleting the old one.

7. How to create a table in a database? To build a table, you must first select a database.

Answer: create table wrote the name of the table last.

Case: create a simple table

Create table class (

Atu int

Name varchar (20)

Age int

Area varchar (20)

);

8. How do I change the table name?

Answer: rename table old table name to new table name

9. How to delete a table?

Answer: drop table table name

10. How do I view the results of the table? Description can be abbreviated to desc

Answer: desc table name

For the above 10 main sentences about Mysql, do you think they want them? If you want to know more about it, you can continue to follow our industry information section.

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.