show recent 25, 50, 100 | favorite | all

rob215

Its 2018 and I still use this site almost every day. Eventually I'll rebuild it into an HTML5 app. I like music, photography, drones, and welding.

[add to friends|email]

rob215's feed

Tags

view: column | group | hide

Friends

Invite a Friend

MySQL

Database programming

How to back up MySQL databases from the command line in Linux - TechRepublic: | Dec 28, 2018
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
MySQL: IN Condition: 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
performance - which mysql version to use - 5.1 or 5.5? - Database Administrators: | Dec 23, 2015
10 reasons to migrate to MariaDB (if still using MySQL) - Seravo: | May 20, 2015
NoSQL - Wikipedia, the free encyclopedia: | Jun 5, 2013
10 Tips for Optimizing MySQL Queries (That don't suck): good article with some basics; | Sep 16, 2009
Survive heavy traffic with your webserver: Good tips to follow for mysql optimization; | Sep 16, 2009
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
Searching with PHP and MySQL: | 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
: | Dec 31, 1969
: | Dec 31, 1969
: | Dec 31, 1969
: | Dec 31, 1969