Jump to content


Photo

Executing commands in txt file in mysql shell [n00b]


  • Please log in to reply
1 reply to this topic

#1 chriss

chriss
  • Members
  • PipPip
  • Member
  • 10 posts
  • LocationZG, Poland

Posted 30 July 2003 - 01:40 PM

Is there a possibility to execute commands in txt file? Where should I put this file (working on SunOS 5.8 with no admin priviliges) and what command shall I execute?

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 31 July 2003 - 01:46 AM

put the sql in any file you want then run

mysql database_name < filename

http://www.mysql.com/doc/en/mysql.html
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users