Fwd: Re: errir in SQL syntax

[AC]

You need to reply to all to make this back to the mailing list.
Forwarding for the list.





Thanks for hint. This is form the webpage https://wiki.gnucash.org/wiki/SQL
Maybe somebody can correct this?

Wolfgang

On Mon, Dec 18, 2017 at 8:30 AM, AC <gnucash at acarver.net
<mailto:gnucash at acarver.net>> wrote:

    You misspelled AUTO_INCREMENT (note the underscore character).


    On 2017-12-17 23:03, Wolfgang Paul Rauchholz wrote:
    > My config:
    > Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64
    >
    > Setting up the database on my home server. Will connect fomr
    laptops in the
    > network onto mariadb.
    >
    > When trying to execute this command.
    >
    > CREATE TABLE slots (
    >     id integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    >     obj_guid            CHAR(32) NOT NULL,
    >     name                text(4096) NOT NULL,
    >     slot_type           integer NOT NULL,
    >     int64_val           integer,
    >     string_val          text(4096),
    >     double_val          real,
    >     timespec_val        CHAR(14),
    >     guid_val            CHAR(32),
    >     numeric_val_num     integer,
    >     numeric_val_denom   integer
    > );
    >
    > I get this error. I can't find anything in google, so I'd hoped I
    get some
    > help here. Thank you
    >
    >
    > ERROR 1064 (42000): You have an error in your SQL syntax; check
    the manual
    > that corresponds to your MariaDB server version for the right
    syntax to use
    > near 'NOT NULL,
    >     obj_guid            CHAR(32) NOT NULL,
    >     name                tex' at line 2
    >
    >
    > Thansk for your help
    >
    >

    _______________________________________________
    gnucash-user mailing list
    gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
    https://lists.gnucash.org/mailman/listinfo/gnucash-user
    <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
    -----
    Please remember to CC this list on all your replies.
    You can do this by using Reply-To-List or Reply-All.




-- 

Wolfgang Rauchholz