Easy question

[[email protected]]

I am new to MySQL, but have a question that has caused me a problem more than once.

 

When using the command line client and having typed in the info for a create table (say 20 fields) hitting enter after every field, and I cause a syntax error is there any way to just recall all of the information while fixing the syntax error or do I have to enter everything again?

 

Thanks for any help.

[lead2gold]

you should pre-type your command in a file,

you can then execute your statement that way.  If there is a problem, you simply just edit your file.

 

ie:

$> echo "SELECT * FROM mytable;" >cmd.sql

 

Then from your command prompt:

$> sql -u <username> -p < cmd.sql

 

but to answer your question: you are correct in thinking there is no other way to recall the last information you typed.

 

[wsantos]

another solution would be to press the Up arrow