| Previous | Home | Next |
In MySQl create a table and insert the data. If any condition the some data are update in this table then using query update in MySQL like as a example for in the MySQl database table that holds the information of all the employees in any company. Then if one table hold information for senior employees to how many days his work in company. So obviously for you, your job is to update these numbers every month.
Then after in a table you'll have to open up your MySQL administration tool and edit each entry by hand. That would take hours. On the other hand, you could master MySQL and have an automated script that you run each month to get the job done for you.
In this chapter we learned at how to replace the existing data of a MySQL table with freshly supplied up-to-date data using the UPDATE MySQL query.
Example:
Amita has just had a birthday and she now 22 years old. Our job now is to update her age using MySQL commands like UPDATE, SET, and WHERE.
- UPDATE - Performs an update MySQL query
- SET - The new values to be placed into the table follow SET
- WHERE - Limits which rows are affected
PHP & MySQL Code:
<?php
// Connect to MySQL
// Get Amit's record from the "example" table
$result = mysql_query("UPDATE example SET age='22' WHERE age='21'")
or die(mysql_error());
$result = mysql_query("SELECT * FROM example WHERE age='22'")
or die(mysql_error());
// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
echo $row['name']." - ".$row['age']. "<br />";
?>
Output
Now it is important to note that this query would have updated ALL records that had an age of 21 to the new age of 22. In a table where Sandy is not the only entry, this may become a problem, and a more sophisticated solution would be necessary.
| Previous | Home | Next |