MySQL鲜为人知的几个特殊技巧

shell> mysql --xml 
mysql> SELECT * FROM test.stories;
1
This is a test
2
This is the second test
2rows in set (0.11 sec)

mysql> REPAIR TABLE content QUICK; 
+-----------+--------+----------+----------+
| Table| Op| Msg_type | Msg_text |
+-----------+--------+----------+----------+
| content| repair | status| OK|
+-----------+--------+----------+----------+
1 row in set (0.05 sec)

shell> myisampackmovies.MYI 
Compressing movies.MYD: (146 records)
- Calculating statistics
- Compressing file
41.05%
 

mysql> SELECT IF (priv=1, 'admin', 'guest') 
As usertype FROM privs WHERE username = 'joe';
+----------+
| usertype |
+----------+
| admin|
+----------+
1 row in set (0.00 sec)
 
以CSV格式输出表格数据

shell> mysqldump -T .
--fields-terminated-by=", " mydbmytable

shell> mysqld --sql_mode="STRICT_ALL_TABLES" &

Emysql> SHOW STATUS; 
+------------------+-------+
| Variable_name| Value |
+------------------+-------+
| Aborted_clients| 0|
| Aborted_connects | 0|
...
| Uptime| 851|
+------------------+-------+
156 rows in set (0.16 sec)

mysql> SHOW CREATE TABLE products; 
---------------------------------------
| Table| Create Table
+----------+---------------------------
| products | CREATE TABLE `products` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`price` int(10) default NULL,
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+----------+----------------------------
1 row in set (0.27 sec)

mysql> prompt \U:/\d> 
PROMPT set to '\U:/\d>'
root@localhost:/db1>