Posts Tagged "Database"

  • Generate data for Database testing

    Databases
    Generate data for Database testing

    Image by lilit via Flickr How often have you tested your application on your local machine and had it run properly, but when you deploy it and the database starts getting filled up, you start noticing performance problems? Here’s something you can use to test out your application with databases which are not empty – [...]

    Read More...

  • MySQL Error: 1062 Duplicate entry ’0′ for key 1

    Databases
    MySQL Error: 1062 Duplicate entry ’0′ for key 1

    Here’s a problem we had come across today. Whenever we tried inserting data into a certain table, MySQL kept throwing up the following error: mySQL error: 1062 Duplicate entry ’0′ for key 1 After scratching our heads over this one, we tried to alter the table to set the autoincrement field to the next number [...]

    Read More...