-------- Original Message --------
Subject: Re: Inserting values with ";". How?
Date: Tue, 24 Feb 2004 15:05:59 -0300
From: Tenchi Muyou <[EMAIL PROTECTED]>
To: Paul DuBois <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
Well... I'm trying to setup the new db on tripod/lycos UK. Im trying both uploading the .sql file and running it, and cutting & pasting the code into the server.... both says:
Error
SQL-query : [Edit]
INSERT INTO `phpbb_posts_text` (`post_id`, `bbcode_uid`, `post_subject`, `post_text`) VALUES (6, '33f8793c3d', 'Sejam todos bem vindos!!!!', 'É isso ae povo!\r\n\r\nEstamos numa casa nova ^_____~\r\n\r\nDesejo a todos um bom re-começo XD~\r\n\r\nQualquer dúvida, é só contatar algum administrador!!!\r\n\r\nBjokas e divirtam-se!!!!'), (* cutted for easier reading*) (35, '90a8725459', '', 'Nhoiiiiii\r\n\r\nseja bem vindo!\r\n\r\neu tb sou do CB XD~\r\n\r\naproveite bastante aki ^^\r\n\r\nbjokas'), (36, 'dd4ff5164a', '', 'E eu tb ^_^\r\n\r\nSeja bem vindo XDD'), (37, '72f05c5c1f', '', 'Serve Blog: O-o
MySQL said:
You have an error in your SQL syntax near ''Serve Blog: O-o' at line 32
Paul DuBois wrote: > At 14:30 -0300 2/24/04, Tenchi Muyou wrote: > >> Hello there guys, >> >> I needed to transfer my db from one MySql server to another, and >> exported the table in a .sql file. The problem is that when i try to >> import it gives an error. Here is the code that is giving the error: >> >> INSERT INTO `phpbb_posts_text` (`post_id`, `bbcode_uid`, >> `post_subject`, `post_text`) VALUES (37, '72f05c5c1f', '', 'Serve >> Blog: O-o;;\r\nTá desatualizado, mas peguem o endereço na sain >> XDD\r\n\r\npra quem é preguicoso >> \r\n\r\n[url=http://protection.dydnds.org]Protection Project[/url]'); >> >> How can I escape this ;; from the message? I tried \; but it wont >> work. Searched the documentation and couldnt find anything that could >> help. Any ideias? > > > You omitted some important information: > > 1) What method are you using to import the file? > 2) What was the exact error message? >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
