如何輸入檢索 (queries)

命令提示列 (command-line)

1. SHOW

   mysql>SHOW DATABASES;

   mysql>SHOW TABLES FROM databaseName; 

   mysql>SHOW COLUMNS FROM databaseName.tableName;

2. USE

   mysql>USE databaseName

   mysql 把 USE 歸於一種命令，可以不加 ; 結尾。

   mysql>SHOW TABLES; 

   mysql>SHOW COLUMNS FROM tableName;

3. SELECT

   mysql>SELECT 8*8;

   mysql>SELECT VERSION() AS version, CURRENT_DATE AS today, USER() AS user, ROUND(PI(),4) AS pi;

   mysql>SELECT DATABASE();

   mysql>SELECT * FROM tableName;

   mysql>SELECT * FROM databaseName.tableName;

不進入 mysql 管理程式中執行

系統命令提示列

shell>mysql -u root -e "SELECT * FROM databaseName.tableName;"

mysql 提示字元的含意

參考資源

• The MySQL Command-Line Tool
• SHOW
• USE
• Functions and Operators
• SQL Statement Syntax

更新日期： 2013-6-7

• 目錄