Re: [PHP-DB] duplicate a table

2001-04-03 Thread Johannes Janson
Hi, just install phpMyAdmin which has a feature to duplicate tables structure only or structure and data. ""McShen"" [EMAIL PROTECTED] schrieb im Newsbeitrag 9aak89$ruv$[EMAIL PROTECTED]">news:9aak89$ruv$[EMAIL PROTECTED]... how do i duplicate a table? i tried create table refer2 select *

RE: [PHP-DB] duplicate a table

2001-04-03 Thread Rubanowicz, Lisa
I installed mySQLFront and it can do the same thing too through a GUI. You save a *.sql file with or without data. All the Best Lisa -Original Message- From: Johannes Janson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB

RE: [PHP-DB] duplicate a table

2001-04-02 Thread dime
And to go one step further with his question, I would like to know how to do the following: 2 tables named table1 and table2 table1 contains 3 records, firstname, lastname, password. table2 is the same except that it has one more field at the beginning and that field is of type serial. Now,