faqts : Computers : Databases : MySQL : Shell Commands : mysql

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

38 of 44 people (86%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

I'm typing a multi-line sql statement, how can I go back to correct errors?
Does MySQL have a command line history?

Jun 23rd, 2000 17:55
Philip Olson, Nathan Wallace, Tim Smith


If you're in Windows, use the 'mysqlc' program instead of 'mysql'. Then
you can use arrow keys.  
In Unix, you can use arrow keys with 'mysql'  Check your user directory 
for a file called .mysql_history
Also, you can use the \e command to edit the previous statement.