How To Insert Data Into a Table in SQL
Channel: Data Analytics Ireland
Date: 2021-03-09

Are you looking to learn How To Insert data into a table in SQL? Here we discuss the use of the INSERT statement into one row or multiple rows. Also, we show how to insert values when using a primary key, and how it is not possible if you leave out a primary key. Finally, we will take you through trying to insert a value that is a duplicate on a primary key column, and already exists.

⏲⏲⏲TIMESTAMPS⏲⏲⏲
Beginning 00:00
Insert a single row 00:20
Insert multiple rows 04:15
Insert into one column 06:21
Insert without a primary key ( why it can't be done) 07:43

Link to code: https://dataanalyticsireland.ie/2021/03/09/how-to-insert-data-into-a-table-in-sql/

################     Lets be Social!    ##################

 Website - https://dataanalyticsireland.ie/
 Twitter - https://twitter.com/dataanalyticsi1
 Facebook - https://www.facebook.com/dataanalyticsirl
 Linkedin - https://www.linkedin.com/company/data-analytics-ireland
 Pinterest - https://www.pinterest.ie/dataanalyticsireland/

#SQL #insertdata #dataanalyticsireland