sql add statement code example

Example 1: sql add

Adds a new column to an existing table.
Example: Adds a new column named ‘email_address’ to a table named
‘users’.
ALTER TABLE users
ADD email_address varchar(255);

Example 2: sql add statement access

INSERT INTO tblProducts (ProductName,
   CategoryDescription, UnitPrice)
VALUES ('Support Renewal', 'Multi-User', 99);