Colin Shreffler <[EMAIL PROTECTED]> wrote on 11/26/2005 04:44:26 PM:
> Does anyone know how to separate queries so that I can run multiple insert > statements at once? > > For example, from within MySQL Query Browser, I want to load a file > containing multiple inserts and then run it. It errors however on trying to > run the following queries: > > insert into project_type (project_type_id, code, name) values (1, 'W', 'Web > Site'); insert into project_type (project_type_id, code, name) values (2, > 'Y', 'Interactive Application / Flash'); insert into project_type > (project_type_id, code, name) values (3, 'B', 'Brochure'); > > The seperator Œ;¹ doesn¹t seem to be enough. Is there some other command > that I need to add between queries? > > Thanks, > Colin Query Browser has two types of areas to put SQL statements into "query tab"s and "script tab"s. The area that opens by default is a "query tab" and only allows for single statements. A "script tab" allows for sequences of statements, like what you want to do. File->New Script Tab or File->Open Script DISCLAIMER: I am not defending this design, just helping you to work with it. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
