MySQL Update Data

by Yogesh Khanna 14-Jun-16

35 0 454

MySQL Update Data

If you want to modify the existing data in the table then,"UPDATE" statement is used for this.

Syntax :
<?php

$sql="UPDATE table_name SET field1='value', field2='value2' WHERE id=1";
$result= mysql_query($sql);
echo "Data Updated Successfully";

?>
Example:
<?php

$sql="UPDATE students SET division='First' WHERE ROLL_NO=20";
// students is table name and division is field name
$result= mysql_query($sql);
echo "Data Updated Successfully";

?

Share:

Prev Next

You May Also Like

Google Adwords Tutorial for Beginners

MySQL Insert Id Function in PHP

Bachelor of Business Administration (BBA)

LOOP in C++

Comments

Leave a Reply

PHP


PHP Introduction PHP Install PHP Syntax PHP Variables ($) PHP Echo PHP Data Types PHP Strings PHP Constants PHP Operators PHP If Else PHP Switch PHP While / For Loop PHP Functions PHP Array PHP Form Handling PHP Form Validation PHP Form Required PHP Date and Time PHP Include Function PHP File Open/Read PHP File Create/Write PHP File Uploading PHP Cookies PHP Sessions PHP Error Handling PHP Oops PHP Filters PHP Classes PHP Booleans MySQL Database MySQL Connect MySQL Create DB MySQL Create Table MySQL Insert Data MySQL Insert Id MySQL Insert Multiple MySQL Prepared MySQL Select Data MySQL Delete Data MySQL Update Data MySQL Limit Data

Hot Deals

Free Tool - SEO and SEM
All-in-one marketing toolkit for digital marketing professionals. Free Trial

View More →

News letter

Subscribe To Never Miss an Article From

Youtube Channel