Sunday, April 17, 2005

Some built-in MySQL functions

mysql> select version();
+---------------+
| version() |
+---------------+
| 3.23.29-gamma |
+---------------+
1 row in set (0.00 sec)

mysql> select database();
+------------+
| database() |
+------------+
| main |
+------------+
1 row in set (0.01 sec)

mysql> SELECT PASSWORD("mypass");
+--------------------+
| PASSWORD("mypass") |
+--------------------+
| 6f8c114b58f2ce9e |
+--------------------+
1 row in set (0.01 sec)

mysql> select md5('test');
+----------------------------------+
| md5('test') |
+----------------------------------+
| 098f6bcd4621d373cade4e832627b4f6 |
+----------------------------------+
1 row in set (0.02 sec)

No comments: