mariadb¶
- Install
- mysqladmin
- geant
- show
- create
- insert
- delete
- select
- update
- alert(修改字段)
- drop
- modify
- mysqladump
- mysql 函数
- ascii(str)
- ord(str)
- bin(n)
- oct(n)
- hex(n)
- char(n,…)
- concat(str1,str2,…)
- length(str)
- octet_length(str)
- char_length(str)
- character_length(str)
- locate(substr,str)
- position(substr in str)
- locate(substr,str,pos)
- instr(str,substr)
- lpad(str,len,padstr)
- rpad(str,len,padstr)
- left(str,len)
- right(str,len)
- substring(str,pos,len)
- substring(str from pos for len)
- mid(str,pos,len)
- substring(str,pos)
- substring(str from pos)
- substring_index(str,delim,count)
- ltrim(str)
- rtrim(str)
- soundex(str)
- space(n)
- repeat(str,count)
- reverse(str)
- insert(str,pos,len,newstr)
- find_in_set(str,strlist)
- make_set(bits,str1,str2,…)
- export_set(bits,on,off,[separator,[number_of_bits]])
- lcase(str)
- lower(str)
- ucase(str)
- upper(str)
- load_file(file_name)
- sign(n)
- mod(n,m)
- floor(n)
- ceiling(n)
- round(n,d)
- exp(n)
- log(n)
- pow(x,y)
- power(x,y)
- sqrt(n)
- pi()
- cos(n)
- sin(n)
- tan(n)
- acos(n)
- asin(n)
- atan(n)
- cot(n)
- rand()
- rand(n)
- degrees(n)
- radians(n)
- truncate(n,d)
- least(x,y,…)
- greatest(x,y,…)
- weekday(date)
- dayofmonth(date)
- dayofyear(date)
- month(date)
- dayname(date)
- monthname(date)
- quarter(date)
- week(date,first)
- year(date)
- hour(time)
- minute(time)
- second(time)
- period_add(p,n)
- period_diff(p1,p2)
- date_add(date,interval expr type)
- date_sub(date,interval expr type)
- adddate(date,interval expr type)
- subdate(date,interval expr type)
- to_days(date)
- from_days(n)
- date_format(date,format)
- time_format(time,format)
- curdate()
- current_date()
- curtime()
- current_time()
- now()
- sysdate()
- current_timestamp()
- unix_timestamp()
- unix_timestamp(date)
- from_unixtime(unix_timestamp)
- sec_to_time(seconds)
- time_to_sec(time)
- cast
- convert:
- 其他功能
- binlog日志管理
- 备份mysql
- mysql排错