Hello, Today, I compiled MySQL (mysql-3.23.49.tar.gz) on a Debian Potato system. I configure'd with following options:
./configure --prefix=/usr/local/mysql --with-innodb "make" and "make install" ran without any problems. Then I followed the instructions in the INSTALL-SOURCE file. Everything worked fine. Then, I tried to create a InnoDB-Table in the test database: shell> /usr/local/mysql/bin/mysql -u root -p mysql> use test mysql> create table workorders (wo_no varchar(12) not null, foreign_log_no varchar(12) not null default '', primary key(wo_no)) type=innodb; Table creation didn't succeed and I've an error message: ERROR 1005: Can't create table './test/workorders.frm' (errno: 150) After checking my statement and trying to create other InnoDB tables (which succeeded!) I tried: mysql> create table workorders (wo_no varchar(12) not null, foreig_log_no varchar(12) not null default '', primary key(wo_no)) type=innodb; Here is what I've got: Query OK, 0 rows affected (0.00 sec) The only different thing is that I changed "foreign_log_no" to "foreig_log_no". It seems that the MySQL parser got irritated when I tried to use "foreign" as a beginning of a column name. Regards, Borislav -- Borislav Bankov mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
