云海网博客杂谈

MYSQLMySQL字段内容追加内容

update cqwt_mstd set name = CONCAT(name,"新增内容") where name="胡寒";...继续阅读 >>

MYSQL配置mysql允许远程连接的方法

配置mysql允许远程连接的方法默认情况下，mysql只允许本地登录，如果要开启远程连接，则需要修改/etc/mysql/my.conf文件。一、修改/etc/mysql/my.conf找到bind-address = 127.0.0.1这一行改为bind-address = 0.0.0.0即可二、为需要远程登录的用户赋予权限1、新建用户远程连接mysql数据库grant all on *.* to admin@'%' identified by '123456' with grant ...继续阅读 >>

MYSQLsql文件过大解决办法

失败背景：通过navicat向本地mysql数据库中导入sql文件导入失败，提示：Got a packet bigger than 'max_allowed_packet' bytes1.在navicat中按F6进入mysql的命令界面输入命令: mysql>show VARIABLES like '%max_allowed_packet%';显示：+--------------------------+------------+| Variable_name   &nb...继续阅读 >>

MYSQLMYSQL修改替换内容

UPDATE cqwt_video_class SET pic = REPLACE(pic, 'http://www.zzwtqx.com/videomaterial/imglist/', '/public/pic/imglist/');修改cqwt_video_class表 内容 PIC字段  '替换前的内容','替换后的内容'；...继续阅读 >>

MYSQLMYSQL字段唯一值

ALTER TABLE `ceshi` ADD unique(`numbers`);...继续阅读 >>

MYSQLMySQL字段自减

update ceshi set number = number - 1 where id = '1';...继续阅读 >>

MYSQLMySQL向数据库表的某字段追加数据

使用CONCAT()函数mysql向表中某字段后追加一段字符串（field为字段名）:update table_name set field=CONCAT(field,'str',)mysql 向表中某字段前加字符串update table_name set field=CONCAT('str',field)...继续阅读 >>

MYSQLMYSQL多表3表查询

select a.id,a.name,a.author,a.time,a.ip,a.state,a.gntype,a.nutotype,b.name as name2,c.name as name3 from yung_guin_tag a left join yung_guin_gntype b on a.gntype = b.bianma left join yung_guin_nutotype c on a.nutotype = c.bianma order by id desc limit 0,2...继续阅读 >>