mysql - Why does myisAm not support row locks?

The leaf nodes of myisAm B+ tree index store row identifiers of row data, which can be located to the physical...

From [MySQLdiscussion group] 2017-06-16 09:19:35 0  1  1192

Mysql innodb lock mechanism problem please ask

Why do shared locks and exclusive locks in the same transaction not conflict? Aren't shared locks and exclusiv...

From [MySQLdiscussion group] 2017-06-16 09:19:34 0  2  981

Thread safety issues of java connection to mysql

I have been searching the Internet for N days, and there are almost no thread-safe solutions. The same problem...

From [MySQLdiscussion group] 2017-06-16 09:19:30 0  4  1168

java - mysql automatically deletes data every other day

How does mysql automatically delete data after the specified time? I am using Java to make a to-do list and us...

From [MySQLdiscussion group] 2017-06-16 09:19:28 0  7  1189

mysql - mybatis query counts the number of a certain column, group query based on a column, how to receive in xml file

Mybatis query counts the number of a certain column. According to a column, group query. I don’t know how to w...

From [MySQLdiscussion group] 2017-06-15 09:21:18 0  1  1427

mysql - Regarding the issue of time storage, do you guys use the local time or UTC time when you save the database time?

For example, when it comes to time storage, do you store the time in the database in local time or in UTC worl...

From [MySQLdiscussion group] 2017-06-15 09:21:15 0  4  1329

javascript - Failed to call methods in methods in vue

var vmm=new Vue({ {code...} }); error message window.alert = function(msg, callback) { {code...} }

From [MySQLdiscussion group] 2017-06-15 09:21:08 0  2  798

mysql optimization - How to design the index when there are order by and sum in mysql multi-table joint query?

If there is currently a SQL statement that requires a joint query between two tables and uses group by and ord...

From [MySQLdiscussion group] 2017-06-15 09:21:07 0  1  1506

When using uuid, mysql index cannot be used. Is there any solution?

For example: {Code...} does not use an auto-incrementing ID, presumably to protect privacy, but how can this d...

From [MySQLdiscussion group] 2017-06-14 10:51:38 0  1  843

After entering the account and password in mysql, a lot of content pops up but I cannot enter mysql?

1. Mysql is newly installed, and the environment variables are configured. It has been used normally for half ...

From [MySQLdiscussion group] 2017-06-14 10:51:13 0  1  1083

How to operate mysql in python to prevent your own program from being maliciously injected later (to put it bluntly, I am asking about some key points of anti-injection in python)

Is it necessary to refer to previous anti-injection documents in languages ​​​​such as php or java? Python-rel...

From [MySQLdiscussion group] 2017-06-14 10:50:54 0  2  862

mysql optimization - How to create an index using mysql fuzzy query and order by?

For example, there is a mysql statement like this: {code...} How to create an index for such a sql statement. ...

From [MySQLdiscussion group] 2017-06-14 10:50:40 0  1  1046

mysql - sql statement optimization issues

{Code...} Assuming that the amount of data in table c is millions, how to optimize these two pieces of data to...

From [MySQLdiscussion group] 2017-06-14 10:50:39 0  4  1110

mysql - How to restore tables from .idb files backed up by Alibaba Cloud

How to restore tables from Alibaba Cloud's .idb file.

From [MySQLdiscussion group] 2017-06-12 09:22:27 0  1  1022

php - Make URLs prettier?

I want to render a Chinese website and convert some special characters into "-" {code...} Like this,...

From [MySQLdiscussion group] 2017-06-12 09:21:22 0  1  857