>I want to create two similar tables in MySQL.
>
>is it possible to copy from one table to another, instead of create the table manually?
I'm not familiar with management tools that may be available with MySQL but a couple of possibilities come to mind:
- it might be possible in a GUI-based management tool to copy/paste column definitions
- there may be an option to generate a SQL script that can create the table you want to copy. You could generate that script, modify it to change the name of the table that gets created, then just run the script
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up