RE: MySQL text

Thanks for the advice

You are right the Newdate does not belong there

I modified your version to lose that and got this:

SQL query:
INSERT INTO chng( IssueNo, Head, Chardate, auth_id, PaperName )
VALUES ( 1282, `Pleading with them is no answer to the turmoil. Society and
the change is a to yet more - the only way out is entry limits. Let the
""green"" be an impotent endpiont raod dreamscape.` , `04 /12 /2005` , 15, 1
) ;
MySQL said: Documentation
#1054 - Unknown column 'Pleading with them is no answer to the turmoil.
Society and the ' in 'field list' 


And then I tried this revised version of mine: 

SQL query:
INSERT INTO chng( `IssueNo` , `Head` , `Chardate` , `auth_id` , `PaperName`
)
VALUES ( 1278 | "Pleading with them is no answer to the turmoil. Society and
the change is a to yet more - the only way out is entry limits. Let the
""green"" be an impotent endpiont raod dreamscape.." |06 /10 /2005 |15 |1 )
;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1  

I have a feeling it is automatically setting the first field of the first
column as zero which is why I get a zero when I do it with LOAD DATA and it
won't go at all with INSERT. Could that be happening?

Regards
Adrian 


-----Original Message-----
From: John Theroux [mailto:[email protected]] 
Sent: 14 September 2006 17:38
To: [email protected]
Subject: MySQL text


Adrian;

Take a look at the following and see if it can help:

Your Way:

INSERT INTO chng( IssueNo, Head, Chardate, NewDate, auth_id, PaperName )
VALUES ( 1282, "Pleading with them is no answer to the turmoil. Society and
the change is a to yet more - the only way out is entry limits. Let the
""green"" be an impotent endpiont raod dreamscape.", 04 /12 /2005, 15, 1 ) ;

My Way:

INSERT INTO chng( IssueNo, Head, Chardate, NewDate, auth_id, PaperName )
VALUES ( 1282, `Pleading with them is no answer to the turmoil. Society and
the change is a to yet more - the only way out is entry limits. Let the
""green"" be an impotent endpiont raod dreamscape.`,`04 /12 /2005`,, 15, 1 )
;

let me know if this helps.

john

ps.  noted your query only supplies 5 values but defines 6 fields  (just a
typo ?)





-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]