On Sat, Nov 13, 2010 at 5:59 PM, Ken Stanley <[email protected]> wrote:
> CREATE TABLE documents (
> id INT NOT NULL AUTO_INCREMENT,
> language_code CHAR(2),
> tags CHAR(30),
> text TEXT,
> PRIMARY KEY (id)
> );
I apologize, but I couldn't leave the typo in my last post without a
follow up; it might cause confusion. I copied the OP's original table
definition and forgot to remove the tags field. My purposed definition
for the documents table should be:
CREATE TABLE documents (
id INT NOT NULL AUTO_INCREMENT,
language_code CHAR(2),
text TEXT,
PRIMARY KEY (id)
);
- Ken