UBB.Dev
Posted By: Ian_W copying a table - 06/10/2005 8:17 PM
Hi,

Can anyone help me with this. Should be fairly simple and I have tried

select * from w3t_Groups into w3t_Groups_Master

without joy.

I need to make a backup of w3t_Groups before I start fiddling with it

Thanks.
Posted By: Anno Re: copying a table - 06/10/2005 9:29 PM
Code
 <br />CREATE TABLE `w3t_Groups_Master` (<br />`G_Name` varchar( 250 ) default NULL ,<br />`G_Id` int( 4 ) unsigned NOT NULL AUTO_INCREMENT ,<br />`G_Disabled` int( 1 ) unsigned default '0',<br />PRIMARY KEY ( `G_Id` )<br />) TYPE = MYISAM ;<br /><br />INSERT INTO `w3t_Groups_Master`<br />SELECT *<br />FROM `w3t_Groups` ;<br /><br /> 
Posted By: scroungr Re: copying a table - 06/10/2005 10:11 PM
or use phpMyAdmin and do Operations and there is a MOVE, COPY, RENAME, etc command
© UBB.Developers