MySQL Forums
Forum List  »  Newbie

how to edit a row
Posted by: Bradley Kjeldsen
Date: June 16, 2005 06:38PM

Hey everyone hows it going!

I've just started to learn mySQL, I downloaded 4.1 the other day.
Anyway, I've started creating new tables; and rows; but I want to know, once I enter some data in the table, how do I edit it?

mysql> insert into empinfo(first,
-> last,
-> id,
-> age,
-> city,
-> state)
-> values('Mary Ann',
-> 'Edwards',
-> '88232',
-> '32',
-> 'San Diego',
-> 'California'
-> );
Query OK, 1 row affected (0.00 sec)
+----------+---------+-------+------+-----------+------------+
| first | last | id | age | city | state |
+----------+---------+-------+------+-----------+------------+
| Mary Ann | Edwards | 88232 | 32 | San Diego | California |
+----------+---------+-------+------+-----------+------------+

I want to be able to edit the above record. (In particular the *city* field) Would someone be able to help me? I know i'm only a newbie, but yeh... i'm trying heh.

Options: ReplyQuote


Subject
Written By
Posted
how to edit a row
June 16, 2005 06:38PM
June 16, 2005 08:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.