====== MySQL ======

  * [[MySQL Character Sets]]
  * [[MySQL Configuration]]
  * [[MySQL Optimization]]
  * [[MySQL OS X]]
  * [[MySQL Logs]]
  * [[MySQL Privileges]]
  * [[MySQL Maintenance and Repair]]
  * [[MySQL Security]]
  * [[MySQL Source Installation]]
  * [[MySQL SSL]]
  * [[MySQL Statistics]]
  * [[MySQL Views]]
  * [[mysql prompt]]
  * [[mysqladmin]]
  * [[mysqldump]]
  * [[mysqlreport]]
  * [[InnoDB]]
  * [[Percona]]
  * [[phpMyAdmin]]




=== Howtos ===

== Change update_date timestamp automatically ==

<code>ALTER TABLE `table` CHANGE `update_date` `update_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;</code>

== Show database sizes ==

<code>
SELECT table_schema AS db, (SUM(data_length + index_length) / 1024 / 1024) AS mb FROM information_schema.tables GROUP BY table_schema; 
</code>