This is a discussion on Delete data? within the MySQL Database forums, part of the Database Forums category; Hi, The following SQL does not delete as expected: DELETE FROM clinic WHERE field1='The Eye Clinic' LIMIT 1 Can ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
"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 |