November 12th, 2000, 09:45 PM
hello ! i want to ask a silly question
suppose i type in mysql prompt
>select * from people
>where name="abc";<enter> <---------however , i type it wrongly , it should be "def"
so what can i do to modify my input statement ??
November 12th, 2000, 11:00 PM
November 12th, 2000, 11:05 PM
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by manderson:
retype it [/quote]
but the previous statement will affect my search result ...
is it the only solution is to type it again ?
November 13th, 2000, 12:28 AM
You'll get a whole new result with any row where name="def". The previous select command has nothing to do with it...