Welcome to my Linkatopia. I like music, photography, drones, and welding. I'm currently rebuilding this entire site, and adding more cool features. See the blog!
MySQL 5.7 Reference Manual :: 12.20.3 MySQL Handling of GROUP BY
See changes in 5.7 that affect queries with GROUP BY
| Oct 12, 2021
MySQL Performance: MyISAM vs InnoDB | Liquid Web
"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 details
| Apr 16, 2021
How can I check if a MySQL table exists with PHP? - Stack Overflow
Even though this isn't the accepted answer, it looks like the best:
if(mysql_query("DESCRIBE [table]")) {
| Jun 14, 2016
The big, bad thread of "MySQL Best Practices and Other Useful Information" - Dat
Good stuff in here
| May 11, 2016
WHERE some-text-column IN ('aaa','bbb','ccc')
WHERE some-int-column IN (1,2,3)
| May 11, 2016
mysql - How can I prevent SQL-injection in PHP? - Stack Overflow
See two answers from user "Your Common Sense"
| Feb 21, 2016
The Hitchhiker's Guide to SQL Injection prevention
| Feb 21, 2016
MySQL :: MySQL 5.5 Reference Manual :: 2.11.1.1 Changes Affecting Upgrades to 5.
Upgrading to MySQL 5.5 from earlier versions
| Dec 23, 2015
NoSQL - Wikipedia, the free encyclopedia
| Jun 5, 2013
Database Abstraction Layers Must Die! (by Jeremy Zawodny)
The first article I read on abstraction layers
| Apr 9, 2008
Annotations to "Five Common PHP database problems" - MySQL-dump
The second article I read, somewhat related but also lists some schemas I need to read up on.
| Apr 9, 2008
Four types of database abstraction layers at Xaprb
A third article with links to the other articles
| Apr 9, 2008
Cheat Sheets - ILoveJackDaniels.com
A bunch of nice cheat sheets and quick reference charts in PDF format.
| Feb 26, 2008
codepoetry - Optimizing a VPS for Getting Dugg
Notes on Apache and MySQL optimization.
| May 29, 2007
| Nov 6, 2006
MySQL 3.23, 4.0, 4.1 Reference Manual
| May 5, 2006
Simple Machines - SMF: Free PHP and MySQL forum software
| May 4, 2006
Database MySQL Optimize MySQL tables for speed Tutorial
| May 3, 2006
This user's friend list is private.
Copyright © 2006-2024 Design215 Inc.
All rights reserved.
Design215 Inc. 
No part of this site may be reproduced without permission.
Linkatopia is a Registered Trademark of Design215 Inc.
html5
pulp7