CREATE TABLE articles_backup LIKE articles
The code above creates a new table called "articles_backup" which has the exact same structure and attributes as the original articles table.
CREATE TABLE articles_backup SELECT * FROM articles;
The above code does the same thing as the first example, BUT it also copies all of the data.........
Create Table with structure of another existing tableOk, this has many valid uses such as if you need to create backups or the ability to undo changes, you would want to create new tables with the same structure as another. Here is how you do it.
[i:7ed9581493]
Also remember Indexes such as PRIMARY KEYS [b:7ed9581493]will not be preserved[/b:7ed9581493] so you will have to readd them manually.[/i:7ed9581493]
[code:1:7ed9581493]CREATE TABLE NewName AS SEL........