Professional Web Applications Themes

deleting a record error - MySQL

Can anyone be kind enough to tell me what is wrong with the below. I followed the manual instructions and came up with: DELETE * FROM database1 WHERE Firstname = 'dorothy' Surname = 'vincent' Age = '42'...

  1. #1

    Default deleting a record error

    Can anyone be kind enough to tell me what is wrong with the below.

    I followed the manual instructions and came up with:

    DELETE * FROM database1 WHERE Firstname = 'dorothy' Surname = 'vincent' Age
    = '42'



    Mike Guest

  2. #2

    Default Re: deleting a record error

    Mike wrote: 


    Drop the * as you cannot specify columns when deleting.

    Put ANDs between the clauses.



    --
    Brian Wakem
    Email: http://homepage.ntlworld.com/b.wakem/myemail.png
    Brian Guest

  3. #3

    Default Re: deleting a record error


    "Brian Wakem" <com> wrote in message
    news:net... 
    >
    >
    > Drop the * as you cannot specify columns when deleting.
    >
    > Put ANDs between the clauses.
    >
    >
    >
    > --
    > Brian Wakem
    > Email: http://homepage.ntlworld.com/b.wakem/myemail.png[/ref]

    Thank you for taking the time to reply brian. I wasnt aware uisng * would
    not work on delete thank you


    Mike Guest

Similar Threads

  1. Deleting a Record using PHP and MySQL with DreamweaverMX 2004
    By Macnimation in forum Dreamweaver AppDev
    Replies: 7
    Last Post: May 3rd, 10:53 AM
  2. deleting DNS record using dnscmd.exe
    By Kumar in forum ASP.NET Web Services
    Replies: 0
    Last Post: October 14th, 11:05 AM
  3. Deleting a Record.
    By Rob in forum PHP Development
    Replies: 7
    Last Post: November 24th, 07:05 AM
  4. Deleting curent record
    By xool in forum ASP
    Replies: 9
    Last Post: September 11th, 03:51 PM
  5. deleting access database record
    By Tim Midgett in forum ASP Database
    Replies: 3
    Last Post: July 9th, 05:59 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