A handy little feature I recently learned about is super simple to work with. Use this to copy the structure of a table:
CREATE TABLE table2 ( LIKE table1 INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES );
Then you can copy data into your new table at your liking with:
INSERT INTO table2 SELECT * FROM table LIMIT 100;
Happy programming!
For further actions, you may consider blocking this person and/or reporting abuse
Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.
Brian Keary -
Cesar Aguirre -
Manu Garcia -
Mike Young -
Top comments (0)