mysql optimization - mysql innodb and myisam lock

Will innodb insert be locked? If it's locked, what's the point? In innodb, update and delete will implicitly a...

From [MySQLdiscussion group] 2017-05-24 11:34:38 0  1  970

mysql optimization - Will the mysql like statement cause a full table scan?

select id from t where name like '%abc%'

From [MySQLdiscussion group] 2017-05-24 11:34:37 0  3  1146

Does anyone have detailed tutorials on mysql5.7 installation?

I feel that installing nginx and php is relatively simple, but mysql is more troublesome. The official website...

From [MySQLdiscussion group] 2017-05-24 11:33:16 0  2  923

java - Whether users from different regions are divided into tables and groups in the database

For example, for takeout products, in order to facilitate the allocation of user orders to deliverymen, users ...

From [MySQLdiscussion group] 2017-05-24 11:33:15 0  1  699

IDEA configuration struts2 cannot load struts-default

Struts-default cannot be added to the default File Set struts-default cannot be loaded. What is the prompt mes...

From [MySQLdiscussion group] 2017-05-24 11:33:14 0  1  1125

【mysql】this is incompatible with sql_mode=only_full_group_by

This is a group by error of mysql5.7. How to solve it in a Mac environment? There are a lot of Baidu, but it s...

From [MySQLdiscussion group] 2017-05-24 11:33:12 0  1  856

mysql - How to write two SUMs with different conditions in a sql statement and find the difference between the two

The table I use in my business is the user's points log table. The fields are user id, point type (added to 1 ...

From [MySQLdiscussion group] 2017-05-24 11:33:10 0  1  834

javascript - How to avoid duplication with data in the library when inserting data in mysql?

How to avoid duplication of already inserted data when inserting data into a mysql database table? What should...

From [MySQLdiscussion group] 2017-05-24 11:33:09 0  3  778

mysql optimization - If a mysql table cannot ensure that the field column lengths are consistent, does it not need to use char?

In a data table, if the length of each data column is fixed, then the length of each data row will also be fix...

From [MySQLdiscussion group] 2017-05-24 11:33:08 0  1  757

How to solve the problem of mysql master-master synchronization and slave database out-of-synchronization?

There are now 3 mysql instances mysql-m1 mysql-s1 mysql-m2 mysql-m1 and mysql-s1 have a master-slave relations...

From [MySQLdiscussion group] 2017-05-24 11:33:07 0  2  822

php - Processing of reverse LIKE of sql statement

It is normal to use LIKE in SQL statements. But is there any reverse LIKE syntax? That is to say, it is not th...

From [MySQLdiscussion group] 2017-05-24 11:33:03 0  1  648

mysql - How to do scheduled notification and release on time in PHP?

Requirements/scenarios: For example, set an article to be published on 2018-5-22 13:51:16. Let me know in thre...

From [MySQLdiscussion group] 2017-05-24 11:33:02 0  9  937

Subquery - how mysql merges multiple rows of data into multiple columns of one row

The picture shows the data I filtered out. The statement is select time,wish_num,num from wish_num where time ...

From [MySQLdiscussion group] 2017-05-24 11:33:01 0  1  909

php - How to count the QR code of the mini program at the bottom of the official account article?

Our official account is bound to a mini program. Every time we write an article, the QR code of our mini progr...

From [MySQLdiscussion group] 2017-05-24 11:33:00 0  2  1064

mysql optimization - mysql innodb table lock problem

After testing, I found that the following situations will cause table locks 1.like 2.update,delete uncondition...

From [MySQLdiscussion group] 2017-05-24 11:32:59 0  2  714