Posted by Jim Michaels on 01/10/06 04:25

You probably don't have to drop the entire database, just the table. Maybe
not even that - just delete the offending record.
To delete records, DELETE FROM table WHERE colname='somevalue' AND
colname='somevalue'
the AND part is optional of course.
if you don't include the WHERE clause it will delete all the records, if I
remember correctly.
you use the ANDs to uniquely and sufficiently identify the record you want
to delete.

"S.Williams" <s.williams2005@gmail.com> wrote in message
news:vhbwf.50081$Ou3.40927@dukeread09...
> and how do i go about taking values out of a table? i accidently put some
> values in the wrong table and would like to get rid of them. also... when
> i did the 'show database' command i saw some test runs in there i did. I
> tried to drop the database and it came up w/errors. how do i do this
> again?
>
> s
>
> "S.Williams" <s.williams2005@gmail.com> wrote in message
> news:G3bwf.50035$Ou3.23734@dukeread09...
>> ok 2 questions this time..
>>
>> 1.) how do i get out of my command line client? and does it save my
>> changes if i don't exit properly?
>>
>> 2.) after inserting values into my table.. how can i look at the table
>> and the values i put in it?
>>
>> s.
>>
>>
>> "S.Williams" <s.williams2005@gmail.com> wrote in message
>> news:%jWvf.46008$Ou3.38840@dukeread09...
>>> thanx a bucnch
>>>
>>> s
>>>
>>>
>>> "mick white" <mick@mickweb.com> wrote in message
>>> news:eiVvf.75602$XC4.45794@twister.nyroc.rr.com...
>>>> S.Williams wrote:
>>>>
>>>>> i created a table and then inserted into table (a bunch, of, fields)
>>>>> -> and then when i put in the values('i forgot' , 'to put an',
>>>>> 'apostrophe on one, 1);
>>>>>
>>>>> kinda like that i guess. but anyway.. i'm stuck in the table now with
>>>>> this as my prompt:
>>>>>
>>>>> ')
>>>>>
>>>>> i cant figure out how to get back to 'mysql>' it keeps saying " ') ".
>>>>>
>>>>> anyone know why?
>>>>>
>>>>> S
>>>> Just enter a '
>>>> Then a ;
>>>> Mick
>>>
>>>
>>
>>
>
>

[Back to original message]