Page 1 of 1
How do I edit a single row of a column in a database?
Posted: Tue Apr 08, 2008 8:41 pm
by xenoalien
How do I edit a single row of a column in a database? In some sense, I would like to be about to change or replace a cell within a database table. How would I do this? I understand how to INSERT and get data from a database table but I do not know how to replace.
Re: How do I edit a single row of a column in a database?
Posted: Tue Apr 08, 2008 8:59 pm
by flying_circus
The SQL command is UPDATE
UPDATE myTable SET myValue='updatedValue' WHERE myColId = 'myId';
Re: How do I edit a single row of a column in a database?
Posted: Tue Apr 08, 2008 9:03 pm
by xenoalien
Thanks man! I am trying to make a submission form and database for my school for track and field sports. For other school to submit their participants for events and meets.