======MySql Index======
=====mysql語法=====
* DESCRIBE語法(取得資料表欄位資訊)
mysql> DESCRIBE tableName;
mysql>Desc tableName; (簡寫代碼)
mysql>show columns from tableName; (等同於DESCRIBE用法)
* help查詢命令用法
mysql>help help;
Many help items for your request exist.
To make a more specific request, please type 'help - ',
where
- is one of the following
topics:
HELP COMMAND
HELP STATEMENT
=====MySql管理=====
- [[database:mysql:管理工具|管理工具mysql,mysqladmin及mysqldump]]
- [[database:mysql:conf|簡單管理mysql及配置my.cnf]]
- [[database:mysql:account|帳號登入、建立及權限配置]]
- [[database:mysql:zrm|利用mysql-zrm備份及還原的解決方案]]
- [[database:mysql:binlog|簡單Mysql Binary Log管理]]
- [[database:mysql:replication1|MySQL複寫(replication)]]
- [[database:mysql:report|mysqlreport_mysql健康狀態報告]]
- [[http://newsletter.ascc.sinica.edu.tw/news/read_news.php?nid=2050|MySQL使用工具簡介-中央研究院計算通訊電子報]]
- [[database:mysql:multiple|同一個Mysql Server 建立多個執行個體(multiple instances)]]
- [[database:mysql:lang|MySQL 字元集初探]]
- [[database:mysql:exportandimport|MySQL資料匯入匯出]]
- [[database:mysql:locktable|MySQL的Lock Tables]]
- [[database:mysql:transaction|Mysql儲存引擎提供的交易功能]]
- [[database:mysql:innodbStorageEngine|MySQL 5.6 InnoDB存儲引擎體系結構圖]]
- [[database:mysql:mysqlstructure|MySQL系統結構]]