Re: simple alternate query

2007-01-27 Thread Miguel Vaz
I am dumb, so sorry: select * from table1 where id=1 or id >=3 and id <=4 Have to go spank myself until i bleed now, thanks. Miguel At 02:15 28-01-2007, Miguel Vaz wrote: Hi, I Cant get a simple query to work, heres what i am look

simple alternate query

2007-01-27 Thread Miguel Vaz
Hi, I Cant get a simple query to work, heres what i am looking for: table1 -- id name 1 peter 2 john 3 mary 4 lisa 5 me I need a select that always ret

Big Table, myisampack or merge?

2007-01-27 Thread altendew
Hi lets say I want to record transactions on my site. This transaction table becomes over 1GB in six months. Which makes it very hard to read. The reading and deleting process becomes very slow. Would it be wise to make a new transaction table every month? Then recreate the merge table? How long