Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    4

    Unanswered: Read queries form a text file?

    Hi,

    Im creating a database in MySQL and i wanted to read the create statements from a text file. Is anyone aware of how this can be done.

    Thanks,

    Rich

  2. #2
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161
    You can use command line mysql < mytextfile.txt to read all SQL queries in the text file.
    Or use phpMyAdmin

  3. #3
    Join Date
    Jan 2006
    Posts
    10
    In mysql> command prompt you can execute either
    source FILENAME
    or
    \. FILENAME
    in order to execute all text in FILENAME as SQL statements.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •