Professional Web Applications Themes

Trigger problem - MySQL

I'm a newbie with MySQL, but not with SQL. I wrote an AFTER INSERT trigger to automatically calculate a row, if null, based on a NOT NULL row content. Just a test, like this: CREATE TRIGGER `localdata`.`OnInsertLocaldataContatti` AFTER INSERT ON `localdata`.`contatti` FOR EACH ROW UPDATE `contatti` SET NEW.`anagrafica`='test'; The server refuses to update the row being inserted. Is this really impossible in MySQL? Anyone ever tried to do something similar? Thanks, Salvatore...

  1. #1

    Default Trigger problem

    I'm a newbie with MySQL, but not with SQL. I wrote an AFTER INSERT
    trigger to automatically calculate a row, if null, based on a NOT NULL
    row content. Just a test, like this:

    CREATE TRIGGER `localdata`.`OnInsertLocaldataContatti` AFTER INSERT ON
    `localdata`.`contatti`
    FOR EACH ROW UPDATE `contatti` SET NEW.`anagrafica`='test';


    The server refuses to update the row being inserted. Is this really
    impossible in MySQL? Anyone ever tried to do something similar?

    Thanks,

    Salvatore
    Salvatore Guest

  2. #2

    Default Re: Trigger problem

    == Quote from Salvatore Uras (com)'s article 

    have you tried BEFORE INSERT.
    i think that would be a better fit for this purpose.
    --
    POST BY: lark with PHP News Reader
    lark Guest

  3. #3

    Default Re: Trigger problem

    lark ha scritto:
     

    yep. same ;-). I used to do this in Postgres to insert properly
    formatted calculated rows. No way with my. I think it's not an SQL
    feature, but a design choice. I'll have to use some workaround, I think.
    Salvatore Guest

Similar Threads

  1. Trigger problem!! New transaction cannot enlist.....
    By Mike in forum Microsoft SQL / MS SQL Server
    Replies: 8
    Last Post: August 4th, 08:43 PM
  2. trigger problem!!!!!! HELP!!!!!
    By Mike in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: August 4th, 02:46 PM
  3. Update trigger problem
    By Stephen F Zelonis in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 8th, 01:52 PM
  4. SQL2K Trigger problem
    By Joe Bertolini in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 2nd, 08:42 AM

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