* Steve Edberg > At 1:10 PM +0300 4/19/02, cristian ditoiu wrote: > >mysql> INSERT INTO ref_data VALUES (186, 139, 'Tess of the > D\'Urbervilles', > >'THOMAS HARDY\r\nTESS OF THE D'URBERVILLES\r', 'tess.DOC', '2002-02-06', > > ...............................^ > > There's an unescaped ' there; if you created this dump from > phpmydmin, perhaps there's a quote handling bug somewhere... > > That's a strange error, though, since AFAIK there's no place to put a > hostname in an INSERT. > > -steve > > > >648, 15872, 1, '', 10); > >ERROR 2005: Unknown MySQL Server Host ''tess.DOC',' (2) > >mysql> > >----------
The \r is probably interpreted as a connect command: mysql> \? MySQL commands: Note that all text commands must be first on line and end with ';' help (\h) Display this help. ? (\?) Synonym for `help'. clear (\c) Clear command. connect (\r) Reconnect to the server. Optional arguments are db and host. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
