INSERT INTO <table> (<field1>,<field2>,...,<fieldn>) VALUES (<value1>,<value2>,...,<valuen>)
Example: INSERT INTO Pets (PetsName, Type, Age, Owner) VALUES ('Sparky', 'Dog', 5, '3')
If a value is for a text data-type then it must be surrounded by single quotes(') and if the value is for a date/time data type it must be surrounded by hashes (#).
Note that the fields do not have to appear in the same order as the fields in the database. However, the values must be in the same order as the fields.
DELETE FROM <table> WHERE <condition>
Example: DELETE FROM Pets WHERE ID = 1
It is generally a good idea to use a field which will uniquely identify the row you wish to delete. In most cases this is the row id.
UPDATE <table> SET <field1> = <value1>,<field2> = <value2>,...,<fieldn> = <valuen> WHERE <condition>
Example: UPDATE Pets SET Age = 3, PetsName = 'Vlad' WHERE ID = 1
If a value is for a text data-type then it must be surrounded by single quotes(') and if the value is for a date/time data type it must be surrounded by hashes (#).
It is generally a good idea to use a field which will uniquely identify the row you wish to update. In most cases this is the row id.