Intro To Basic SQL Commands

SQL, or Structured Query Language, is a language used in programming to manage data held in a relational database management system. To query data is to request data from a table or combination of tables. SQL has a lot of capabilities.

www.w3schools.com

There are many different versions of the SQL language, but each version must support these major commands

• INSERT
• SELECT
• WHERE
• UPDATE
• DELETE

Today, we will go over all of these commands

INSERT

Insert is used to place new rows inside of a table. There are 2 ways to write an insert statement.

Insert adding values without specifying columns

If you are going to add values for every column in a table you simply follow the example below and do not need to specify the columns in your statement. It is important though, that you write your values in the correct order as they exist in the table based on the columns.

INSERT INTO TABLE_NAME
VALUES (value1,value2,value3,value4);