2 messages in com.mysql.lists.javaRE: A space is contained in colum??
FromSent OnAttachments
Rick Emery31 Oct 2001 11:00 
Jay Fesco31 Oct 2001 12:18 
Subject:RE: A space is contained in colum??
From:Rick Emery (rem@excel.com)
Date:10/31/2001 11:00:38 AM
List:com.mysql.lists.java

What do you mean "there's a space"? You mean after the comma in "CHAR(60), "?

And you you provided is not what you entered into mysql, because "Thrid colum CHAR(60)," won't work; "colum" is not a legal data type

-----Original Message----- From: I. TS [mailto:it@cs.nmsu.edu] Sent: Wednesday, October 31, 2001 12:19 PM To: ja@lists.mysql.com; mys@lists.mysql.com Subject: A space is contained in colum??

I am a newbie.

When I create a table, one colum contains a space, how can I caeate it correctly?

like:

CREATE TABLE mytable( name CHAR(60) NOT NULL, Email VARCHAR(50) NOT NULL, Thrid colum CHAR(60), ///////////////////////////////Here there is a space????????????? PRIMARY KEY (Email) );

When I use ' or ", it doesnot work.

Zhidian

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-remery=exce@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php