Thanks Phil - it's not quite a solution but it's a lead. So the following works.

TRUNCATE TABLE profiler_current.email_profiler

go

INSERT INTO

profiler_current.email_profiler( email_address)

SELECT

gc.`E-mail 2...

Yes that would be fine if I had only a handful of statements but the full script I want to run will have many statements so such an approach would...