Leveling up your mind

Notifications
Clear all

Insert

 
Sohaib
(@sohaib-ops)
Member Admin

The INSERT statement inserts a new row into a table. You can use the INSERT statement when you want to add new records. The statement below enters a record for Justin Bieber into the celebs table.

INSERT INTO celebs (id, name, age)
VALUES (1, 'Justin Bieber', 22);

Quote
Topic starter Posted : 03/02/2020 4:15 pm
Sohaib
(@sohaib-ops)
Member Admin

1. INSERT INTO is a clause that adds the specified row or rows.

2. celebs is the name of the table the row is added to.

3. (id, name, age) is a parameter identifying the columns that data will be inserted into.

4. VALUES is a clause that indicates the data being inserted.
(1, 'Justin Bieber', 22) is a parameter identifying the values being inserted.

1 is an integer that will be inserted into the id column

'Justin Bieber' is text that will be inserted into the name column

22 is an integer that will be inserted into the age column

ReplyQuote
Topic starter Posted : 03/02/2020 4:18 pm
laisabeck
(@laisabeck)
New Member

Is insert like "Create" in CRUD?

There is a Cyber Security certified course I saw on Blockchain Council online education platform. They are offering a good discount these days on Blockchain Council Coupons. So I'm thinking about it before it's too late.

ReplyQuote
Posted : 07/04/2021 10:24 am