======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系統結構]]