一.修改或设置root密码1.进入mysqlmysql -urootold版本 执行下面的命令修改root密码mysql> SET PASSWORD = PASSWORD('密码');5.7版本 以后设置密码改为ALTER USER USER() IDENTIFIED BY '密码';二.创建账户并设置三.创建外部链接账户并赋予最高权限5.5版本 创建并赋予权限grant all pr...
一条SQL语句执行批量修改UPDATE mytable SET
myfield = CASE id
WHEN 1 THEN 'value'
WHEN 2 THEN 'value'
WHEN 3 THEN 'value'
END
WHERE id IN (1,2,3)例如UPDATE categories SET
display_order = CASE id
...
查询汉字的全拼音1.创建汉字拼音对照临时表CREATE TABLE IF NOT EXISTS `t_base_pinyin` (
`pin_yin_` varchar(255) CHARACTER SET gbk NOT NULL,
`code_` int(11) NOT NULL,
PRIMARY KEY (`code_`)
) ENGINE=InnoDB DEFAULT C...
sql中拆分字段和合并字段原sqlselect arrchildid from sys_category where catid in ('120','1108')查询结果:arrchildid
120,140,141,143,144,145,147,149,1121
1108,1109,1110,1111,1112,1113,11141. 函数: group_concat(字段)用来和并一...