Home » Posts tagged with "mysql"

Often we search for records in a database table for fetching records that were created or modified on a particular date or between two dates. We match against a date field and add multiple conditions to find records with a date field value ranging between two dates. It would look something like this: Select * from tables where CREATE_TIME >= "2007-03-14...
Failed To Read Auto-Increment Value From Storage Engine Error in MySQL. This is a very strange MySQL error. The error happens when trying to insert a new row in to a table. Basically this is a bug in MySQL that causes the problem but a work around is simple. The problem happens when the Auto-Increment value of a table grows beyond the limit. Just run...
Filed in: PHP/MySQL
Often, we come across situations where we need to INSERT multiple rows in to a database table from an Array, File or even from another Database Table. I am explaining various methods for inserting multiple rows using a single query using MySQL and PHP. MySQL documentation says you can use the following methods to speed up inserts: If you are inserting...
If you guys haven’t heard about or started using MySQL Workbench yet, it’s high time you started exploring it. MySQL Workbench is a visual database design tool that integrates database design, modeling, creation and maintenance into a single, seamless environment for the MySQL database system. Sun Microsystems has recently released the 5.2...
Filed in: PHP/MySQL

Page optimized by WP Minify WordPress Plugin