Linkatopia.com/rob215
https://linkatopia.com/rob215/mysql
The 24 latest links tagged, "MySQL" by Robert GiordanoMySQL 5.7 Reference Manual :: 12.20.3 MySQL Handling of GROUP BY https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html 2021-10-12T02:40:15ZSee changes in 5.7 that affect queries with GROUP BYMySQL Performance: MyISAM vs InnoDB | Liquid Web https://www.liquidweb.com/kb/mysql-performance-myisam-vs-innodb/ 2021-04-16T03:23:15Z"Should I use InnoDB with WordPress, Magento or Joomla Sites? The short answer here is yes, in most cases."See the rest of this article for detailsHave the tables turned on NoSQL? - Stack Overflow Blog https://stackoverflow.blog/2021/01/14/have-the-tables-turned-on-nosql/ 2021-01-21T14:35:06ZInteresting comparisonHow to back up MySQL databases from the command line in Linux - TechRepublic https://www.techrepublic.com/article/how-to-back-up-mysql-databases-from-the-command-line-with-linux/ 2018-12-28T18:31:45ZHow can I check if a MySQL table exists with PHP? - Stack Overflow http://stackoverflow.com/questions/6432178/how-can-i-check-if-a-mysql-table-exists-with-php 2016-06-14T02:23:26ZEven though this isn't the accepted answer, it looks like the best:if(mysql_query("DESCRIBE [table]")) {The big, bad thread of "MySQL Best Practices and Other Useful Information" - Dat https://www.sitepoint.com/community/t/the-big-bad-thread-of-mysql-best-practices-and-other-useful-information/2716 2016-05-11T21:48:24ZGood stuff in hereMySQL: IN Condition http://www.techonthenet.com/mysql/in.php 2016-05-11T22:18:40ZWHERE some-text-column IN ('aaa','bbb','ccc')WHERE some-int-column IN (1,2,3)mysql - How can I prevent SQL-injection in PHP? - Stack Overflow http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php?rq=1 2016-02-21T21:20:02ZSee two answers from user "Your Common Sense"The Hitchhiker's Guide to SQL Injection prevention https://phpdelusions.net/sql_injection 2016-02-21T21:39:02ZMySQL :: MySQL 5.5 Reference Manual :: 2.11.1.1 Changes Affecting Upgrades to 5. https://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html 2015-12-23T00:56:39ZUpgrading to MySQL 5.5 from earlier versionsperformance - which mysql version to use - 5.1 or 5.5? - Database Administrators http://dba.stackexchange.com/questions/31412/which-mysql-version-to-use-5-1-or-5-5 2015-12-23T01:00:14Z10 reasons to migrate to MariaDB (if still using MySQL) - Seravo https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql 2015-05-20T19:59:05ZNoSQL - Wikipedia, the free encyclopedia https://en.wikipedia.org/wiki/NoSQL 2013-06-05T13:31:21Z10 Tips for Optimizing MySQL Queries (That don't suck) http://20bits.com/articles/10-tips-for-optimizing-mysql-queries-that-dont-suck/ 2009-09-16T18:43:56Zgood article with some basicsSurvive heavy traffic with your webserver http://kevin.vanzonneveld.net/techblog/article/survive_heavy_traffic_with_your_webserver/ 2009-09-16T19:26:07ZGood tips to follow for mysql optimizationDatabase Abstraction Layers Must Die! (by Jeremy Zawodny) http://jeremy.zawodny.com/blog/archives/002194.html 2008-04-09T02:45:27ZThe first article I read on abstraction layersAnnotations to "Five Common PHP database problems" - MySQL-dump http://mysqldump.azundris.com/archives/57-Annotations-to-Five-Common-PHP-database-problems.html 2008-04-09T03:20:19ZThe second article I read, somewhat related but also lists some schemas I need to read up on.Four types of database abstraction layers at Xaprb http://www.xaprb.com/blog/2006/08/13/four-types-of-database-abstraction-layers/ 2008-04-09T03:29:09ZA third article with links to the other articlesCheat Sheets - ILoveJackDaniels.com http://www.ilovejackdaniels.com/cheat-sheets/ 2008-02-26T23:41:08ZA bunch of nice cheat sheets and quick reference charts in PDF format.codepoetry - Optimizing a VPS for Getting Dugg http://www.codepoetry.net/archives/2006/03/21/optimizing_a_vps_for_getting_dugg 2007-05-29T01:42:03ZNotes on Apache and MySQL optimization.Searching with PHP and MySQL http://iamcal.com/publish/articles/php/search/ 2006-11-06T22:16:17ZMySQL 3.23, 4.0, 4.1 Reference Manual http://dev.mysql.com/doc/refman/4.1/en/index.html 2006-05-05T04:21:23ZSimple Machines - SMF: Free PHP and MySQL forum software http://www.simplemachines.org/ 2006-05-04T23:06:29ZDatabase MySQL Optimize MySQL tables for speed Tutorial http://www.tutorialized.com/tutorial/Optimize-MySQL-tables-for-speed/10695 2006-05-03T20:03:56Z