Professional Web Applications Themes

Delete data? - MySQL

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...

  1. #1

    Default 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 Guest

  2. #2

    Default Re: Delete data?

    "no.mail.pls" <no.mailst.peters> wrote in message
    news:440d2d2e$0$15794$14726298news.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.


    Bill Karwin Guest

  3. #3

    Default Re: Delete data?

    > 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
    [url]http://www.upscene.com[/url]
    My thoughts:
    [url]http://blog.upscene.com/martijn/[/url]
    Database development questions? Check the forum!
    [url]http://www.databasedevelopmentforum.com[/url]


    Martijn Tonies Guest

Similar Threads

  1. Remove data from multiple fields with one delete
    By Dasman@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: October 18th, 10:48 PM
  2. Delete data from mulitple fields in one deletion
    By Dana in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: October 6th, 08:31 PM
  3. Delete form - Post data to a table and delete uponsubmit.
    By FusionRed in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: July 28th, 01:27 PM
  4. Edit, Add , Delete Data from a DataGrid
    By Anish in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: July 18th, 12:01 AM
  5. Accessing data object on delete command.
    By Cappy in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: April 20th, 06:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139