I haven't used mySQL for a long time. I suddenly thought of one, I went to the official down 4.1.7. When I installed, I found that the previous installation program was very changed, and the usefulness has improved a lot, while it may be because of the whole The reasons for SAP DB, there are many supported storage types, there are Myisam, InnoDB, BDB, Heap. I also installed MySQL Administrator, found that some configuration and operation of the database can be seen here, to It is very convenient. . At the same time, it also supports business. What makes me most is good is that when I installed, I prompt my data part, no longer asked before, didn't ask directly to put the C disk MySQL installation directory. MySQL is indeed more human. However, it may still use it in most cases, although it supports business, but the foreign key support, I feel uncomfortable, I am used to using foreign key constraints. These are not perfect, there is no stored procedure, trigger, etc., which limits its work that cannot be done with it. For open source databases, I still use postgreSQL most of the time, which is relatively perfect. Mysql's 4.1.7 main improvement seems to be a lot, according to official reports, have the following points (I will translate it, some words may not be accurate): 1. Support for subquery and table driver. Allow users to query complex datasets in a simpler and efficient way. 2. Provides faster and more flexible client-server-side protocol support for pre-inquiry statements, providing more optimized queries and improvements to warning information. 3. Provide new graphical interface installations and configuration wizards for Linux and Windows to make developers easier to install and configure the MySQL server. 4. Use the OpenSSL (GPL) encrypted client-server-side communication, which has better control over more and more malicious intrusion and unauthorized access. 5. A better optimization of embedded use in the third release software, accounting for less memory and faster processing speed. 6. Provide Unicode support for applications with local language requirements via UTF-8 and UCS2 international character sets. 7. The GIS type of industrial standard is provided to store management geographic information data. 8. Improve full text query and help form. In some small applications, I will actively use it, I look forward to it is more perfect.
