看驴生豪迈，不过从头再来

SELECT VALUE from table WHERE value like "%str1%";UPDATE table set value=REPLACE(value,'str1','str2');SELECT VALUE from te_t_env_property_value WHERE value like "%192.168.5.222%";UPDATE te_t_env...

http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-6.0/mysql-6.0.11-alpha.tar.gztar -xzvf mysql-6.0.11-alpha.tar.gzmv mysql-6.0.11-alpha mysql======================mysql======================1.创建mysq...

update dede_arctype set typedir = replace(typedir,'{cmspath}/','/');update dede_arctype set typedir = concat('{cmspath}/', mid(typedir,2,length(typedir)));update 表名 set innum = concat('K', mid(in...

SET PASSWORD = PASSWORD('123456');flush privileges;

show grants for db_risk;drop user 'db_risk'@'%';CREATE user 'db_risk'@'%' IDENTIFIED by 'risk';GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `ys_mosquit...

[mysqld]character-set-server=utf8 [client]default-character-set=utf8 [mysql]default-character-set=utf8 

REVOKE INSERT, UPDATE, DELETE, CREATE, EXECUTE, TRIGGER ON *.*FROM 'admin'@'%';REVOKE SELECT, SHOW VIEW ON `information_schema`.* FROM 'asset'@'%';REVOKE SELECT , INSERT, UPDATE, DELE...

 问题：执行mysql创建用户语句CREATE USER test IDENTIFIED BY 'test';报错,错误信息为[Err] 1396 - Operation CREATE USER failed for 'test'@'%'。        解决步骤：        1.创建过test用户。        2.查询后发现无此用户，则执行FLUSH PRIVILEGES;然后重新...

alter table `{table_name}` Add column {column_name} char(1) comment '{字段注释}' AFTER `{column_name}` ; 

GRANT SELECT, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'select'@'%'; 

drop user 'select'@'%';CREATE USER 'select'@'%' IDENTIFIED BY 'knlAcd7NTfv7qMwvk9cz';grant select on select.* to 'select'@'%';grant select,insert,update,delete,alter routine,CREATE routine,EXECUT...

1.mastervi /etc/my.cnf[mysqld]log-bin=mysqlbin-logserver-id=17grant replication slave on *.* to 'slave'@'%' identyfied by '123456';show master status;2.slavevi /etc/my.cnfserver-id=1...