sequelpro - Error executing MySQL code -

i using sequel pro , mysql. when execute each line individually no errors generated , code works expected. when try execute lines error below.

delimiter $$  create temporary table pricesoutput (price float, namex varchar(255), updatedat datetime);  insert pricesoutput select 9.99, 'bosch zxy', '12/05/12';  select * pricesoutput;  drop table pricesoutput;  end$$  delimiter; 

[error in query 1] have error in sql syntax; check manual corresponds mysql server version right syntax use near 'insert pricesoutput select 9.99, 'bosch zxy', '12/05/12';

select * pr' @ line 3 

[error in query 2] have error in sql syntax; check manual corresponds mysql server version right syntax use near 'delimiter;' @ line 1

the delimiter $$ line changes delimiter ; $$, each line needs terminating $$ instead. end used defining procedures not required & final delimiter; should have space before semi-colon.

delimiter $$ create temporary table pricesoutput (price float, namex varchar(255), updatedat datetime)$$ insert pricesoutput select 9.99, 'bosch zxy', '12/05/12'$$ select * pricesoutput$$ drop table pricesoutput$$ delimiter ;