ilovejackdaniels.com — "The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database."
Dec 13, 2006 View in Crawl 4
jull1234Dec 14, 2006
I too love Jack Daniels. It is a fine whiskey product which mixes well with Coca Cola.
csrsterDec 14, 2006
wtf? Are you saying that MySql is peculiarly ill-adapted to web-apps? Or that anyone who doesn't already know MySql is clearly too ignorant to ever learn how to use it? Or that MySql-specific constructs are so intuitively obvious that a cheat sheet is unnecessary?
lovejackdanielsDec 14, 2006
"More to the point though, I thought people get bitched at all the time for posting their own stuff here."I'm pretty sure the original author wasn't the one who posted this link.
skankybaconDec 14, 2006
I hadn't dugg you down, but now I have to, because I hate when people get all indignant about being dugg down. It happened; life goes on.
Closed AccountDec 14, 2006
...ok, so then I'll repeat myself without saying that I don't understand why people are digging me down (and then I'll digg you down). :-POn a typical commercial web hosting platform -- PHP 4.x, MySQL 4.x, and Apache 1.x -- using native PHP MySQL functions is measurably faster than using PEAR:DB. There are performance benefits to PEAR:DB, yes, but they are nullified by the performance impact of not using the native functions, which are, after all, optimized for MySQL.
tenebrousxDec 14, 2006
@ prockcore - PHP can do prepared statements directly to MySQL as well. If you are making a web app for your system, I find it's best to just use direct MySQL statements
jwm0zDec 20, 2006
I think it's useless without UPDATE and INSERT syntax - the ones I always forget, not SELECT.