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

This article will explain in detail the example analysis of database initialization and database server operation. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Why study the database? Benefits of the database:

Implement persistent data to local

Use a complete management system for unified management, easy to query

The concept of database:

Introduction of SQL language the advantages of SQL

1. Not a language proprietary to a particular database vendor, almost all DBMS supports SQL

two。 Simple and easy to learn

3. Although simple, it is actually a powerful language that uses other language elements flexibly and can perform very complex and advanced database operations.

The principle of storing data in database

Operation of MySQL server 1. Login and exit of the server

Login: you must open the command prompt * (for password 1234) as an administrator

Exit: exit

Common 2.MYSQL commands

1) show databases

Show all libraries (the figure shows the four libraries that come with MYSQL)

2) Open the specified library (use + specified library name;)

3) display all tables in the specified library

a. Already opened (show tables;)

B.show tables from mysql

Notice that the location is still in the test library, just looking at the table in the mysql library.

4) check which library the current location is in (select database ();)

5) create tables

6) look at the structure of the created table desc + table name

7) look at the data of the created table

View MYSQL server version

A.select version (); mysql command

B.mysql-- version dos command

This is the end of the article on "sample analysis of database initialization and database server operation". I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, please share it for more people to see.

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.