Knowledge Walls
John Peter
Pune, Maharashtra, India
How to copy table with constraints in mysql?
Creating a new table by existing table with constraints.
-- To copying table with constraints
CREATE TABLE new_table_name LIKE old_table_name;

-- To copying without constraints
CREATE TABLE new_table_name
(SELECT * FROM old_table_name WHERE 0);
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details