Problems with the connection between the face recognition terminal iVMS-4200 and the base

The face recognition terminal iVMS-4200 displays an error when connecting to the mysql database. I tried the f...

From [MySQLdiscussion group] 2024-04-06 12:20:33 0  1  696

Unable to connect to mysql on GCP Compute Engine

I have installed mysql on a virtual machine in gcp using the following command: https://cloud.google.com/archi...

From [MySQLdiscussion group] 2023-08-31 10:58:27 0  1  696

mysql - PHP 批量插入的时候 判断数据表里面是否重复怎么优化

场景：从第三方接口获取到数据 比如 获取到了 500 条，然后批量插入到表，但是要保证唯一。代码如果是这样的（name 字段有索引的情况下怎么才能最大化的优化），这样的结果是有500次的I/O 这个逻辑怎么优化最佳呢.....

From [MySQLdiscussion group] 2017-04-17 16:51:55 0  4  696

mysql - 执行sql语句跳过触发器

会员表里有一个修改的触发器，只要对它进行修改，就会把这一行数据添加到新建的一张表里。有个判断条件，要是条件成立 执行sql语句修改，，就跳过触发器，求大神解决下

From [MySQLdiscussion group] 2017-04-17 16:19:16 0  2  696

mysql source命令如何把日志记录到文件里面

mysql source命令如何把日志记录到文件里面 在msyql数据库备份过程中，使用source命令，日志都打印在界面上了，如何让它输入到一个文件里面？

From [MySQLdiscussion group] 2017-04-17 15:24:47 0  2  696

mysql - 看这条sql有可能被注入吗

{代码...} $sortField$和$sortOrder$可以写任意sql 这条sql有被注入的风险吗

From [MySQLdiscussion group] 2017-04-17 15:04:00 0  3  696

mysql优化 - 如何解决 MySQL 导入约 2G 的 SQL 报错？

如题，报 mysql: Out of memory (Needed 1073743928 bytes) 。 有个用 mysqldump 导出的文件，1.8G，现在到另一台服务器上，导入报错，调整了几个 my.cnf 配置...

From [MySQLdiscussion group] 2017-04-17 14:46:39 0  2  696

mysql - 求 alter column , change column , modify column 区别

在Mysql 里边 Alter TABLE 子选项中 alter column , change column , modify column 有什么区别？ 如果有一张大表，执行不同的选项会有什么差异？ 求解答

From [MySQLdiscussion group] 2017-04-17 11:24:20 0  1  696

Workaround: How to resolve Unable to delete or update parent row: Foreign key constraint violated?

I want to delete users based on phone number. So I made a custom query to delete that specific user. But an er...

From [MySQLdiscussion group] 2024-03-25 18:47:47 0  1  694

Extract data from another table in MYSQL database, making changes to existing columns

I have a MYSQL database (in PHPMyAdmin) with two tables users and posts. Both tables have a username column. I...

From [MySQLdiscussion group] 2023-09-10 08:45:15 0  1  694

Build a login page using MySQL, Java, HTML and CSS

I have created a table containing the login details and written a program in Java to handle the information, b...

From [MySQLdiscussion group] 2023-09-01 13:24:50 0  1  694

Tips to improve WooCommerce member query speed: Optimize MySQL index

I have a WooCommerce membership based website using the Teams for WooCommerce membership extension. Despite ha...

From [MySQLdiscussion group] 2023-08-26 11:09:08 0  1  694

MySQL data type enum cannot insert data?

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

From [MySQLdiscussion group] 2017-05-18 10:50:44 0  2  694

MySQL创建视图不可以包含子查询吗

创建视图时，SQL语句不可以包含子查询的吗???例如: {代码...} 执行上述SQL语句会报错,假如要创建如上视图,有没有什么好的解决方案呢??? 今天无意中遇到上述问题,麻烦各位给个建议,蟹蟹,^_^...

From [MySQLdiscussion group] 2017-04-17 16:25:10 0  2  694

mysql case when 查询一个效率问题

第一种： {代码...} 第二种： {代码...} 这两个sql语句查询结果相同，想问问到底是哪个好一点

From [MySQLdiscussion group] 2017-04-17 15:21:55 0  1  694