Page 201 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Example (MySQLi Object-oriented):

Update Data In a MySQL Table Using MySQLi
The UPDATE statement is used to update existing records in a table:

Notice the WHERE clause in the UPDATE syntax: The WHERE clause specifies which record or records that
should be updated. If you omit the WHERE clause, all records will be updated!
The following examples update the record with id=2 in the “MyGuests” table:

Example (MySQLi Object-oriented):
Delete Data From a MySQL Table Using MySQLi

188

CITS : IT&ITES - Computer Software Application - Lesson 47 - 62