1, MySQL is an open source relational database management system (RDBMS), MySQL database system uses the most commonly used database management language-structured query language (SQL) for database management.

2.MySQL is a DBMS and a small open source relational database management system. MySQLAB was acquired by Sun Company on June 65438+1October 65438+June 2008. In 2009, SUN was acquired by Oracle Bone Inscriptions. In this way, MySQL has become another database project of Oracle.

3. In university computer textbooks, the database is explained in this way: the database is a system for managing data resources in computer application systems. There are many forms of data, such as words, numbers, symbols, graphics, images and sounds. Data is the object to be processed by all computer systems.

4.MySQL is a database tool, which is very commonly used. We usually store the data used by websites in MySQL. MySQL is not only convenient to use but also easy to learn. Let's see how to create a database using MySQL. Installation: first install MySQL and configure information.

5. The difference between database and MySQL and MySQL server is that the database contains MySQL, and MySQL server is a server as long as it works; MYSQL is short and pithy, easy to use, simple to operate and free of charge. Compared with other databases, there are more distinctive and practical grammars.

6.SQL is the abbreviation of StructuredQueryLanguage. SQL is a set of operation commands specially established for database, and it is a fully functional database language. When using it, you only need to issue the command of "what to do", and "how to do it" is not within the user's consideration.

What are the characteristics of MYSQL compared with other databases?

1), fast running and high speed are the remarkable characteristics of MySQL. In MySQL, the extremely fast B-tree disk table (MyISAM) and index compression are used. By using the optimized single scan multi-connection, the connection can be realized very quickly; SQL function is realized by highly optimized class library, and it runs very fast.

2.MySQL has excellent performance, stable service and few abnormal downtime. MySQL is open source, free from copyright restrictions, low autonomy and low use cost. MySQL has a long history and active users. You can ask for help when you encounter problems. MySQL is small, easy to install and maintain.

3. Price: MySQL is free for most individuals. Easy to use; Compared with the setting and management of other large databases, it is not so complicated and easy to learn. Portability: It can work on many different system platforms, such as Windows, Linux, Unix and MacOS.

4. Provide multilingual support, such as Chinese GB 231BIG5; ; Support large databases.

5, the biggest advantage is free, in the free database, the performance is better, and it is especially suitable for WEB applications.

6. In this version, the following new functions will be provided: new table definition file format, high-performance data copy function and more powerful full-text search function. After that, MySQL developed a secure data replication mechanism, which was implemented by MySQL on BeOS operating system, and the option of delaying the regular refresh of keywords.

Which is better, MySQL or PostgreSQL?

Reliability is the highest priority of PostgreSQL. It is famous for its rock-solid quality and good engineering design, and supports high-transaction and mission-critical applications. PostgreSQL has excellent documentation, providing a large number of free online manuals and old versions of archive reference manuals.

PostgreSQL is extremely stable, and the anti-attack ability of engines such as Innodb has made great progress in disaster scenarios such as crash and power failure. However, many MySQL users have encountered the scene that the server-level database is lost-MyISAM is the MySQL system library, and PG database is superior in this respect.

PostgreSQL is probably a pickup truck. Better than MYSQL. Especially when used, it doesn't have as many pits as MYSQL. But the problem is that it appeared too late, and the market has been completely occupied by MYSQL. . So, if you want to do a project by yourself, it's definitely better than MYSQL. .

PostgreSQL is superior to MySQL in many aspects, such as the execution of complex SQL, stored procedures, triggers, indexes and so on.

Many organizations like to use PostgreSQL because it is reliable, good at protecting data, and it is a community project and will not fall into the cage of manufacturers. MySQL is more flexible and provides more customization options for different tasks.

It is easier to transfer OracleDBA to PostgreSQL database, after all, PostgreSQL database is very similar to Oracle database. PostgreSQL supports almost all SQL standards, and the types supported are quite rich.