On Tue, May 17, 2011 at 6:46 PM, Erik Rose <[email protected]> wrote: >> Is there a sensible to way "copy" databases in SQL? > > SQL 2003 introduced CREATE TABLE x LIKE y for cloning the schema of a table. > It's supported in MySQL at least. You could then do a bunch of INSERT INTO > ... SELECTs if you deferred foreign key checks first. > > Wait, why do you want to?
I suspect he was thinking of PostgreSQL's support for template databases. It skips parsing overhead, so that creating a copy of a template is roughly disk-bound. -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
