/    Sign up×
Community /Pin to ProfileBookmark

running multiple mysql queries

Copy linkTweet thisAlerts:
Jun 01.2003

Okay, I have a file (queries.txt) and on each line, there is a query.
I want to know how to run they all, one after the other, without having to key in each query.
There are 18 queries and at least 1800 characters, 100 characters per query, and I don’t fancy typing each out

to post a comment
Full-stack Developer

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@khalidali63Jun 01.2003 — Interesting...

I know in the Oracle,

Save the text file as queries.sql

then you open up the SQL Plus

and write this

@queries.sql

It will run the file and it will run all of the queries one after the another.

I have no Idea how would it work in other,you can try though,since the main parts of SQL syntax are common amongst all apps..
Copy linkTweet thisAlerts:
@viciousauthorJun 02.2003 — thanks, but it doesn't work
×

Success!

Help @vicious spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.1,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,
)...