MySQL

MySQL 5.1 supports table-level locking of MyISAM and Memory tables, page-level locking of BDB tables, row-level locking of InnoDB tables. In many cases, you can guess what type of lock the application uses best, based on training, but it is

MySQL delimited character connection Concat_ws and concat MySQL Tutorials > select Concat_ws ('-', ' 123 ', 456, ' 789 ');+--------------------------------+| Concat_ws ('-', ' 123 ', 456, ' 789 ') |+--------------------------------+| 123-456-789 |+-

As shown in the following figure, the remote database connection prompt is "Can't connect to MySQL server (10060 ).When this problem occurs, we first make an analysis of the reasons for this situation:A. bind-address limits the connected ip

Optimize the table data typeThe data type used by the table depends on the application. Although the length of fields must be redundant during application design, it is not recommended to leave a large number of redundant fields, which wastes

In mysql, both MyISAM and InnoDB storage engines support foreign keys. However, MyISAM only supports syntax, but cannot be used. The following example shows how to use the Chinese and foreign keys of InnoDB:Create a master table:Mysql> create table

EnvironmentMySQL version:Mysql> select version ();+ ---- +| Version () |+ ---- +| 5.6.30-log |+ ---- +1 row in set (0.05 sec)Ensure that the master and slave nodes have been synchronizedSlave_IO_Running: YesSlave_ SQL _Running:

Solution to slow mysqldump importThe SQL statement exported from MySQL may be very slow during import. It took nearly three hours to import only 0.45 million records. Using a few parameters properly during export can greatly speed up import.-E uses

MySQL only supports a small subset implemented by most regular expressions.----------------------9.2.1 basic character matchingWhat follows REGEXP is processed as a regular expression. SELECT prod_nameFROM productsWHERE prod_name REGEXP

This method only describes how to save the table name (data is not recovered). If you want to restore the original data, use extundelete to restore the file and put it back.In addition, it is suitable for storing the full-backup frm and idb files

I. Import(1) select the data block to be imported (multiple columns)(2) copy the selected data block to another new table workbook, and then "save as"-> "text file (*. txt)".(3) Create a mysql database and data table, and enterCreate a MySql

The following error occurs when MySQL executes the GRANT command.Mysql> grant all on *. *...ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)Investigation contentMysql. user tableIf you accidentally clear the

The execution efficiency of mysql statements affects the operation of the entire website. It is vital to check the efficiency of mysql statements at any time. Using the EXPLAIN keyword can let you know how MySQL processes your SQL statements, it

Here is a brief introduction of the differences between the two and the conversion method:MyISAM: MyISAM is the default database storage engine of MySQL 5.5. MYISAM provides high-speed storage and retrieval, as well as full-text search capabilities,

Sometimes, we need to copy the data in the entire column of a field to another new field, which is very simple. The SQL statement can be written as follows:UPDATE tb_1 SET content_target = content_source;The syntax is as follows:Update {your_table}

In mysql databases, the replace command is a very useful tool to replace strings and is also the most commonly used tool for programmers. The replacement format isMySQL Replace function syntax:Update TABLE_NAME set field name = replace (field name, "

In my testing environment, data is basically synchronized in an instant and I hope it will be helpful to you.Redhat 9.0Mysql3.23.57Mysql data synchronization backupServer A: master server 192.168.1.2Server B: 192.168.1.3 slave server slaveServer A

In the process of website migration, apart from packaging and transferring website files, the biggest headache is MySQL export and import. If the database is not large, it is very convenient to import and export PHPMyAdmin. Once the database is

Sometimes you will find that binlog suddenly becomes very large, resulting in full disk partitions. At this time, you need to first clear binlog. When clearing binlog, if there is an active slave server, if the server is currently reading one of the

Open the downloaded installation file and the following page is displayed:Start the mysql installation wizard and click "next" to continue the next step.Select the installation type, which has three options: "Typical (default)", "Complete (Complete)"