How to escape a statement

[gschrade]

I am new to mysql. I am trying to escape out of an interactive statement. I started a statement like so: CREATE TABLE sometable (
> firstcolumn char(30) not null,
> secondcolumn char(20) not null'
'>

As you can see after the second column I entered a ' instead of a , so I want to escape or abort the statement. No matter what I enter I get another '> prompt. How do I get out???

Thanks in advance

 

[sleipnir214]

enter a semicolon.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[gschrade]

That was the first thing I tried. That did not work. Then I tried a closeing ); and that did not work...

 

[sleipnir214]

okay, then try a singlequote, then a semicolon.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[gschrade]

That did the trick! Thank you