Need MySQL help with short query.. - GoFuckYourself.com

Pics Traffic · 05-21-2009, 08:03 PM

I have two tables A and B. I want update table A with all entries from table B. Tables have different structures but 2 colums that I want to copy are the same. Help brother out.

rowan · 05-21-2009, 09:05 PM

If you're ever scratching your head about a command, do a search for "COMMAND mysql" and the mysql site is usually the first result.

I presume you want something like this...

INSERT INTO table_B (column1,column2) SELECT column1,column2 FROM table_A;

Back up your data first.

Pics Traffic · 05-21-2009, 09:50 PM

Quote:

Originally Posted by rowan

If you're ever scratching your head about a command, do a search for "COMMAND mysql" and the mysql site is usually the first result.

I presume you want something like this...

INSERT INTO table_B (column1,column2) SELECT column1,column2 FROM table_A;

Back up your data first.

sorry, I should have added that I need to do UPDATE not insert because there's a default value in that field already. I looked all over but still can't figure out what Im doing wrong.

Pics Traffic · 05-21-2009, 10:05 PM

Ok, case closed. Figured it out.

rowan · 05-21-2009, 10:24 PM

So what was the answer?

REPLACE INTO?

Iron Fist · 05-21-2009, 10:43 PM

Love these threads...

HELP ME HELP ME...

Okay FUCK OFF... I GOT IT...

Yeech... at least post what you did that fixed it.

Pics Traffic · 05-21-2009, 11:01 PM

Quote:

Originally Posted by rowan

So what was the answer?

REPLACE INTO?

no, just update.. I was overdoing it. It was easy one.

UPDATE videos v, banners b SET v.BANNER_NAME = b.BANNER_NAME, v.BANNER_URL = b.BANNER_URL WHERE v.VIDEOID = b.VIDEOID

05-21-2009, 08:03 PM	#1
Pics Traffic Confirmed User Industry Role: Join Date: Jun 2004 Location: Europe Posts: 3,055	Need MySQL help with short query.. I have two tables A and B. I want update table A with all entries from table B. Tables have different structures but 2 colums that I want to copy are the same. Help brother out.

05-21-2009, 10:43 PM	#6
Iron Fist Too lazy to set a custom title Join Date: Dec 2006 Posts: 23,400	Love these threads... HELP ME HELP ME... Okay FUCK OFF... I GOT IT... Yeech... at least post what you did that fixed it. __________________ i like waffles

05-21-2009, 09:05 PM	#2
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	If you're ever scratching your head about a command, do a search for "COMMAND mysql" and the mysql site is usually the first result. I presume you want something like this... INSERT INTO table_B (column1,column2) SELECT column1,column2 FROM table_A; Back up your data first.

05-21-2009, 10:05 PM	#4
Pics Traffic Confirmed User Industry Role: Join Date: Jun 2004 Location: Europe Posts: 3,055	Ok, case closed. Figured it out.

05-21-2009, 10:24 PM	#5
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	So what was the answer? REPLACE INTO?