Statement Conversion Access -> mySQL

[ryanb006]

SQL = "DELETE FROM table WHERE ID IN (1, 9, 15, 20)"

The above statement is for deleting records in access using checkboxes on a
form (deletes records with ID 1, 9, 15, 20). How can I use the same
principle for mySQL?

--
[email]ryanbNOSPAM006@hotNOSPAMmail.com[/email]
(remove the NOSPAMs to reply by email)

[Mark Schupp]

Are you saying that mySQL does not support "IN" in SQL statements?
Have you checked the mySQL docs?

If IN is not supported then you will have to change the where clause to use
OR

where id=1 or id=9 or...

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"ryanb006" <ryanbNOSPAM006@hotNOSPAMmail.com> wrote in message
news:OkgjorWQDHA.2176@TK2MSFTNGP12.phx.gbl...

>
> SQL = "DELETE FROM table WHERE ID IN (1, 9, 15, 20)"
>
> The above statement is for deleting records in access using checkboxes on

a

> form (deletes records with ID 1, 9, 15, 20). How can I use the same
> principle for mySQL?
>
> --
> [email]ryanbNOSPAM006@hotNOSPAMmail.com[/email]
> (remove the NOSPAMs to reply by email)
>
>

[ryanb006]

I just tested it and it works. I thought maybe you had to do it a
little different than in Access; like Access does not support "...LIMIT
0, 30".


Mark Schupp wrote:

> Are you saying that mySQL does not support "IN" in SQL statements?
> Have you checked the mySQL docs?
>
> If IN is not supported then you will have to change the where clause to use
> OR
>
> where id=1 or id=9 or...
>