Differences

This shows you the differences between two versions of the page.

--- mysql_time_date_tips [2010/10/12 12:28] – created juckins
+++ mysql_time_date_tips [2024/11/27 21:38] (current) – juckins
@@ Line 1: / Line 1: @@
+==== 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