It took about three days to finish reading, half a day before May Day, half a day after May Day. This book is suitable for beginners. It is relatively large and comprehensive. I think it is quite appropriate to learn MySQL. The following are some of my own experiences and conclusions. I think the specific content is simple and only provides links, hoping to help those who have a certain MySQL Foundation and want to improve.
1. Introduction
2. Install
3. Use
4. Management
5. Development
1. Introduction
MySQL is a high-performance, multi-threaded, multi-user, CS-based database system with high performance, high reliability, and easy to use. It is a lightweight database that is widely used in small and medium-sized enterprises and network applications. This book divides readers into users, managers, and developers and elaborates in detail through four parts: installation, use, management, and development.
The user is directly dealing with the database through the client. The Administrator is installing, maintaining, and upgrading the database, while the developer is using the programming language to interact with MySQL for application development. Our general role is a developer who will use a small number of management functions and must master the functions used.
2. Install
Windows Installation is very easy. You can download the MySQL exe program from the official MySQL website and click Next. After the installation is complete, you still need to configure it, there will be countless links to Baidu search "graphic MySQL installation", which will not be provided here
There are two installation methods in Linux. One is the compiled binary code, which can be installed through rpm and Deb packages. The other is to compile the binary code by yourself, and manually configure the MySQL permissions and create the default database after compilation, which is quite troublesome. If you want to learn more about MySQL, we recommend that you manually compile it once. The readme file has a detailed introduction. The general user "I don't think it is necessary" ^_^
One point to mention here is the management of the client. In addition to the clients in the command line, there are also many clients with graphical interfaces. There are three GUI tools on the official website. Here is the link, if it is only for local purposes, I think this is quite good. If you are developing network applications, the general ide will bring MySQL management tools, such as Zend studio, which is the IDE for developing PHP applications. However, I recommend using phpMyAdmin. This is an open-source PHP project for MySQL management. Put it on the corresponding web host, you can simply operate MySQL on the corresponding host, which is easy to use on the network. SourceForge has the phpMyAdmin SVN project version library on it. You can search for details by yourself. I want to carefully study the phpMyAdmin code in the future, ^ _ ^. using SVN, you can easily obtain the original version of phpMyAdmin, so open source is a good thing, we all need it ~