i found: show create table tablename; but there has to be a way to do a db with all tables and data.
On Tue, Jun 12, 2012 at 11:26 PM, Maureen <mamamaur...@gmail.com> wrote: > > 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:351909 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm