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