Raised This Month: $ Target: $400
 0% 

Help (Mysql tables)


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 08-19-2020 , 20:27   Re: Help (Mysql tables)
Reply With Quote #2

Quote:
Originally Posted by jugule View Post
Hi, how can I move a column from this table: Example1 and then move it to Example2? (in plugin)

and then delete the column from the old table if it has been moved to the new table.
SELECT Column1 FROM table1;

In your results handler:

INSERT INTO table2 (Column2) VALUES (col1_value);

Then delete

ALTER TABLE table1
DROP COLUMN Column1;
__________________
Bugsy is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 13:53.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode