Mysql (entry level) _ MySQL

Mysql selects the corresponding storage engine for different data. mysql also selects the corresponding storage engine for different data processing. mysql also selects some of the corresponding storage engine mysql for different data processing. grant) generally, the user table in mysql selects a storage engine for different data in mysql.

Mysql also selects the storage engine for different data processing.

Mysql also selects the storage engine for different data processing.

In mysql, grant is usually performed in the user table of mysql.

The authorization issues in mysql can be very detailed, and users can be granted with the permissions you want them to have.

Common mysql engines include innoDB, CSV, myISAM...

The distributed storage and access of data in mysql can be allocated with the same operation permissions for similar users, so that each database can work with each other to achieve the highest efficiency.

Mysql also has a lot of corresponding data backup operations. you must first understand the principles

The cache in mysql is also very important for data access.

In mysql, you can add extension statements at the end of the Create Table statement, such as TYPE = MyISAM (or ENGINE = INNODB) to specify the engine type of the current target.

In mysql, you can use show table status from DBname to view the engines of tables in the current database.

The performance of different mysql engines varies depending on different business processes!

Mysql obtains the system time: select now (), select current_date, select current_time. the timestamp of the system is UNIX_TIMESTAMP (datetime)

Set names utf8

Mysql Query result setting encoding is set character_set_reasults = UTF-8

When mysql is called in C, the gcc-o str is considered during compilation. c-I/usr/include/mysql-L/usr/lib64/mysql-lmysqlclient-lz-lm (lib64 for lib)

Applications must have their own protocols for communication. Therefore, if you want to access mysql, you must also know the mysql protocol. however, generally, to save time and labor, the protocols are encapsulated.

If a function is used in mysql, NULL may occur. the default value is NULL = 0. select min (column ), "tpye" as BBB from XXX database does not have corresponding data, it will appear, Null type

Set and display all characters in mysql. show variables like "charac %" shows all codes.

Mysql data | tx_isolation | the REPEATABLE-READ adjusts the transaction level

Mysql Query result transfer to document (select * from XXX into outfile "PATH ")

Mysql connection problems L Host 'www .helloheaven.com 'is not allowed to connect to this MySQL serverConnection closed by foreign host is a mysql authorization problem