Mysql slow query log content viewing problem

The slow query log is enabled in mysql, but I often see such a query in the log. I don’t know what it means. I...

From [MySQLdiscussion group] 2017-06-28 09:23:21 0  2  972

What is the error in the MySQL create table structure statement?

(www.sf.gg) is China's leading developer technology community. We hope to provide a pure, high-quality technic...

From [MySQLdiscussion group] 2017-06-26 10:49:29 0  3  972

分页显示 - MySQL分页查询，是用LIMIT m,n，还是先查出所有ID再在前端分页？

用传统的LIMIT m, n做分页查询需要这么几步： 用SELECT COUNT(*) FROM table WHERE condition ORDER BY ...查到总数并算出有多少页； 用SELECT column...

From [MySQLdiscussion group] 2017-04-17 16:38:37 0  6  972

.NET Framework does not support character set 'utf8mb3': System.NotSupportedException

I'm trying to run a server with a MySQL database, but I keep getting this huge error and I don't know why. [21...

From [MySQLdiscussion group] 2023-10-19 17:44:27 0  2  970

在Linux环境下使用Hibernate获取MySql数据库中的数据出现中文乱码

今天使用Hibernate读取Mysql数据库中的数据时出现中文乱码，我尝试过修改配置和修改Mysql数据库编码，但是都不起作用，仍然有显示中文乱码。这是mysql的编码：这个是数据库的编码：这是各个表的编码（均指定了编...

From [MySQLdiscussion group] 2016-11-12 09:13:38 0  2  970

The mysql in the php tool is still below 5.1. How can I upgrade it to above 5.1?

The mysql in the php tool is still below 5.1. How can I upgrade it to above 5.1? Thanks

From [MySQLdiscussion group] 2017-10-28 16:24:18 0  2  965

mysql - 执行大量SQL进行批量插入或更新，开启事务执行会提高执行速度还是降低执行速度？

执行大量SQL进行批量插入或更新，开启事务执行会提高执行速度还是降低执行速度？

From [MySQLdiscussion group] 2017-04-17 15:42:32 0  1  965

Mycat configures sub-tables, the underlying mysql, an array overflow exception occurs in the query, what is the reason?

Start mycat normally and configure sub-tables. This exception occasionally occurs when querying. Have you enco...

From [MySQLdiscussion group] 2017-06-24 09:42:15 0  1  964

为什么删除了主键primary之后唯一约束会变成主键约束？

为什么删除了主键primary之后唯一约束会变成主键约束？还有为什么删除不了？必须要有约束们

From [MySQLdiscussion group] 2016-12-21 17:47:37 0  2  963

java - Online application, what should be done if the database operation fails?

I would like to ask for advice on online application. If the database operation (insert, update, delete) fails...

From [MySQLdiscussion group] 2017-06-28 09:23:37 0  4  961

php - 数据库与逻辑应用分离的情况下怎么保证信息同步，或者叫安全

我不太明白这个词怎么表达 是这样的，现在有一台服务器运行数据库（server），另外一台运行php程序（client），浏览器(Browser)访问client，然后client逻辑判断后通过http协议对server中...

From [MySQLdiscussion group] 2017-04-17 16:48:34 0  6  961

怎么搭建最小MySQL环境？

怎么搭建最小MySQL环境？

From [MySQLdiscussion group] 2017-02-13 10:18:16 0  2  959

MySQL 字段默认值 一般设null 还是空字符串？

MySQL 字段默认值 一般设null 还是空字符串？设nul 和空字符串的区别是什么，各有什么优缺点。

From [MySQLdiscussion group] 2017-04-17 14:39:43 0  3  958

mysql - Now that I have used CommandArgument to get the value of t_ID, I now want to get the value of t_Name and put it into the sql statement in the cs file. What should I do?

<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemComma...

From [MySQLdiscussion group] 2017-06-30 09:53:20 0  1  957

mysql导入速度慢

大约有三四千万条记录，使用mysqldump导出，在本地导入的时候（使用source xxx.sql的方式），感觉很慢，到某表一条记录可能比较大，才一次insert3000+条,平均用二三十秒。本地的目标数据库的参数in...

From [MySQLdiscussion group] 2017-04-17 13:07:25 0  3  956