mysql_time_date_tips
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
mysql_time_date_tips [2010/10/12 12:28] – created juckins | mysql_time_date_tips [2022/08/26 16:41] – juckins | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ==== MySQL Tips ==== | ||
+ | |||
+ | __SELECT and JOIN__ | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | __Time/ | ||
+ | |||
[[http:// | [[http:// | ||
+ | |||
+ | [[http:// | ||
+ | |||
+ | [[http:// | ||
+ | |||
+ | [[http:// | ||
+ | |||
+ | [[http:// | ||
+ | |||
+ | __Performance__ | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | __Checking for errors in all tables/ | ||
+ | |||
+ | mysqlcheck -c -u root -p --all-databases | ||
+ | | ||
+ | __Repair a database__ | ||
+ | |||
+ | mysqlcheck -r DATABASE_NAME -u root -p | ||
+ | | ||
+ | |
mysql_time_date_tips.txt · Last modified: 2022/08/26 17:35 by juckins