Updating mysql database with php
One of the columns in this table is called "Seniority" and it holds an integer value of how many months an employee has worked at your company.
If an update on a row would result in a violation of a primary key or unique index, the update on that row is not performed.
My SQL Forum Imagine that you have a My SQL table that holds the information of all the employees in your company.
You may be thinking that you'll have to open up your My SQL administration tool and edit each entry by hand. On the other hand, you could master My SQL and have an automated script that you run each month to get the job done for you.
In this lesson you will learn how to replace the existing data of a My SQL table with freshly supplied up-to-date data using the UPDATE My SQL query.