![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
年少~年
这个作者很懒,什么都没留下…
展开
-
同一个mysql表中,A字段和B字段,进行相除,再更新到C字段中
同一个mysql表中,A字段和B字段,进行相除,再更新到C字段中。原创 2023-03-09 14:52:44 · 247 阅读 · 0 评论 -
which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mod
编辑vim /etc/my.cnf在文件底部加入:sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION重启:systemctl restart mysqld 结果不成功 ,查看错误原因cat /var/log/mysqld.log /usr/sbin/mysqld: Error while原创 2022-05-23 22:06:37 · 1288 阅读 · 0 评论 -
Linux安装MYSQL8.0
1.下载mysqlcd /usr/local/src wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz也可以直接在官方下载最新版本 https://dev.mysql.com/downloads/mysql/ 选择linux2.解压到指定目录tar -xvf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz -C /usr原创 2021-12-25 18:17:13 · 1154 阅读 · 0 评论 -
mysql update更新替换某个字符串
mysql update更新替换某个字符串更新表中field1 字段,把"字符 替换为空UPDATE tableNameSET field1 = REPLACE (field1, '"', '' )WHERE locate( '"', field1)原创 2021-07-06 14:40:32 · 3103 阅读 · 0 评论 -
nginx+php7+mysql8+redis安装
安装nginxyum -y install gcc pcre pcre-devel zlib zlib-devel openssl openssl-devel gd-develcd /optyum -y install gd-develsudo wget http://nginx.org/download/nginx-1.12.2.tar.gzsudo tar -zxvf nginx-1....原创 2020-01-02 13:55:24 · 2832 阅读 · 1 评论