Home Yellow Pages Movies Classifieds Jokes Jobs Free Hosting Videos

MySQL Update

Update Data In a Database

The UPDATE statement is used to modify data in a database table.


UPDATE table_name SET column_name = new_value WHERE column_name = some_value

Note: SQL statements are not case sensitive. UPDATE is the same as update. To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.


Earlier in the tutorial we created a table named "Person". Here is how it looks:

First Name Last Name Age
Nancy Varghese 33
Bill Gates 35

The following example updates some data in the "Person" table:

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
die('Could not connect: ' . mysql_error());
mysql_select_db("my_db", $con);
mysql_query("UPDATE Person SET Age = '36' WHERE FirstName = 'Bill' AND LastName = 'Gates'");

After the update, the "Person" table will look like this:

First Name Last Name Age
Bill Gates 36
Nancy Varghese 33

Back to Home
BizHat.com   Bookmark   Astrology   Chat Room   Classifieds   Computer   Downloads   Directory   Dating   Domain Tools   Education   eCards   Finance   Forums   Freelance Work   Free Hosting   Free Mail   Gallery   Games   Guest Book   Greeting Cards   Ham Radio   Health   Home Business   Hosting Tutorials   Hosting Directory   India   Jobs   Jokes   Kerala   Matrimonial   Music   Movies   News   News Letter   Recipes   Real Estate   Search   SMS   Tourist Guide   Top 100 Sites   Vote Us   Yellow Pages   Arthunkal Church   Site Map