ST Alpha - "you can run it from a command line" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 159

In response to "Stupid question....for MySQL. If i have a database set up and I wish to perform a query every time I import bulk information...is there any easy way " by Will Hunting

you can run it from a command line

Posted by decline (aka Decline) Apr 22 '09, 09:34

mysql -u -p < QueryName.sql

where QueryName.sql contains all of your query session lines. Output goes to standard out.

Is that what you mean?

Responses:

Yes, that's pretty much it. Thanks. -- nm - Will Hunting Apr 22, 09:35 3
- Sounds like a perfect opportunity for a shell script to make batches of commands. -- nm - Beryllium Apr 22, 09:43 2
  - *blank stare* - Will Hunting Apr 22, 09:46 1
    - Sounds good :) -- nm - Beryllium Apr 22, 09:50

Post a message top

Replies are disabled on threads older than 7 days.