Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Creating table with a TEXT column.

May 28, 2002, 12:29 PM
Paul
Veteran (19537 posts)
May 28, 2002, 12:29 PM
Views: 9968
Shortcut
Quote Reply
Creating table with a TEXT column.
This always gives me trouble.

Can anyone see the problem with this?

CREATE TABLE Posts(
post_id INT(10) NOT NULL ,
post_ticket_id INT(6) NOT NULL ,
post_subject VARCHAR(255) NULL ,
post_body TEXT(1000) NOT NULL ,
post_timestamp INT(15) NOT NULL ,
PRIMARY KEY (post_id),
UNIQUE (post_id)
)

Last edited by:

Paul: May 28, 2002, 12:30 PM
Subject Author Views Date
Thread Creating table with a TEXT column. Paul 9968 May 28, 2002, 12:29 PM
Thread Re: [Paul] Creating table with a TEXT column. 		Paul 9685 May 28, 2002, 12:32 PM
Thread Re: [Paul] Creating table with a TEXT column. 		Matt G 9666 Jun 19, 2002, 3:27 PM
Thread Re: [Matt Glaspie] Creating table with a TEXT column. 		Paul 9645 Jun 19, 2002, 3:31 PM
Thread Re: [Paul] Creating table with a TEXT column. 		Ian 9648 Jun 19, 2002, 4:16 PM
Thread Re: [Ian] Creating table with a TEXT column. 		Paul 9649 Jun 19, 2002, 4:24 PM
Post Re: [Paul] Creating table with a TEXT column. 		Ian 9615 Jun 19, 2002, 4:26 PM