Subscriber only lesson.
Sign up to this course to view this lesson.
Insert allows us to put data INTO our table.
When to use
Use it any time you want to add data to your table with SQL.
INSERT INTO [dbo].[Current_Customers] ([First Name], [Last Name], [Email Address], [Phone Number], [Age], [City], [Country])
VALUES ('Tracy', 'Smitherton', 'firstname.lastname@example.org', '222-667-8645', '42', 'Mt. Vernon', 'USA')
This will insert the information for a new customer into the current customer database.
Hints & tips
- Insert puts data into your table using SQL
- The columns in the first line need to mirror the data in the second line
Lesson notes are only available for subscribers.