Mysql expert needed... - GoFuckYourself.com

acctman · 02-15-2006, 01:37 PM

does anyone know how to merge to tables? Table1_members needs to receive all the fields and setting in Table2_users. anyone know hwo to do this merge either via shell or phpmyadmin

Baker Rd · 02-15-2006, 01:44 PM

are the tables identical?

acctman · 02-15-2006, 01:47 PM

no not identical. they're both in the same database though. one is rate_members and the other is phpbb_users. i need all the fields with there settings from phpbb_users (with the exception of username and user_id, i'll drop those fields) moved/copied to rate_members.

i've check both tables and there won't be a overlapping problem since all fields in phpbb_users are unique

Baker Rd · 02-15-2006, 01:50 PM

you can try something like this

INSERT INTO rate_members (field1,field2,field3) SELECT field1,field2,field3 FROM phpbb_users

Fresh · 02-15-2006, 01:52 PM

the way we would do it is first create a duplicate of the destination via phpmyadmin (operations>copy table with data/structure) then write a simple php script to read the one you want to merge, and as you loop thru the results, import to the duplicate version passing only the variables that are required to make the entry valid in the copy. Once you confirm the data is correct, u can rename the tables via the same way (operations>rename) and make it live without any hiccups.

StuartD · 02-15-2006, 01:57 PM

Quote:

Originally Posted by Dave Guru

the way we would do it is first create a duplicate of the destination via phpmyadmin (operations>copy table with data/structure) then write a simple php script to read the one you want to merge, and as you loop thru the results, import to the duplicate version passing only the variables that are required to make the entry valid in the copy. Once you confirm the data is correct, u can rename the tables via the same way (operations>rename) and make it live without any hiccups.

acctman · 02-15-2006, 02:03 PM

ok i'll try the php script version, i know enough php to do something small like that. thanks

acctman · 02-15-2006, 03:40 PM

i did some research looks like i need to use ALTER to add to an existing table

ALTER TABLE table_name
ADD column_name datatype

Baker Rd · 02-15-2006, 04:12 PM

Quote:

Originally Posted by acctman

i did some research looks like i need to use ALTER to add to an existing table

ALTER TABLE table_name
ADD column_name datatype

heh, I totally misunderstood your question

FuqALot · 02-15-2006, 04:27 PM

Quote:

Originally Posted by Dave Guru

the way we would do it is first create a duplicate of the destination via phpmyadmin (operations>copy table with data/structure) then write a simple php script to read the one you want to merge, and as you loop thru the results, import to the duplicate version passing only the variables that are required to make the entry valid in the copy. Once you confirm the data is correct, u can rename the tables via the same way (operations>rename) and make it live without any hiccups.

Only non mysql experts would do that. If you really know mysql you could do it by using a query. Whenever I need stuff done I go to expertsexchange.com, post my question and within minutes i have a query.

Baker Rd · 02-15-2006, 04:35 PM

Quote:

Originally Posted by FuqALot

Only non mysql experts would do that. If you really know mysql you could do it by using a query. Whenever I need stuff done I go to expertsexchange.com, post my question and within minutes i have a query.

unless there is data to change I also see no need for this, sql is very powerful and most php programmers hardly know how to do anything but INSERT and SELECT lol

devilspost · 02-15-2006, 04:42 PM

expertSEXchange.com hehe

Nathan · 02-15-2006, 04:49 PM

The real question here is: why in gods name do you want to do that?!

Either learn how to do joins, or if you use mysql 5, setup a damn view.

Fresh · 02-15-2006, 05:43 PM

Quote:

Originally Posted by FuqALot

Only non mysql experts would do that. If you really know mysql you could do it by using a query. Whenever I need stuff done I go to expertsexchange.com, post my question and within minutes i have a query.

to each his own - if one of your buddies at expertsexchange gives you an incorrect query, its gonna fuck shit up

the safest way of going about it is as i described.

02-15-2006, 01:37 PM	#1
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	Mysql expert needed... does anyone know how to merge to tables? Table1_members needs to receive all the fields and setting in Table2_users. anyone know hwo to do this merge either via shell or phpmyadmin

02-15-2006, 01:44 PM	#2
Baker Rd Confirmed User Join Date: Nov 2005 Posts: 647	are the tables identical? __________________ money talks and bullshit walks.

02-15-2006, 01:50 PM	#4
Baker Rd Confirmed User Join Date: Nov 2005 Posts: 647	you can try something like this INSERT INTO rate_members (field1,field2,field3) SELECT field1,field2,field3 FROM phpbb_users __________________ money talks and bullshit walks.

02-15-2006, 01:52 PM	#5
Fresh TubeClicks.com - First Tube Affiliate Program Join Date: Mar 2005 Location: LA Posts: 4,920	the way we would do it is first create a duplicate of the destination via phpmyadmin (operations>copy table with data/structure) then write a simple php script to read the one you want to merge, and as you loop thru the results, import to the duplicate version passing only the variables that are required to make the entry valid in the copy. Once you confirm the data is correct, u can rename the tables via the same way (operations>rename) and make it live without any hiccups. __________________ Promote ONE Legal Tube Site, Collect Checks from 19 Sponsors Fresh Dave \| Email: [email protected] \| ICQ: 317160390

02-15-2006, 04:42 PM	#12
devilspost Confirmed User Industry Role: Join Date: Feb 2004 Location: Tampa yomebe -at- hotmail Posts: 3,980	expertSEXchange.com hehe __________________ Brothels and Escorts Worldwide.

02-15-2006, 01:47 PM	#3
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	no not identical. they're both in the same database though. one is rate_members and the other is phpbb_users. i need all the fields with there settings from phpbb_users (with the exception of username and user_id, i'll drop those fields) moved/copied to rate_members. i've check both tables and there won't be a overlapping problem since all fields in phpbb_users are unique

02-15-2006, 02:03 PM	#7
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	ok i'll try the php script version, i know enough php to do something small like that. thanks

02-15-2006, 03:40 PM	#8
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	i did some research looks like i need to use ALTER to add to an existing table ALTER TABLE table_name ADD column_name datatype

02-15-2006, 04:49 PM	#13
Nathan Confirmed User Industry Role: Join Date: Jul 2003 Posts: 3,108	The real question here is: why in gods name do you want to do that?! Either learn how to do joins, or if you use mysql 5, setup a damn view. __________________ "Think about it a little more and you'll agree with me, because you're smart and I'm right." - Charlie Munger