The problem is that you are trying to run a script (several commands at the same time) on
a client tool that doesn't support it. Either run the script on a tool that can handle
scripts or use ONE command as sinisa suggests. The command would be like
INSERT INTO MasterEventsUpdate VALUES (90051417,90000123,150502,'UCLA Bruins
vs. Arizona ','Women\'s College
Basketball.','','2000-02-19','1899-12-30',0,'','','','','2000-01-24','')
VALUES (90051418,90000052,150600,'Spring Livestock
Show','','','2000-02-09','',0,'','','','','2000-01-24','')
Regards
Jose Ostos
----------
De: sinisa@stripped[SMTP:sinisa@stripped]
Enviado: Miércoles 8 de Marzo de 2000 6:41 AM
Para: S. R.; win32@stripped
Asunto: Re: Multiple Inserts
On Wed, 08 Mar 2000, S. R. wrote:
>Actually I did have the "values" keyword in there.. I mistyped.. Here is
>what some of my sql looks like:
>
>INSERT INTO MasterEventsUpdate VALUES (90051417,90000123,150502,'UCLA Bruins
>vs. Arizona ','Women\'s College
>Basketball.','','2000-02-19','1899-12-30',0,'','','','','2000-01-24','');
>INSERT INTO MasterEventsUpdate VALUES (90051418,90000052,150600,'Spring
>Livestock Show','','','2000-02-09','',0,'','','','','2000-01-24','');
>INSERT INTO MasterEventsUpdate VALUES
>(90051419,90000052,150600,'KVHW','','','2000-02-10','',0,'','','','','2000-0
>1-24','');
>INSERT INTO MasterEventsUpdate VALUES (90051420,90000052,150600,'Ohio
>Players','','','2000-02-11','',0,'','','','','2000-01-24','');
>INSERT INTO MasterEventsUpdate VALUES
>(90051421,90000052,150600,'Anthrax','','','2000-02-12','',0,'','','','','200
>0-01-24','');
>INSERT INTO MasterEventsUpdate VALUES (90051422,90000052,150600,'Fu
>Manchu','Songs about pinball, cars and strange
>people.','','2000-02-12','',0,'','','','','2000-01-24','');
>INSERT INTO MasterEventsUpdate VALUES (90051423,90000052,150600,'George
>Thorogood','','','2000-02-18','',0,'','','','','2000-01-24','');
>
>Here is the error I get when I try to execute this:
>You have an error in your SQL syntax near ';
>INSERT INTO MasterEventsUpdate VALUES (90051418,90000052,150600,'Spring
>Lives' at line 1
HI!
YOu get that error, because all char and char derived attributes in MySQL
should be quoted.
Also, if you want to insert several rows, run a single INSERT command for all
of them.
It is much more efficient.
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread1737@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@stripped instead.
