Delete data?

Hi,

The following SQL does not delete as expected:

DELETE FROM clinic WHERE field1='The Eye Clinic' LIMIT 1

Can anyone pls tell what's the error?

TIA

"no.mail.pls" <no.mail@st.peters> wrote in message
news:440d2d2e$0$15794$14726298@news.sunsite.dk...
> The following SQL does not delete as expected:
>
> DELETE FROM clinic WHERE field1='The Eye Clinic' LIMIT 1
>
> Can anyone pls tell what's the error?

That depends on what you expected it to do, and what it actually did do.

We don't know from your message the answer to either point!

Regards,
Bill K.

> The following SQL does not delete as expected:
>
> DELETE FROM clinic WHERE field1='The Eye Clinic' LIMIT 1
>
> Can anyone pls tell what's the error?

What error? Let us know:

1) the expected behaviour

2) what actually happens

3) if an error is raised, what is the error.

Try to ask your question by explaining it to someone who
has absolutely no idea what you're doing. Like us :-)


--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com