how to edit a row
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.
Subject
Written By
Posted
how to edit a row
June 16, 2005 06:38PM
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.