postgresql - What are the advantages and disadvantages of on duplicatekey update in MYSQL?

on duplicatekey update If it exists, it will be updated, if it does not exist, it will be inserted. It is an o...

From [MySQLdiscussion group] 2017-06-24 09:41:38 0  1  1426

表结构设计问题

一个表结构设计，有些不懂怎么做了，请问一下大家：有一个模块，下面有6张不同类型的表，它们都有共同的字段5~6个。（每张表的数据都超过3000万)1、新建一个总表，把这5个字段都分出来,再加个日志类型ID来操作6个表（第三...

From [MySQLdiscussion group] 2016-11-09 17:31:34 0  2  1426

mysql trigger

MySQL trigger problem, I want to delete the content of an article and the comments about this article in anoth...

From [MySQLdiscussion group] 2018-06-21 10:52:22 0  1  1425

Please help. With the new version of phpstudy, why will the database disappear after a while?

I would like to ask, if you use the new version of phpstudy, what happens if the database disappears after a w...

From [MySQLdiscussion group] 2018-09-26 00:42:45 0  2  1422

How to create an index for the database in PHPstudy

In order to improve SQL performance, indexes can be created on the server; but how to create indexes for the d...

From [MySQLdiscussion group] 2017-09-27 10:03:00 0  3  1418

How to print mysql data to paper?

I would like to ask my seniors, I want to print mysql data to paper. How can it be more convenient and control...

From [MySQLdiscussion group] 2019-05-30 17:24:42 0  2  1414

mysql - 积分表怎么设计?

举例 用户通过做活动得到了100积分，这时候a表中新增一条获取积分的记录 然后用户在下单的时候消费了50积分，（假设这个用户一共只有100积分，a表中就一条数据），a表中如何标识使用了50积分。 问题 1.积分如何拆.....

From [MySQLdiscussion group] 2017-04-17 11:13:03 0  1  1410

Double-click the installer, but it cannot be installed.

From [MySQLdiscussion group] 2018-12-29 01:18:45 0  2  1395

Teaching course preview for September 12, 2018: Detailed explanation of dom operations in Javascript

1. Teaching topic: DOM operation content in Javascript. (The full name of DOM is Document Object Model, which ...

From [MySQLdiscussion group] 2018-09-12 14:45:26 0  0  1395

MySQL Workbench dark theme

How to change MySQLWorkbench settings so that it uses dark theme?

From [MySQLdiscussion group] 2023-10-14 10:51:40 0  2  1394

navicat for mysql 如何导出表的索引

navicat for mysql 如何导出表的索引？？？

From [MySQLdiscussion group] 2017-04-17 16:16:35 0  3  1389

CLion如何添加依赖库 ？ 需要把mysql/Connector c++放入 用cpp连接数据库

目前我把下载的mysql/Connector 下载后放在了project内 但是报错信息如下报错信息如下 {代码...} 文件引用情况如下： 在网上搜索有很多连接的方法 目前还是有点晕 望指教

From [MySQLdiscussion group] 2017-04-17 13:38:59 0  2  1387

.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  1382

character set

It should be mentioned here that mysql's utf8 is not the real utf8. It is a character set within mysql. I want...

From [MySQLdiscussion group] 2019-11-09 09:15:04 0  0  1374

MYSQL主从同步，新增的表会不会自动在从服务器同步

配置好了MYSQL主从同步，主服务器每天生成一张新表，请问从服务器会不会自动同步呢？

From [MySQLdiscussion group] 2016-11-19 13:56:33 0  4  1374