At 15:06 -0300 2/24/04, Tenchi Muyou wrote:
Sorry guys, i only seen i sent directly to Paul
after i sent it ... Forwarding to the list.
-------- 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
I tried copying and pasting from your original message, and didn't get
a syntax error. (I got "unknown table", which is true on my machine, and
I wouldn't have gotten that if the server wasn't able to parse the statement
correctly.)
So I'm not sure what's going on with your setup, but I'd suspect some
problem with the copy and paste operation, and perhaps also with the
file transfer. I do believe that the original statement is valid, however.
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]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
