Show menu

SQL INSERT INTO Statement


Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!


Added by
97 Views
SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.



INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

or

INSERT INTO table_name
VALUES (value1, value2, value3, ...);


INSERT INTO Customers (CustomerName, City, Country)
VALUES ('Cardinal', 'Stavanger', 'Norway');


use northwind;

SELECT
*
FROM
Customers;


insert into Customers (first_name, last_name, email, city) value
("parsa", "nemati" , "alinemati1983@gmail.com" , "Milwaukee");


if you want to have added multiple records.
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...), (value1, value2, value3, ...)
(value1, value2, value3, ...), (value1, value2, value3, ...), (value1, value2, value3, ...);




-------------------------------------------
Follow my at socail Media:
Linkedin: https://www.linkedin.com/in/ali-nemati
Instagram: https://www.instagram.com/
Facebook: https://www.facebook.com/artificialintelligenceml
-------------------------------------------
Hello~ Everyone
Thank you for watching my videos.
If you enjoy my videos, you may share, like and subscribe to my channel to see more video.
Your like, comment and subscribe...support and encourages me to create more content. Thank you ^_^

Donate:
you can donate to support me as well, all Donation no matter how small will be gratefully accepted.
“You can donate by clicking here.”
PayPal: https://www.paypal.me/alinemati45
-------------------------------------------
Category
STAVANGER
Commenting disabled.