RE: create table problem - Willis, Nathan - com.mysql.lists.win32

7 messages in com.mysql.lists.win32RE: create table problem

From	Sent On	Attachments
Dino...@Certegy.Com	13 Feb 2003 06:49
Dmytro Khlistunov	13 Feb 2003 07:00
Sheng, Joseph Y [AMSTA-AR-CI]	13 Feb 2003 07:02
Willis, Nathan	13 Feb 2003 07:14
Dino...@Certegy.Com	13 Feb 2003 07:54
Willis, Nathan	13 Feb 2003 08:03
Dmytro Khlistunov	13 Feb 2003 08:39

Subject:	RE: create table problem
From:	Willis, Nathan (will...@mdpr.org)
Date:	02/13/2003 08:03:54 AM
List:	com.mysql.lists.win32

Errcode 2 is "No such file or directory"

you can type in "perror 2" in a dos window in the mysql\bin dir the same in linux just diff directory

-----Original Message----- From: Dino...@Certegy.Com [mailto:Dino...@Certegy.Com] Sent: Thursday, February 13, 2003 9:54 AM To: win...@lists.mysql.com Subject: Re: create table problem

Dmytro:

As you suggested omitted comma after cust_fax line but I'm now getting a different error message???

ERROR 1: Can't create/write to file '.\customer\tbl.frm' (Errcode: 2) mysql>

thanks Dino

Dmytro

Khlistunov To: Dino Ferrari/Risk/STP/US/Certegy@Certegy <dg...@mail.ru> cc: win...@lists.mysql.com

Subject: Re: create table problem 02/13/2003 10:00

Please respond

to Dmytro

Khlistunov

Hello Dino,

Thursday, February 13, 2003, 4:50:18 PM, you wrote:

DFCC> see error message below ... any suggestions? The last comma before ')' is unnecessary.

mysql>> create table customer_tbl DFCC> -> ( DFCC> -> cust_id varchar(10) not null DFCC> primary key, DFCC> -> cust_name varchar(30) not null, DFCC> -> cust_address varchar(20) not null, DFCC> -> cust_city varchar(15) not null, DFCC> -> cust_state char(2) not null, DFCC> -> cust_zip integer(5) not null, DFCC> -> cust_phone integer(10), DFCC> -> cust_fax integer(10), DFCC> -> ); DFCC> ERROR 1064: You have an error in your SQL syntax near ')' at line 11 mysql>> _