What is update statement in MySQL with PHP
In this article I am going to explain about MySQL update statement.
MySQL Update statement with PHP
The update statement is used to change the data in one or more row of table based on condition you specify.
Syntax of update statement
SET coluumn1=value,column2=value,.......where columnName=value
In the above update statement set and where clause is used, Here in the set clause specify the value for a column as a literal or an expression, who you want for as updation. And in the where clause, you can specify the conditions that must be met for a row to be updated.
Example of update statement
$con = mysql_connect("localhost","gupta","sharad");
die('Could not connect: ' . mysql_error());
mysql_query("UPDATE Emp SET Id=108 WHERE Fname='Manish'");
You may also want to read these related articles :here
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here