"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
>
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/
The "," is required before the PRIMARY KEY declaration.
It fails without it.
Removing the "," before the CHECK declaration simply generates a similar
error sooner:
ERROR 1064: You have an error in your SQL syntax near 'CHECK (max_sched
REGEXP "[0-9]")) TYPE=Innodb;'
v> From create syntax, you can
From create syntax, you cannot put , after VARCHAR(1). You have another ,
after AUTO_INCREMENT, maybe it is not correct too.
At 01:56 PM 7/31/2002 -0400, Larry Irwin wrote:
>Using MySQL 4.02 on SuSE Linux 7.3
>The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that
>CHECK (ex
Using MySQL 4.02 on SuSE Linux 7.3
The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that
CHECK (expr) is not parsed for table types other that innodb. But when the
table type is innodb I assume it is parsed. I'd like to retain the CHECK
parameters in my CREATE scripts, but ca
In the last episode (Jul 12), Larry Irwin said:
> I'd like to set up my CREATE's to have CHECK and REGEXP but can't
> seem to get 4.0.2 to accept my attempts...
>
> CREATE TABLE IF NOT EXISTS aptype (
> aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
> appt_type VARCHAR(3) NOT NU
I'd like to set up my CREATE's to have CHECK and REGEXP but can't seem to
get 4.0.2 to accept my attempts...
CREATE TABLE IF NOT EXISTS aptype (
aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
appt_type VARCHAR(3) NOT NULL,
branch VARCHAR(2),
print_ticket VARCH
I'd like to set up my CREATE's to have CHECK and REGEXP but can't seem to
get 4.0.2 to accept my attempts...
CREATE TABLE IF NOT EXISTS aptype (
aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
appt_type VARCHAR(3) NOT NULL,
branch VARCHAR(2),
print_ticket VARCH
