Christopher Juckins

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

==== MySQL Tips ====

__SELECT and JOIN__

[[https://www.mysqltutorial.org/mysql-inner-join.aspx]]

__Time/date__

[[http://www.richardlord.net/blog/dates-in-php-and-mysql]]

[[http://www.tizag.com/perlT/perlmysqlquery.php]]

[[http://bytes.com/serversidescripting/perl/tutorials/perlandmysql-together/index.html]]

[[http://weblogs.sqlteam.com/jeffs/archive/2007/01/02/56079.aspx]]

[[http://www.bennadel.com/blog/172-Ask-Ben-Selecting-Parts-of-a-Date-Time-Stamp-In-SQL.htm]]

__Performance__

[[https://tableplus.com/blog/2018/11/error-1040-too-many-connection-increase-max-connections-mysql.html|Max connections]]

__Checking for errors in all tables/databases__

  * In phpMyAdmin, select database and then check the table you want to investigate.  In the dropdown box "With Selected", choose the Check / Repair option, etc.

Alternately:

  mysqlcheck -c -u root -p --all-databases
  
__Repair a database__

  mysqlcheck -r DATABASE_NAME -u root -p
  
__Checking Size of Indexes__

https://releem.com/blog/check-mysql-database-table-size