A Taste of MySql 函数(4)

mysql> select database();
+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

mysql> select password('jinrize');
+-------------------------------------------+
| password('jinrize')                       |
+-------------------------------------------+
| *E8320E79D15876BBBEE27685DB2DCC3F104FC98E |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql> select old_password('jinrize');
+-------------------------+
| old_password('jinrize') |
+-------------------------+
| 058b8c01611d3818        |
+-------------------------+

1 row in set (0.00 sec)

 

＃从第3条（从0开始计数的）记录开始查询三条记录。
mysql> select user from user limit 2,3;
+------------+
| user       |
+------------+
| phpmyadmin |
| root       |
| root       |
+------------+

3 rows in set (0.00 sec)

 ＃查询工资最低的五个人

 mysql> select * from emp order by sal limit 0,5;

 

＃导入（文件名和表名要相同）

mysql> load data infile '/tem/user.txt' into table user;
ERROR 13 (HY000): Can't get stat of '/tem/user.txt' (Errcode: 2)

＃导出
mysql> select * from user into outfile '/tmp/user.txt';
Query OK, 5 rows affected (0.00 sec)

 mysql> create database jinrize;
Query OK, 1 row affected (0.00 sec)

rize@rize-laptop /u/s/mysql> cd /var/lib/mysql
rize@rize-laptop /v/l/mysql> ls
dbtemp/  debian-5.0.flag  ibdata1  ib_logfile0  ib_logfile1  jinrize/  mysql/  mysql_upgrade_info  phpmyadmin/

转载于:https://www.cnblogs.com/jinrize/archive/2009/10/20/1587163.html