Gossamer Forum: General: Databases and SQL: Creating table with a TEXT column.: Edit Log

Gossamer Threads

Home : General : Databases and SQL :

General: Databases and SQL: Creating table with a TEXT column.: Edit Log

Here is the list of edits for this post

May 28, 2002, 12:29 PM

Paul

Veteran (19537 posts)

May 28, 2002, 12:29 PM

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

Edit Log:

Post edited by Paul Post edited by Paul (Veteran) on May 28, 2002, 12:30 PM
Post edited by Paul Post edited by Paul (Veteran) on May 28, 2002, 12:30 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676