mysql常用的一些操作

#mysql把本地文件导入到表中

load data local infile 'D:\\0.txt' into table test character set 'utf8' fields terminated by ',';

#mysql得到随机日期

select CONCAT(FLOOR(2010 + (RAND() * 15)),'-',LPAD(FLOOR(1 + (RAND() * 12)),2,0),'-',LPAD(FLOOR(3 + (RAND() * 8)),2,0)) random_date from dual;

#mysql得到随机时间

select CONCAT(LPAD(FLOOR(0 + (RAND() * 23)),2,0),':',LPAD(FLOOR(0 + (RAND() * 59)),2,0),':',LPAD(FLOOR(0 + (RAND() * 59)),2,0)) from dual;

#mysql字符串转日期

select STR_TO_DATE('2018-04-12','%Y-%m-%d') from dual;

#mysql日期转字符串

SELECT date_format(now(), '%Y%m%d%H%i%s' ) FROM DUAL;