* deleting multiple rows from a table * help!!!

[Zekii61]

Ok, so the assignment is to delete rows in a table that consist of employee ids 202 - 205



I input the following code:


delete from sec0412_foods
where employee_id between '202'
and '205';



And then I come across this error:







Where am I making a mistake? I am just a beginner and I'm bleeding out my nose here trying to force my brain to get it but no!

[alansidman]

Delete sec0412_foods.employee_id
FROM sec0412_foods
WHERE (((sec0412_foods.employee_id) Between "202" and "205"));

Look here to make sure you understand the syntax for delete queries.

http://www.w3schools.com/sql/sql_delete.asp

[Zekii61]

I've tried your code but im still getting the parameter box popping up..

[Zekii61]

Hey, btw it's fine you don't need to do anything I've found my way through it

The code has to look like this

delete *
fromsec0412_employees
where employee_idbetween 202 and 205;

Thank you again !