|
|
Posted by S.Williams on 01/12/06 07:23
thanx a ton! i really do appreciate all your guys' help.
s
"Jim Michaels" <jmichae3@yahoo.com> wrote in message
news:EuGdnVcNBJG6hl7eRVn-iQ@comcast.com...
> 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]
|