Professional Web Applications Themes

need a help in DELETE syntax - MySQL

i want to deleta a row say DELETE FROM myrow WHERE id=234 ; but i want to know the details of the deleted row without using any second statement !! is it possible to write a statement which will return the details of deleted row !!!...

Sponsored Links
  1. #1

    Default need a help in DELETE syntax

    i want to deleta a row say
    DELETE FROM myrow WHERE id=234 ;

    but i want to know the details of the deleted row without using any
    second statement !! is it possible to write a statement which will
    return the details of deleted row !!!

    Sponsored Links
    piyush Guest

  2. #2

    Default Re: need a help in DELETE syntax

    Don't think so.

    If "select * from myrow where id = 234; delete from myrow where id = 234"
    doesn't work, then I don't think that there's an elegant alternative.

    And what's so bad about a second statement.

    SA

    "piyush" <com> wrote in message
    news:googlegroups.com... 



    Sean Guest

  3. #3

    Default Re: need a help in DELETE syntax

    my php server is using remote mysql server so its advantageous to use
    minimum number of queries / statements

    thanks for reply

    piyush Guest

Similar Threads

  1. if/else tag syntax
    By negttid in forum Macromedia Flex General Discussion
    Replies: 8
    Last Post: March 20th, 02:15 AM
  2. 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
  3. Delete button to delete 3D model
    By mindylim in forum Macromedia Director 3D
    Replies: 1
    Last Post: February 18th, 10:47 AM
  4. Delete key doesn't delete when datagrid is bound to a disconnected table
    By Fred Zolar in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: April 1st, 07:47 AM
  5. Proper Delete From syntax ?
    By ScottHW in forum IBM DB2
    Replies: 1
    Last Post: August 27th, 09:54 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