There are some tools that do that. I use SQLyog - just right click on the table name and it will create the select, insert, update or delete SQL for you.
I also have CF scripts that you can point at a MySQL database and generate input forms and all the select, insert, update and delete statements based on the table structure if that would be helpful. On Tue, Jun 12, 2012 at 7:22 PM, morchella <morchella.delici...@gmail.com> wrote: > > hey in mysql, once you create your db and every thing is all hunky dory, > can it spit out scripts on how to replicate the structure and separate > scripts for data? ms sql server and oracle does. > just got back into a mySql env. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:351908 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm