数据库 - MYSQL提示数据过长错误，根据网上的解决方案无法解决

环境是WAMPSERVER错误类型如下，应该可以肯定是字符编码的问题： SQLSTATE[22001]: String data, right truncated: 1406 Data too long for colu...

From [MySQLdiscussion group] 2017-04-17 15:18:16 0  1  1085

mysql怎么实现mssql的if exists() begin...end功能？

需要实现逻辑:判断一子集中是否有制定条件查询值，有的话则向下执行,没有下面代码块不执行。 {代码...} mssql的if exists用法可能有些不同，case语句的话，代码块太长也不合适。 麻烦大神看看怎么实现这个功...

From [MySQLdiscussion group] 2017-04-17 16:22:37 0  2  1084

Regarding Mysql index query efficiency issues

{Code...} The runtime after the two sql statements means the execution time. The data volume is 150W. Field de...

From [MySQLdiscussion group] 2017-06-22 11:54:39 0  4  1083

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

After accessing the home page, error #1064 occurred when creating the database

An error occurred while creating the database

From [MySQLdiscussion group] 2020-04-09 23:42:35 0  0  1080

python - pandas group by condition charting

How to draw a bar chart with the name as the abscissa and the score as the ordinate?

From [MySQLdiscussion group] 2017-06-20 10:05:45 0  1  1080

mysql group by only displays one?

Suppose the user table | id | name | group || 1 | evan | admin || 2| charlie | admin|| 3 | kid | user || 4 | w...

From [MySQLdiscussion group] 2017-07-04 13:43:42 0  3  1079

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

mysql - 数据库表之间设置外键是否可以提高查询效率？

我们知道，设置主键、唯一索引可以提高查询效率，但设置外键约束可以提高查询效率吗？外键约束除了用来防止数据不正确外，是否可以提高查询效率？现在我们项目中很多时候只是在代码里面通过业务进行关联，数据库...

From [MySQLdiscussion group] 2017-04-17 16:08:22 0  7  1078

mysql - 像淘宝那样的收货地址怎么存入数据库

像淘宝那样选择省市区和详细收货地址后将这些存入数据库，应该如何设计数据表？

From [MySQLdiscussion group] 2017-04-17 15:16:50 0  1  1077

Virtual centos error when connecting to mysql

内容Can't connect to local MySQL server through socket '/tmp/mysql.sock'

From [MySQLdiscussion group] 2021-12-10 12:57:42 0  0  1076

mysql - 请问数据库字段为年月日，传进的参数为月，怎么查询那个月所对应的数据

请问数据库字段为年月日，传进的参数为月，怎么查询那个月所对应的数据

From [MySQLdiscussion group] 2017-04-17 16:50:28 0  1  1076

MySQL doesn't know what's wrong?

insert into score1 (id,title,name,content) values ​​(1,'try','Zhang San','Zhang San is bright') ERROR 1064 (42...

From [MySQLdiscussion group] 2020-03-21 23:44:52 0  1  1075

I opened the mc server but the data will not be synchronized across the server.

How to synchronize? Please teach me. QQ 3203749095 Mobile number 13736876595

From [MySQLdiscussion group] 2018-09-22 19:12:22 0  1  1070

Medoo linked list query questions

Query all the fields of the slide_item table. The specified fields of the slide table are written with * in al...

From [MySQLdiscussion group] 2019-07-30 15:00:12 0  0  1069