Reading time: 3~5 minutes
order
MySQL is a free, open source and small relational database management system. With the continuous improvement of database function and performance, its reliability is also increasing. Although it is free, like other commercial databases, it has the universality of database system and provides access, addition, modification, deletion or more complicated operations to the database. At the same time, the SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts the strategy of dual authorization, which is divided into community version and commercial version. Because of its small size, high speed, low total cost of ownership, especially its open source, MySQL is generally chosen as the website database for the development of small and medium-sized websites.
The following begins to introduce the construction process.
First, prepare the environment
System:
Lisi 6.5_64
Second, the installation process
Install mysql-server
2. Set the service startup.
3. Start the database service
4. Set MySQLroot user
5. Set the root password to
6. Log in to the database
7. Create the database test 1.
8. Establish a database table with xm name, xb gender and csny birth age.
9. Add database entry record, name: Li Yi, gender: male age: 1988.9.0438+0.
Book recommendation
MySQL 5.7 from entry to mastery
This book mainly includes MySQL installation and configuration, database creation, data table creation, data types and operators, MySQL functions, data query, data table operations (inserting, updating and deleting data), indexes, stored procedures and functions, views, triggers, user management, data backup and recovery, logs and performance optimization. Finally, through the database design of two comprehensive cases, the application of MySQL in practical work is further expounded.
This book focuses on practical operation and helps readers master the technology in MySQL step by step. This book has 480 examples and 14 comprehensive cases, as well as a large number of classic exercises. The downloaded file presents a video teaching video in the form of nearly 20 hours of training courses, explaining in detail every knowledge point in the book and the methods and skills of each database operation. At the same time, the download file also provides the source code of all the examples in this book, which readers can view and call directly.
This book is suitable for beginners, developers and administrators of MySQL database, and can also be used as a teaching book for teachers and students of related majors in colleges and universities.
Make reading a habit.