Dumbass question

[Jay]

Can you tell me why this isn't working? It's generated by easyphp 1.6 -
myphpadmin. it's driving me bonkers!I go to create a table and this is the
error I get...Thx in advance!CREATE TABLE `customer` (`id` INT(11) NOT NULL
AUTO_INCREMENT PRIMARY KEY, `fname` TEXT(9), `lname` TEXT(9))MySQL said:

You have an error in your SQL syntax near '(9), `lname` TEXT(9))' at line 1

[Andy Hassall]

On Sun, 4 Jan 2004 09:36:40 +1000, "Jay" <gy****@hotmail.com> wrote:

Subject: Dumbass question

(Please use the subject line to describe the subject of your post...)

Can you tell me why this isn't working? It's generated by easyphp 1.6 -
myphpadmin. it's driving me bonkers!I go to create a table and this is the
error I get...Thx in advance!CREATE TABLE `customer` (`id` INT(11) NOT NULL
AUTO_INCREMENT PRIMARY KEY, `fname` TEXT(9), `lname` TEXT(9))MySQL said:

You have an error in your SQL syntax near '(9), `lname` TEXT(9))' at line 1

You can't specify length restrictions on TEXT fields. Sounds like you want
VARCHAR(9) instead.

http://www.mysql.com/documentation/m...l#String_types
http://www.mysql.com/documentation/m...l#CREATE_TABLE

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Jay]

Nevermind - I got it... You dont put down the length in the text fields.
"Jay" <gy****@hotmail.com> wrote in message
news:bt***********@bigblue.net.au...

Can you tell me why this isn't working? It's generated by easyphp 1.6 -
myphpadmin. it's driving me bonkers!I go to create a table and this is the
error I get...Thx in advance!CREATE TABLE `customer` (`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `fname` TEXT(9), `lname` TEXT(9))MySQL said:

You have an error in your SQL syntax near '(9), `lname` TEXT(9))' at line 1

[Jeremy Shovan]

Try this:
create table customer {
id int(11) not null auto_increment primary key,
fname varchar(9),
lname varchar(9)
}

Jeremy Shovan
Image 2020
Foundation X

Jay wrote:

Can you tell me why this isn't working? It's generated by easyphp 1.6 -
myphpadmin. it's driving me bonkers!I go to create a table and this is the
error I get...Thx in advance!
CREATE TABLE `customer` (
`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`fname` TEXT(9),
`lname` TEXT(9)
)
MySQL said:
You have an error in your SQL syntax near '(9), `lname` TEXT(9))' at line 1