How to compare timestamp dates with date-only parameter in MySQL??

In a SQL statement, how do I compare a date saved as TIMESTAMP with a date in YYYY-MM-DD format? Ex.: SELECT * FROM...

#1071 - Specified key was too long; max key length is 767 bytes?

When I executed the following command: ALTER TABLE `mytable` ADD UNIQUE ( `column1` , `column2` ); I got this err...

AJAX update MYSQL database using function called from HTML generated from PHP?

I have a php page generating and displaying a table. for the last row in the table i want to display an image with a...

access denied for load data infile in MySQL?

I use MySQL queries all the time in PHP, but when I try LOAD DATA INFILE I get the following error #1045 - ...

MySQL update conditions in one query (UPDATE, SET & CASE)?

I'm trying to update a set of records (boolean fields) in a single query if possible. The input is coming from pagi...