Re: mysql question
| From: | Hiroshi Ayukawa | Date: | Tue, 19 Mar 2002 14:19:13 +0000 |
| Subject: | Re: mysql question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-89131@lists.php.net to get a copy of this message | ||
Hello,
The length of VARCHAR must be specified like;
CREATE TABLE sailordata ( sailorid INT(8) NOT NULL DEFAULT 0,
lastname VARCHAR(255) NOT NULL,
firstname VARCHAR(255) NOT NULL,
middlenames VARCHAR(255) NOT NULL,
dob VARCHAR(255) NOT NULL,
telephone VARCHAR(255) NOT NULL,
fax VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL);
Regards,
Hiroshi Ayukawa
http://hoover.ktplan.ne.jp/kaihatsu/php_en/index.php