hi,
I had installed mysql 4.0 in win 2000.
I used Command Prompt to connect to mysql and do all the sql query there.
It is often/normal that we can make mistake in the typing.
When i encounter this typing error,the mysql just like 'hang' it there.
In order to solve this,the only way i know is press "Ctrl + c" key to
abort,and re-connect again.
But is there any other method instead of pressing "Ctrl+c" key?

Below is the example output:

mysql> desc mytable;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| aaa   | varchar(20) | YES  |     | NULL    |       |
| bbb   | varchar(20) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> select * from mytable;
Empty set (0.00 sec)

mysql> select * from mytable'   ( I key in ' instead of ; )
    '>
    '> ?
    '> what the key should i use to reset this?
    '>
    '>
    '>
    '>
    '>


Thank You



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to