MySQL

Configure the character encoding for MySQL under Ubuntu. After installing MySQL, the system default character encoding is latin1, the input is Chinese, but the output is a bunch of garbled. Now all we have to do is set MySQL's default character

See: http://blog.yemou.net/article/query/info/tytfjhfascvhzxcyt344Multi-performance applications will decompose the associated query. Simply, you can make a single-table query for each table, and then associate the results in your application. For

See: http://blog.yemou.net/article/query/info/tytfjhfascvhzxcyt347The MySQL partitioning strategy is based on two very important assumptions: queries can filter (prunning) out a lot of extra partitions, and the partition itself does not bring many

Original: http://www.chinaz.com/program/2010/0315/108707.shtmlWorkaround:1. Change the table method.It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to

Absrtact: We often need to make a bulk insert of SQL, which requires that the record does not exist and is inserted, and the presence is not inserted. What if an INSERT statement is used?Normal Insert into

After our data is stored in the database, we want to connect the data to the Web page, read the data through the interpreter of the Web server, and then pass it to the client page.Here, I chose PHP as the interpreter for learning. Here is a detailed

MySQL (mariadb) forgot login password, prompt as follows [Email protected] ~]# mysql-uroot-penter password:error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)2. Stop MySQL[Email protected] ~]# Systemctl stop

Recently in the data migration, there was a field of type Clob, after the migrated field type of Varchar,blob converted to string data, found that there is a emoji expression exists, resulting in data migration failure. The reason for the failure is

From: http://wenku.baidu.com/link?url=J4K28e1kt-_ Ykjlsots1b5t6hkj5izl5hxskiib133avpcuxllxgkscsbsxi0ma-mpal3dndmqz-uw9ahqig1kqlekdzmuwo0xy9ozutnd7Set the password password for MySQL in WampWamp after the installation, MySQL password is empty, then

When we first built the database with MySQL administrator, the table defaults to the InnoDB type, and I don't care. Later use Access2mysql Guide data when found can only lead to myisam type of table, do not know what the difference between the two

The syntax for MySQL integer bigint, int, mediumint, smallint, and tinyint is described below:1, bigintInteger data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807), the unsigned range is 0 to18446744073709551615. A

Learning content:Basic operations for staging tables and views ...Scope of use of temporary tables and views ...1. Temporary tablesTemporary tables: temporary tables, presumably everyone knows the existence of this concept ... But when should we use

1. Optimize your query for query cachingMost MySQL servers have query caching turned on. This is one of the most effective ways to improve sex, and this is handled by the MySQL database engine. When many of the same queries are executed multiple

MySQL can view and analyze the execution of SQL statements through explain or DESC, as follows to calculate sales for all companies in 2006, to correlate sales tables and company tables, and to sum the money fields with the corresponding SQL: SQL

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M02/8B/59/wKiom1hKKK3C1V0tAAA4eVx2Dz8749.jpg "title=" icon 2. JPG "alt=" Wkiom1hkkk3c1v0taaa4evx2dz8749.jpg "/>MySQL Log audit help you find out what's wrong with you. Profile Part1 :

1) First, why should I turn on Binlog log and slow query log?Binlog log will be recorded in the database, so adding and deleting the operation, when accidentally delete, empty data, or database system error, this time you can use the Binlog log to

The first method: The hard disk may be full, clean up the junk file.The second type:View the database running status/etc/init.d/mysql statusTipserror! MySQL is running but PID file could not being foundPrint the MySQL process firstPS aux | grep

MySQL database rollback method after misoperation, mysql database Basically, Every programmer dealing with databases (or perhaps your colleagues) will have a problem. How can I roll back MySQL quickly after a misoperation? For example, if you delete

MySQL, MariaDB: Undo | Redo [convert], mariadbredo This article describes how to roam the redo logs of the InnoDB Storage engine of MySQL databases. 00-Undo LogThe Undo Log is used to implement the atomicity of transactions. In the InnoDB Storage

Frontend database record operations and frontend database records* Directory [1] Insert record [2] update record [3] Delete record [4] query expression [5] Before result Processing This article describes how to add, delete, modify, and query records