I have a MySQL workbench model that I've used to generate a schema. To play around with it, I'd like a bunch of fake data. Is there an easy way to generate this, or must I do it by hand?
+3
A:
This is a site I always use to generate dummy data. http://www.generatedata.com This will generate the data as well as the insert scripts.
codeape
2010-02-18 22:12:22
But it doesn't support foreign keys...
Rosarch
2010-02-18 22:16:26
Good point. A hastle, but manageable solution would be in your foreign key column, use the number range in the data type column with the max number being the biggest key in your related table. This comes with a few drawbacks such as only being able to reliably use a freshly generated (full set) of data. This also assumes your keys are always numbers.
codeape
2010-02-18 22:27:51
Well, fortunately for me in playing with this data I'm only reading it, not altering it in any way. So perhaps the lack of foreign keys isn't a huge issue.
Rosarch
2010-02-18 22:37:52