innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Hope this helps,
Larry Irw
Since CHECK cannot be used in CREATE TABLE in any way, shape or form, remove
it from the documentation for CREATE TABLE.
Lary Irwin
CCA Medical
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (th
nnodb;'
v> From create syntax, you cannot put , after VARCHAR(1). You have another ,
v> after AUTO_INCREMENT, maybe it is not correct too.
v> At 01:56 PM 7/31/2002 -0400, Larry Irwin wrote:
> l>Using MySQL 4.02 on SuSE Linux 7.3
> l>The MySQL docs at http://www.mysql.com
nodb;
This generates:
ERROR 1064: You have an error in your SQL syntax near '(max_sched REGEXP
"[0-9]"
Is there a syntax that will pass the parser? Or should the CHECK option in
the CREATE TABLE documentation be removed completely?
Best Regards,
Here's the doc page.
http://www.mysql.com/doc/S/o/Sorting_rows.html
Later,
Larry
>From: "DonPro" <[EMAIL PROTECTED]>
>Subject: Key in reverse order
> Hi, I have a MySQL table key on a 7 character VarChar field. Th efile
> contains
> numeric characters only which I've inserted right justified. Is
),
print_ticket VARCHAR(1), CHECK (SELECT (print_ticket) REGEXP "[0-9]"),
print_on_stmtVARCHAR(1), CHECK (print_on_stmt IN "Y|N|E|R"),
produce_ticket VARCHAR(1), CHECK (produce_ticket REGEXP [ASP])
) TYPE=InnoDB;
None of the CHECK stmts will pass the syntax checker...
Help g
),
print_ticket VARCHAR(1), CHECK (SELECT (print_ticket) REGEXP "[0-9]"),
print_on_stmtVARCHAR(1), CHECK (print_on_stmt IN "Y|N|E|R"),
produce_ticket VARCHAR(1), CHECK (produce_ticket REGEXP [ASP])
) TYPE=InnoDB;
None of the CHECK stmts will pass the syntax checker...
Help g
f you remove the symlink and mv the distro name dir to mysql, then it
works.
Larry Irwin
CCA Medical
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Not really a simplistic one, but simple to set-up and use:
http://phpnuke.org
Very nice dynamic php/mysql based web site you can download and install.
Larry Irwin
CCA Medical
- Original Message -
From: "Taylor Lewick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
