A date problem

t;select * from Mytable WHERE Date = 'WWW';" it gives me the result: 2 John -00-00 John's project think it should not return any rows. Why? Thanks. I. TS - Before posting, pl

Date and Select problem

t;select * from Mytable WHERE Date = 'WWW';" it gives me the result: 2 John -00-00 John's project I think it should not return any rows. Why? Thanks. I. TS - Be

A Date and Select question.

John's project > > When I use "select * from Mytable WHERE Date = 'WWW';" > > it gives me the result: > 2 John -00-00 John's project > > I think it should not return any values. > > Why? > > Thanks. > >

when column contains spaces

I am a newbie. When I create a table, when one column contains a space, how can I create it correctly in mysql? for example: CREATE TABLE mytable( name CHAR(60) NOT NULL, this column CHAR(60) ///Here there is a space? ); When I use ' or ", it does not

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) ); W