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

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

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

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.