Updating dataset to database
The general form of the UPDATE statement is If the master data set contains an observation that does not correspond to an observation in the transaction data set, the DATA step writes that observation to the new data set without modification.An observation from the transaction data set that does not correspond to any observation in the master data set becomes the basis for a new observation.To update a record in any table it is required to locate that record by using a conditional clause.Below example uses primary key to match a record in employee table.For more information on setting up a database for data entry, see Design considerations for updating data. Data entry forms can provide an easier, faster, and more accurate way to enter data.
Datasheets are grids of data that look like Excel worksheets.
You can change data in tables, query result sets, and forms that display datasheets.
Typically, you use datasheets when you need to see many records at once.
The new observation may be modified by other observations from the transaction data set before it is written to the new data set.
Bind variables are placeholders inside a SQL statement.
Search for updating dataset to database:
Data can be updated into My SQL tables by executing SQL UPDATE statement through PHP function mysql_query.