-
-
Notifications
You must be signed in to change notification settings - Fork 540
Description
Is your feature request related to a problem? Please describe.
I need some dummy data in a table. How can I create, let's say, 100.000 rows? Might be with a stored procedure or creating an appropriate list of Insert statements, with copy and paste, maybe with the help of Excel or so. For me, it is not so obvious, how to do it easily.
But since HeidiSQL already knows the structure of my table/database, I thought it might be adequate to have a generation option in HeidiSQL. I could imagine that it would be helpful to many users, if there is a nice way to create data easily.
Describe the solution you'd like
Not sure. It's up to you. I thought about an separate dialog, where the user can configure how the data should be generated. Of course, there would be a lot of options. But some basic logic could be there, like incrementing a number or date with a certain interval for each row, starting from a certain point. Or alternating between certain values. Or creating random values. Providing constants would be simple.
From a development perspective I'd say, start basic and add more sophisticated things later.
Describe alternatives you've considered
As described above, I do not know how to create data. Possible that other tools exist, but having it within HeidiSQL would be great!
Of course, this is not implemented in a weekend or so. You can think about it and if so, design it as you like. It is just an idea - whatever you'll do with it.
Love HeidiSQL for long time! Great piece of work!