SQL in Terminal Question

[Jas123]

When type over multiple lines I get this:
->
->
-> ect ect.

is it possible to move to the previous line after pressing return?

 

[ChrisA]

When type over multiple lines I get this:
->
->
-> ect ect.

is it possible to move to the previous line after pressing return?

What program are you using? There is a good chance the up arrow key will do what you are asking for.

 

[angelwatt]

What program are you using? There is a good chance the up arrow key will do what you are asking for.

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.

 

[Jas123]

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.

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.

 

[trule]

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...