SELECT Syntax. SELECT column1, column2, ... FROM table_name;. Here,
column1, column2, ... are the field names of the table you want to select data from
. If you want to select all the fields available in the table, use the following syntax:.
What is a NULL Value? A field with a NULL value is a field with no value. If a field
in a table is optional, it is possible to insert a new record or update a record
without adding a value to this field. Then, the field will be saved with a NULL
Example. UPDATE Customers SET ContactName = 'Alfred Schmidt', City= '
Frankfurt' WHERE CustomerID = 1;. Try it Yourself ». The following SQL will
update the "ContactName" field to "Juan" for all records where Country is "Mexico