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

Reply via email to