10 years of travel blogging from 35+ countries around the world

login as: markl
Sent username "markl"
markl@192.168.0.5"s password:
Last login: Wed May 28 14:45:57 2003 from 192.168.0.32
markl@desweb01:~> mysql -u mark
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11501 to server version: 3.23.52-Max-log

Type "help;" or "h" for help. Type "c" to clear the buffer.

mysql> use resources
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select start, until, emailforreply, status from holidays where (emailforreply = "mark.litwintschik@[nottelling].de");
+----------+----------+--------------------------------+----------+
| start | until | emailforreply | status |
+----------+----------+--------------------------------+----------+
| 20031005 | 20031109 | mark.litwintschik@[nottelling].de | denied |
+----------+----------+--------------------------------+----------+
1 row in set (0.00 sec)


mysql> UPDATE holidays SET status = "approved" WHERE (emailforreply = "mark.litwintschik@[nottelling].de");
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0