August 27th, 2000, 01:16 PM
I'm pretty new at MySQL so any help would be appreciated
To delete from a table I use this:
mysql> DELETE FROM table
-> WHERE (uid = "1");
Now lets say I wanted to delete from uid = 1 till uid = 100. How would I do that?
Thanks for your time!
August 27th, 2000, 04:47 PM
For this particular query you could use:
delete from table where uid<101;
if you want to delete in the middle:
delete from table where uid between 1 and 100;
Note: with between the delimiters are inclusive.