Skip navigation links

MySQL Forums :: Newbie :: how to edit a row


Advanced Search

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 Bradley Kjeldsen 06/16/2005 06:38PM
Re: how to edit a row John Winter 06/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.