Articles:

• mysql: How can I rename a database (122415)
• How can I rename table names and column names in mysql (28666)
• How to compare strings in mysql case sensitive (18607)
• Compare 2 dates in mysql (17702)
• Lock an entire mysql database with all its tables (14549)
• How to reset the root password on mysql (12834)
• mysql message ERROR 1054 (42S22): Unknown column in 'on clause' (11530)
• Create UNIQUE Index yields a not unique index in mysql - why? (10718)
• concat () function to concatenate 2 strings in mysql does not exist (5464)
• How to change the next value of an auto_increment field (5160)
• How can I obtain the next auto_increment number (before inserting a record)? (4270)
• My timestamp field in mysql does not update (4081)
• Problems installing DBD::mysql on Solaris 8 (3914)
• Best operating system settings for mysql throughput (3735)
• How to install mysql 5 on Solaris 8 (3711)
• Kill a long running blocking sql statement (3623)
• Handling of dates in mysql (Date formats) (3550)
• How to pick a random record from a mysql table (3260)
• Creating a table with an autoincrement primary key (3239)
• Can I install MySQL without root access? (3159)
• How to limit the size of a MySQL database (3121)
• Restoring the mysql system user table (2614)
• Setting a user password in mysql (Why do I get 'Access denied') (2417)
• What is the MERGE statement good for? (2414)
• Implementing a full text search with mysql (2392)
• Modifying a field to be auto_increment (2387)
• Extracting a table definition from the command line (2257)
• Exporting and importing between 2 mysql databases (2242)
• How can I connect to mysql? I need to update the helpdesk backend (2233)
• count(*) syntax in mysql (2230)
• Stub to connect from a C program to mysql (1994)
• count(distinct fieldname) very slow in mysql (1890)
• JDBC error message Illegal hour value for java.sql.Time type in value (1273)
• What timezone is my mysql database server running in? (1022)
• How to log all mysql database modifications (969)
• Location of mysql startup script (912)
• Monitoring mysql status (496)

Compare 2 dates in mysql Question: I need to compare 2 dates in mysql but I only have version 3.23 of mysql installed and cannot upgrade. Answer: With mysql 4.1.1 the function datediff(date1,date2) and others were introduced. If you are using 4.0 or older, you need to use to_days(date1) and subtract in this form: select TO_DAYS(NOW()) - TO_DAYS(last_modification) from mytable;