From: Aaron P. Martinez (mlproficuous.com)
Date: Thu Jan 29 2004 - 02:19:24 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I am trying to set up a table from a script that came with some software
"Value accounting/CRM" and i'm getting a few errors, one of which i
can't seem to figure out/fix.

My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb
tables configured with the following statement in my /etc/my.cnf:
innodb_data_file_path = ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_log_file_size=20M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1

The create table statement is below followed by the error.

create table ItemSalesTax (
         STYPE integer not null primary key, /* STax Type */
         SDESC varchar(35),
         SPERC numeric(13,4) zerofill not null /* Percentage */
                    check(SPERC >= 0),
         SCONUM integer not null,
         SYRNO integer not null,
         SLEVEL varchar(4) not null, /* Access Control Level */
         constraint staxlevel_ck
                    check (SLEVEL in ('READ','RW','DENY')),
         constraint STax_fk foreign key (SCONUM, SYRNO)
                    references AccYear(ACONUM, AYEARNO)
        );

ERROR 1064: You have an error in your SQL syntax near 'check(SPERC >=
0),
         SCONUM integer not null,
         SYRNO i' at line 9

I am not great w/mysql but gradually learning. I have looked in the
online manual and can't find anything that helps.
I would really like to get this going as soon as possible to
evaluate...any and all help is GREATLY appreciated.

Thanks,

Aaron Martinez

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]