Professional Web Applications Themes

'trigger int(5) default NULL - MySQL

mysql pdw < pdw.dump ERROR 1064 (42000) at line 1867: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'trigger int(5) default NULL, resume_path varchar(80) default NULL, new_resum' at line 102...

  1. #1

    Default 'trigger int(5) default NULL

    mysql pdw < pdw.dump

    ERROR 1064 (42000) at line 1867: You have an error in your SQL syntax; check
    the manual that corresponds to your MySQL server version for the right
    syntax to use near 'trigger int(5) default NULL,

    resume_path varchar(80) default NULL,

    new_resum' at line 102




    nobody Guest

  2. #2

    Default Re: 'trigger int(5) default NULL

    On Fri, 8 Jun 2007 18:28:28 -0700, "nobody" <com>
    wrote:
     

    "trigger" is a reserved word, can't be used as a column name,
    unless you quote it in backticks like: `trigger`.
    --
    ( Kees
    )
    c[_] Doing nothing makes me tired 'cause I can't take a break. (#228)
    Kees Guest

  3. #3

    Default Re: 'trigger int(5) default NULL

    I tried to import a 3.23 databse dump to a mysql 5 database and got thius
    error. any idea what i should do
    "Kees Nuyt" <demon.nl> wrote in message
    news:demon.nl... 
    >
    > "trigger" is a reserved word, can't be used as a column name,
    > unless you quote it in backticks like: `trigger`.
    > --
    > ( Kees
    > )
    > c[_] Doing nothing makes me tired 'cause I can't take a break. (#228)[/ref]


    nobody Guest

  4. #4

    Default Re: 'trigger int(5) default NULL

    > "Kees Nuyt" <demon.nl> wrote in message 
    >>
    >> "trigger" is a reserved word, can't be used as a column name,
    >> unless you quote it in backticks like: `trigger`.
    >> --
    >> ( Kees
    >> )
    >> c[_] Doing nothing makes me tired 'cause I can't take a break. (#228)[/ref][/ref]
    nobody wrote: 
    Please do not top post.
    What you should do is what Kees told you to do!


    Paul Guest

Similar Threads

  1. #39808 [NEW]: null does not set default in function
    By david at 1st-affiliation dot com in forum PHP Bugs
    Replies: 4
    Last Post: December 12th, 09:59 PM
  2. #39808 [Opn->Bgs]: null does not set default in function
    By tony2001@php.net in forum PHP Bugs
    Replies: 0
    Last Post: December 12th, 09:00 PM
  3. Replies: 0
    Last Post: August 30th, 07:48 AM
  4. Have trigger supply value for NOT NULL column on insert
    By Ian Boyd in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 3rd, 02: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