Is it possible to cut a MySQL table in half? - GoFuckYourself.com

Rhesus · 01-15-2006, 02:24 PM

Any experts?

s9ann0 · 01-15-2006, 04:09 PM

from top to bottom or left to right ?

mrthumbs · 01-15-2006, 04:10 PM

delete half of the records!

Mr Pheer · 01-15-2006, 04:18 PM

yes its possible with the MySQL table saw

pornguy · 01-15-2006, 04:26 PM

Or you can use the MSQL Jigsaw. Hand held of course.

MattO · 01-15-2006, 04:26 PM

print it out and use scissors

Matt 26z · 01-15-2006, 04:30 PM

Count the number of rows. If there is 1000. Put 500 in one table and the other 500 in another.

drama · 01-15-2006, 04:39 PM

its better to find out what your root problem is rather than start creating multiple tables but incase you're wondering you can have multiple tables which are the same and MERGE. If you're not sure what i mean by "MERGE" then you got some homework to start doing

mikesouth · 01-15-2006, 05:16 PM

If your database design is correct, cutting your table in half will make it wrong. If your design is incorrect cutting it in half wont make it right

determine what your real problem is first.

email me if I can help

Rhesus · 01-15-2006, 05:47 PM

No (root) problems here. And yes, I know what merge means ;-)

Of course you can just select, load into a new table and delete the old records (which is what I've done), I was just wondering if there's a set of queries to do this more easily.

Thanks for the comments!

01-15-2006, 02:24 PM	#1
Rhesus Confirmed User Join Date: Aug 2004 Posts: 2,009	Is it possible to cut a MySQL table in half? Any experts?

01-15-2006, 04:18 PM	#4
Mr Pheer Retired Industry Role: Join Date: Dec 2002 Posts: 21,246	yes its possible with the MySQL table saw __________________ 2 lifeguards for Jessica

01-15-2006, 04:26 PM	#5
pornguy Too lazy to set a custom title Industry Role: Join Date: Mar 2003 Location: Homeless Posts: 62,911	Or you can use the MSQL Jigsaw. Hand held of course. __________________ PornGuy skype me pornguy_epic AmateurDough The Hottes Shemales online! TChicks.com \| Angeles Cid \| Mariana Cordoba \| MAILERS WELCOME!

01-15-2006, 05:16 PM	#9
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	If your database design is correct, cutting your table in half will make it wrong. If your design is incorrect cutting it in half wont make it right determine what your real problem is first. email me if I can help __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

01-15-2006, 04:09 PM	#2
s9ann0 Confirmed User Join Date: Sep 2001 Location: Boston Posts: 4,873	from top to bottom or left to right ?

01-15-2006, 04:10 PM	#3
mrthumbs salad tossing sig guy Join Date: Apr 2002 Location: mrthumbs*gmail.com Posts: 11,702	delete half of the records!

01-15-2006, 04:26 PM	#6
MattO The O is for Oohhh Join Date: Feb 2003 Location: AUSTIN TEJAS Posts: 10,861	print it out and use scissors

01-15-2006, 04:30 PM	#7
Matt 26z So Fucking Banned Industry Role: Join Date: Apr 2002 Location: ¤ª"˜¨๑۩۞۩๑¨˜"ª¤ Posts: 18,481	Count the number of rows. If there is 1000. Put 500 in one table and the other 500 in another.

01-15-2006, 04:39 PM	#8
drama Confirmed User Join Date: Jul 2004 Posts: 847	its better to find out what your root problem is rather than start creating multiple tables but incase you're wondering you can have multiple tables which are the same and MERGE. If you're not sure what i mean by "MERGE" then you got some homework to start doing

01-15-2006, 05:47 PM	#10
Rhesus Confirmed User Join Date: Aug 2004 Posts: 2,009	No (root) problems here. And yes, I know what merge means ;-) Of course you can just select, load into a new table and delete the old records (which is what I've done), I was just wondering if there's a set of queries to do this more easily. Thanks for the comments!