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  1014

mysql - 关于数据逻辑删除的问题？

我在表中逻辑删除了一条数据，表中存在唯一索引的字段，逻辑删除后，我有要insert一条一样的数据，这样肯定不行，如何解决这个问题？

From [MySQLdiscussion group] 2017-04-17 13:53:20 0  3  1014

sql注入是什么意思？

听到别人提到了  不知道什么意思新手求勿喷。。。

From [MySQLdiscussion group] 2016-12-20 16:49:51 0  2  1011

Open the database management of the environment, but the page cannot be found.

报以下错误:Not FoundThe requested URL /phpMyAdmin4.8.5 was not found on this server.Additionally, a 404 Not Found e...

From [MySQLdiscussion group] 2020-10-27 20:54:35 0  1  1010

mysql - How to implement union and then limit in continuous operation in ThinkPHP3.2.3?

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

From [MySQLdiscussion group] 2017-07-04 13:43:25 0  1  1007

Regarding the issue that dates cannot contain zero values ​​in higher versions of MySQL

Export the database from MySQL5.6 version and then import it into MySQL5.7. The error message is: Invalid defa...

From [MySQLdiscussion group] 2018-10-12 20:32:12 0  0  1006

Why does mysql order by not use index sorting?

order by city_id (primary key index) order by country_id (no index!!!)

From [MySQLdiscussion group] 2017-05-18 10:44:38 0  3  1004

MySQL How to select date from a datetime type field

There is a field created_at of datetime type. How to select data on a specific date? {Code...} {Code...} are a...

From [MySQLdiscussion group] 2017-06-30 09:53:42 0  5  1003

mysql-workbench - mysql workbench 经常丢失连接

直接用 mysql workbench 连接的外网的 mysql。经常在简单查询的时候，遇到 Error Code: 2013. Lost connection to MySQL server during query ...

From [MySQLdiscussion group] 2017-04-17 13:42:07 0  1  1003

为什么说"B+树索引适用于全键值,键值范围或者最左键前缀查找"? 看高性能 Mysql 的困惑

还以书上例子来说 {代码...} 这个 B+tree 的索引示意图能明白,但是为什么马上在下文就说"B+树索引适用于全键值,键值范围或者最左键前缀查找" 我应该如何去理解,是否和 B+tree 有着不...

From [MySQLdiscussion group] 2017-04-17 12:58:12 0  2  1001

VS2013 c++连接mysql 在源文件中添加libmysql.dll报错 不添加也报错！ 请问我该怎么办？

main.cpp {代码...} sqlConnection.h {代码...} sqlConnection.cpp {代码...} 存在libmysql.dll报错信息为：0x00007FFED00441E6 (lib...

From [MySQLdiscussion group] 2017-04-17 13:43:16 0  4  1000

Does MySQL mixed utf8 utf8mb4 have any advantages over pure utf8mb4?

There are too many tables, only nicknames and comments are set to utf8mb4, config, tag, router, etc. do not us...

From [MySQLdiscussion group] 2017-06-22 11:54:49 0  1  999

Mysql select 中嵌套带子句

很常见的用例： 我有一张存放文章的表， tag 字段是逗号分隔的数字，在显示列表的时候我想一次性查询出 tag 的字符串SELECT tt.*,u.name,(SELECT group_concat(title) FRO...

From [MySQLdiscussion group] 2016-11-07 14:53:37 0  1  999

Question about not being able to modify field names in MySQL

(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:27 0  1  998

mysql index - How to reorganize (or generate) indexes for mysql tables?

1. Background description I have a user table with the following table structure: The index is as follows: The...

From [MySQLdiscussion group] 2017-05-18 10:52:38 0  3  997