Hi

Can somebody help me here:

I have quite a number of rows between a ceta row and another row in my DB that I want to delet.

I tried:

DELETE FROM table WHERE "col1" >= '40000' AND "col1" =<50000It gives me a syntax error.Thanks Josil

Try

DELETE FROM table WHERE col1 >= 40000 AND col1 =<50000

Assuming that col1 is of a numerical type.

Originally Posted by JeremyMiller

Try

DELETE FROM table WHERE col1 >= 40000 AND col1 =<50000

Assuming that col1 is of a numerical type.

Nop

I have tried with comas without comas with parenteses but does not work

I forgot to answer that col1 is in fact numeric type instead of col1 as name the real name of the field is id

in other words just to replace col1 by id

Then, what's the error message you get when you do the query? What's the DB structure? Which SQL engine are you using?

DELETE FROM table WHERE id BETWEEN anumber AND anothernumber;

Is that for different versions of SQL, Chris?

Did you get my PM about your sig?

Without knowing the important stuff, this is only a guess, and likely not to contribute much more than others already have.

DELETE table WHERE ID BETWEEN x AND y

Or, better, select the rows you don't want to delete into another table, drop the first, and rename the second. It'll be faster this way.

Peolple

It was very simple in my case. just made it the following way:

Because onde of the fiels called mails was no data, just...

delete table where 'id' = ''


and that's it. I manage to get a lot of junk in DB

But now I have a quite number of raws cuted. For example I've row 4235 and follwoing row is 5120.

How can now I renumerate the table from row number 1 to whatever number it ends

Regenerating those ID values so they're sequential is easy. You could drop the column and add another one. You could move the data into a new table with an auto increment ... which would let you keep them in the same order they are now, if that's important.

Those rows you deleted, were the ID values 'connected' to anything? That could be the hard part. I'm guessing you're ok, but...?

Originally Posted by JeremyMiller

Is that for different versions of SQL, Chris?

Did you get my PM about your sig?

Yep to both,

Standard ANSI SQL for the first and the second is, I've not replied 'cos last week was hectic should have more time this week.

Thanks people

Everything is fine now...

I think this is my first post on this forum so hello.

A general suggestion for getting the correct MySql syntax is to use (in this case) phpmyadmin to delete a few rows at a time. You should get a result that shows the query used.

Just a general idea.

oops, on edit its my 6th post

DELETE FROM table WHERE col1 >= '40000' AND col1 =< '50000' LIMIT 10

Don't forget to add a limit at the end of your query. Sometimes you can have nasty surprises if you muff up something in your query .