MySQL built-in functions

Date related

Mysql> SelectCurdate (), Curtime (), now (), Unix_timestamp (), Week ('2017-07-24'), Year('2017-07-24'), Hour ('16:15:11'), Date_format ('2017-07-24','%m-%d,%y');+------------+-----------+---------------------+------------------+--------------------+--------------------+ ------------------+--------------------------------------+|Curdate ()|Curtime ()|Now ()|Unix_timestamp ()|Week'2017-07-24')|  Year('2017-07-24')|Hour'16:15:11')|Date_format ('2017-07-24','%m-%d,%y')|+------------+-----------+---------------------+------------------+--------------------+--------------------+- -----------------+--------------------------------------+|  .- -- - |  -: -:Panax Notoginseng  |  .- -- -  -: -:Panax Notoginseng |       1500884317 |                  - |                . |                - |  -- -, -                             |+------------+-----------+---------------------+------------------+--------------------+--------------------+- -----------------+--------------------------------------+1Rowinch Set(0.00Sec

Other common

Mysql> Select Database(), version (),User(), Inet_aton ('118.11.22.33'), Password ('1'), MD5 ('1');+------------+------------+----------------+---------------------------+------------------------------------- ------+----------------------------------+| Database()|Version ()| User()|Inet_aton ('118.11.22.33')|Password'1')|MD5 ('1')|+------------+------------+----------------+---------------------------+-------------------------------------- -----+----------------------------------+| NULL       | 5.6. the-Log |Root@localhost |                1980438049 | *E6cc90b878b948c35e92b003c792c46c58c4af40|c4ca4238a0b923820dcc509a6f75849b|+------------+------------+----------------+---------------------------+-------------------------------------- -----+----------------------------------+1Rowinch Set(0.00Sec

MySQL built-in functions