Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Oct 2008
    Location
    S.F., CA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to Export Results of a SQL querie?

    I am trying to export the results of a querie

    Code:
     SELECT * FROM table a, table b WHERE a.column = b.column;
    and when I use

    Code:
    load data outfile 'C:/Users/Name/Documents/file.txt'
    I recieve an error that says my MySQL syntax is wrong.

    "You have an error in your SQL syntax...for the right syntax to use near 'outfile 'C:/Use..."

    I don't know what I'm doing wrong but it should be a simple export command.

  • #2
    New to the CF scene
    Join Date
    Oct 2008
    Location
    S.F., CA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    NEVER MIND I RESOLVED THIS ISSUE> BAD SYNTAX

    Code:
    SELECT ... INTO OUTFILE 'file_name';


  •  

    Tags for this Thread

    Posting Permissions

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