MySQL Update Data

by Yogesh Khanna 14-Jun-16

0 812


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

MySQL Insert Id Function in PHP

PHP Syntax

PHP Constant

MySQL Delete Query

Discount Coupons

SEMRush FREE Trial – PRO Account for 14 Days

FREE Pro Account worth $99.95 for 14 Days.
Activate FREE Account


Comments

    Waiting for your 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