Shulou(Shulou.com)05/31 Report--

This article mainly introduces the Mysql basic example analysis, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

During this period of time, in doing a Web project, we need to use Mysql, but the database foundation is really not good.

Because I have been using an IDE connection, I have never used a command. So at the beginning is to learn the Mysql command, the first is to log in:-u xxx-p, and then enter, prompt you to enter the password, enter the password and then enter the enter, you will enter the database. The next thing you want to see is all the database in this database. You can use show databases, and you will see all the database.

+-+

| | Database |

+-+

| | information_schema |

| | hibernate_test |

| | mysql |

| | performance_schema |

| | return_back |

| | test |

+-+

Use the use test command to select the database of test

Mysql > use test

Database changed

The next step is to see which tables are in test:

Mysql > show tables

+-+

| | Tables_in_test |

+-+

| | people |

+-+

To view the details of the people table, you can use the describe people command:

Mysql > describe people

+-+ +

| | Field | Type | Null | Key | Default | Extra | |

+-+ +

| | id | int (11) | NO | PRI | NULL | auto_increment |

| | name | varchar (100) | YES | | NULL | |

| | pop | int (11) | YES | | NULL |

| | founded | date | YES | | NULL |

+-+ +

If I want to view the data in the table, I use: select * from people

Mysql > select * from people

+-- +

| | id | name | pop | founded | |

+-- +

| | 1 | Houston | 3000000 | NULL |

+-- +

Then I learned some simple things like creating tables, querying, updating, and so on.

Thank you for reading this article carefully. I hope the article "Mysql basic sample Analysis" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.