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
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
thanx a bucnch
s
"mick white"
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
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"
news:%jWvf.46008$Ou3.38840@dukeread09...
> thanx a bucnch
>
> s
>
>
> "mick white"
> 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
>
>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
S.Williams wrote:
> 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?
Something like exit or quit should work and yes your changes are saved as long
as you don't use transactions, since you have to commit them.
>
> 2.) after inserting values into my table.. how can i look at the table and
> the values i put in it?
SELECT * FROM table
And I suggest a book or at least a good tutorial in SQL first.
Regards
Stefan
>...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1rc2 (MingW32)
iD8DBQFDwUCMyeCLzp/JKjARAhrDAKCpc9GDh5ljz026cVSCsVodRVUBZACe KMp3
HjQbFmwB/T8Guo2D68WdJOM=
=73iY
-----END PGP SIGNATURE-----
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"
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"
> news:%jWvf.46008$Ou3.38840@dukeread09...
>> thanx a bucnch
>>
>> s
>>
>>
>> "mick white"
>> 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
>>
>>
>
>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
S.Williams wrote:
> 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?
>
Again, first complete a SQL tutorial and maybe a database one as well. You could
even start with the mysql manual at http://dev.mysql.com/
Regards
Stefan
PS: by accident the command for deleting entries is DELETE FROM table WHERE ....
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1rc2 (MingW32)
iD8DBQFDwUGUyeCLzp/JKjARAiA2AKClu7Zex8tVs5eBgKIooiTMtsXnFwCg sBSx
TQqxA9FrzB/XN70mxC47T1Q=
=aTKu
-----END PGP SIGNATURE-----
cant find said 'tutorial' but found reference guides at the site.. is that
what you are reffering to?
"S.Williams"
news:39Vvf.45729$Ou3.33611@dukeread09...
>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
>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
S.Williams wrote:
> cant find said 'tutorial' but found reference guides at the site.. is that
> what you are reffering to?
>
yes, as I wrote. The manuals of mysql.
Regards
Stefan
>...
>>
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1rc2 (MingW32)
iD8DBQFDwVwRyeCLzp/JKjARAuDBAJ9iyqcrRUDiPdl9e1+YQWF0MAbMmwCe Osjy
Xe/xhZvrBcs1UnP4Lmmx79E=
=StHn
-----END PGP SIGNATURE-----
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"
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"
> 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"
>> news:%jWvf.46008$Ou3.38840@dukeread09...
>>> thanx a bucnch
>>>
>>> s
>>>
>>>
>>> "mick white"
>>> 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
>>>
>>>
>>
>>
>
>
thanx a ton! i really do appreciate all your guys' help.
s
"Jim Michaels"
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"
> 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"
>> 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"
>>> news:%jWvf.46008$Ou3.38840@dukeread09...
>>>> thanx a bucnch
>>>>
>>>> s
>>>>
>>>>
>>>> "mick white"
>>>> 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
>>>>
>>>>
>>>
>>>
>>
>>
>
>