When creating a web application it is essential that we test to see if it will work in the “real world” before releasing it into the wild. To test our application many of us use the ever tedious “insert” command in phpMyAdmin to create dummy records. This is a long process and more often than not we simple copy the records of the one before. Generate Data fixes this.
Generate Data allows you to generate up to 200 records to input into your database, regardless of your table structure and fields.
Type in the name of each of your rows for your table, then specify your datatype for each row, (there are 15 choices including Auto-Increment, Phone Number, Address, Email and Date). After that, you can output the results as XML, CSV, Excel, HTML and SQL (MySql or Oracle) to be inserted directly into your database.
Outputting as SQL can save a load of time that would normally have been spent using the simple “insert” command on phpMyAdmin. Generate Data also generates unique data. What this means is that no two names, addresses, or phone numbers will be the same and all emails will be unique and valid.
Generate Data is a great, free, database field generator that is extremely useful if you want to see how it would work in the real world using dummy entries.