MySQL Forums
Forum List  »  Microsoft SQL Server

can i give multiple queries in the same window and execute them?
Posted by: Arshad Muhammed
Date: August 19, 2008 09:30AM

hai guys,
i want to know whether i can give mulitple queries in the same window and execute them, like i do in micorsoft sql server.
for example::

create table manufact(
	manu_code varchar(5),
	manu_name varchar(10),
	lead_time integer,
	primary key (manu_code));

insert into manufact values ('SMT', 'Smith', 3);
insert into manufact values ('ANZ', 'Anza', 5);
insert into manufact values ('NRG', 'Norge', 7);
insert into manufact values ('HSK', 'Husky', 5);
insert into manufact values ('HRO', 'Hero', 4);
insert into manufact values ('SHM', 'Shimara', 30);
insert into manufact values ('PQR', 'peoples', 8);

if i copy paste this and execute. it wont be executed. rather if i execute each query seperately it runs.
it takes too much time to execute individually. please help me.

btw. are the commands in microsoft sql server and mysql same??


thanks in advance. :)

Options: ReplyQuote


Subject
Written By
Posted
can i give multiple queries in the same window and execute them?
August 19, 2008 09:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.