授权
grant all on *.* to 'root' @'192.168.1.1' identified by '123';
拼接字符串,替换某字符串
select concat('ftp://',c_ftp_ip,'/',REPLACE(c_ftp_path,'\\','/'),file_name) from data_file
查询,分组
select count(*),sum(r_ftp_length)/1024/1024/1024 from data_file
select count(*),sum(r_ftp_length)/1024/1024/1024,down_ip from data_file group by down_ip