Aaron P. Martinez [EMAIL PROTECTED] wrote:
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.
The above create table statement works fine for me on MySQL version 4.0.17.
Note: Currently CHECK clause does nothing in MySQL:
http://www.mysql.com/doc/en/CREATE_TABLE.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]