SQL in Terminal Question

Discussion in 'Web Design and Development' started by Jas123, Jul 23, 2009.

Most Liked Posts
  1. Jas123, Jul 23, 2009

    Jas123 macrumors member

    Joined:
    Apr 1, 2008
    #1
    When type over multiple lines I get this:
    ->
    ->
    -> ect ect.

    is it possible to move to the previous line after pressing return?
     
    share
    + Quote Reply
  2. ChrisA, Jul 23, 2009

    ChrisA macrumors G4

    Joined:
    Jan 5, 2006
    Location:
    Redondo Beach, California
    #2
    What program are you using? There is a good chance the up arrow key will do what you are asking for.
     
    share
    + Quote Reply
  3. angelwatt, Jul 23, 2009

    angelwatt Moderator emeritus

    angelwatt

    Joined:
    Aug 16, 2005
    Location:
    USA
    #3
    I believe he's using MySQL from Terminal. What he's showing is when you're typing queries over multiple lines until you put in a semicolon. I think there may be a way, but not 100%, just be careful with the enter key.
     
    share
    + Quote Reply
  4. Jas123, Jul 23, 2009

    Jas123 thread starter macrumors member

    Joined:
    Apr 1, 2008
    #4
    Thanks for the reply guys. Yes this is what I am talking about. I often find that after typing out long tedious queries, i'll have an error on a couple lines before and will have to retype the whole thing out again. So I was just wondering if there was any shortcut for this.
     
    share
    + Quote Reply
  5. trule, Jul 24, 2009

    trule macrumors 6502

    Joined:
    Mar 16, 2007
    #5
    type your queries up in a text editor and copy paste them across.

    or type them in a file and run the file from mysql
    mysql > SOURCE somefile;

    or use a GUI/Web front end...
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page