Isn't the ID primary key auto-incrementing? Why do we need to add null?

insert into stu values ​​(null,'jike','ww',55) Why is the id field still null when inserting? Can it be omitte...

From [MySQLdiscussion group] 2019-02-25 10:57:45 0  2  1281

mysql optimization - Questions about index failure and the number of scanned rows being greater than the total number of data rows during mysql query.

The data table uses the innodb engine, and the updated_at field uses a normal index. Three questions: Comparin...

From [MySQLdiscussion group] 2017-06-30 09:52:51 0  1  1277

如果机器上已经安装过mysql了，会有冲突吗？？？

如果机器上已经安装过mysql了，会有冲突吗？？？

From [MySQLdiscussion group] 2016-12-24 13:10:40 0  2  1276

Can mysql5.5 use match against usage?

Can mysql5.5 use match against usage? Why no data is returned when I test the data set: user_id user_tags1 Swi...

From [MySQLdiscussion group] 2022-05-19 18:21:55 0  0  1276

There is no problem with mysql configuration, but Chinese is not displayed;

mysql> show variables like "%colla%";+----------------------+-----------------+| Variable_name&nb...

From [MySQLdiscussion group] 2018-08-27 23:55:00 0  2  1274

Mysql Begin End statement error

The poster wanted to write a complex statement, but it always reported a "begin end" error, so he si...

From [MySQLdiscussion group] 2017-06-30 09:54:32 0  1  1273

mysql - navicat 运行sql文件出现 out of memory

是想用运行sql来恢复数据库，但是一直是运行13秒左右显示err:out of memory 求解决方法

From [MySQLdiscussion group] 2017-04-17 11:52:10 0  3  1271

mysql - navicate imports Chinese garbled characters into the database?

1. Create a new people.xlsx table 2. Save as 3. Import database 4. Chinese garbled characters Question: Why do...

From [MySQLdiscussion group] 2017-05-18 10:56:34 0  1  1268

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

Will mysql master-slave and slave database lock tables cause replication blocking?

Mysql is configured with master and slave, and the slave database is used to query slow statements. If the tab...

From [MySQLdiscussion group] 2017-06-22 11:54:33 0  3  1263

为什么MySQL用户那么多，而同样优秀的PostgreSQL却很少人用

看到文章说PostgreSQL比MySQL甚至要好，为什么大家更愿意选择mysql呢

From [MySQLdiscussion group] 2017-04-17 11:07:22 0  7  1262

session_variables table does not exist in performance_schema

After upgrading MySQL to 5.7.8-rc version and logging into the server, I encountered the following error: Tabl...

From [MySQLdiscussion group] 2023-09-22 13:52:07 0  2  1256

mysql无法删除字段（错误1091），但是对该字段设置主键后就可删除，为什么？

我为表student添加了字段xx，再想删除时，提示error 1091。可是，为什么会出现这个错误？ 我在网上找到了这个办法：给xx字段添加主键，然后果然删除了。可是，主键不是不能删除的吗？这怎么又可以删除了？这个办....

From [MySQLdiscussion group] 2017-04-17 16:22:49 0  1  1255

mysql

Can’t install

From [MySQLdiscussion group] 2018-03-01 17:25:10 0  1  1254

mysqldump: Couldn't find table: ";"是怎么回事？

```C:\Users\adminstrator>mysqldump -u root -p yuanbiji >g:/www/yuanbiji11.sql; Enter password: *...

From [MySQLdiscussion group] 2017-04-17 11:54:14 0  3  1254