Insert data in sql table


Insert data in SQL table :- For inserting data into a table INSERT INTO statement is used to insert single or multiple records in a table.
There are two ways to insert data in a table:-
  1. By specifying column names
  2. Without specifying column names
By specifying column names:- The first way to describe both column names and values to be inserted.

Syntax:-

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

Without specifying column names:- If we want to add values for all the columns of the table, we don't need to specifying column names in the query.

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

Example:- 
The following statements would create six records in the "student" table:-

INSERT INTO student (studentID,Name,Email,Age,city,fees)
VALUES (1, 'Marry', 'mary@gmail.com', 20, 'Delhi', 20000);

INSERT INTO student (studentID,Name,Email,Age,city,fees)
VALUES (1, 'John', 'john@gmail.com', 18, 'Lucknow', 15000);

INSERT INTO student (studentID,Name,Email,Age,city,fees)
VALUES (1, 'Kia', 'Kia@gmail.com', 22, 'Faridabad', 17000);

INSERT INTO student (studentID,Name,Email,Age,city,fees)
VALUES (1, 'Tina', 'Tina@gmail.com', 24, 'Agra', 16000);

INSERT INTO student (studentID,Name,Email,Age,city,fees)
VALUES (1, 'Tad', 'Tad@gmail.com', 22, 'Delhi', 20000);

INSERT INTO student (studentID,Name,Email,Age,city,fees)
VALUES (1, 'Riya', 'Riya@gmail.com', 25, 'Agra', 25000);

OUTPUT:-


You can create a record in the student table by using the second syntax as shown below:-
Example:-

INSERT INTO student
VALUES (7, 'Rahul', 'Rahul@gmail.com',24, 'lucknow', 18000);

OUTPUT:-


Insert data into the specified column:- You can insert data into a specified column by using following SQL statement.

Consider the above table. In this table, we will insert data into Name , Age and fees.
Syntax:-

INSERT INTO student (Name, Age, fees)
VALUES ('Aakash' , 20 , 15000);

Output:-



Comments

Post a Comment

Popular posts from this blog

ASP.NET Overview

ASP.NET CORE:- The ASP.NET Core is a brand new cross-platform, high-performance, light-weight, open-source Framework which is used for developing modern, Internet-connected, cloud-based Web Applications, IoT, and Web APIs which can be developed and run on Windows, Linux, or Mac operating systems. ASP.NET Core Framework is completely rewritten of existing ASP.NET 4.x, with architectural changes which make it more modular, scalable, open-source, high-performance, light-weight, and a cross-platform web framework.    ASP.NET Core benefits and features: Nowadays, the ASP.NET Core the framework becomes more and more popular among the developers for several reasons. Let us discuss the benefits and features provided by this framework in detail. ·      Open Source:- The ASP.NET Core framework is Open Source. The Source Code of this Framework is available at   https://github.com/aspnet  and you are free to download the source code and even if you want ...
Read more

SQL AND ,OR, NOT Operators

Image
SQL AND, OR, NOT  OPERATOR:-  The WHERE clause can be combined with AND, OR, NOT Operators. These operators are used to filter records based on more than one condition. SQL AND OPERATOR:- The AND operator displays a record if all the conditions separated by AND are TRUE. SYNTAX:- SELECT column1 ,column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ... ; EXAMPLE:- Consider the CUSTOMERS table having the following records:- AND Example:- The following SQL statement selects all fields from "CUSTOMERS" where Address is "Delhi" AND Age is "23 ":-  SELECT CustomerID , Name ,Address , Age ,Salary   FROM CUSTOMERS  WHERE Address = 'Delhi' AND Age = 23 ; OUTPUT:- SQL OR OPERATOR:- The SQL OR Operator is used to create a SQL statement where records are returned when any one of the conditions met. Syntax:- SELECT column1 ,column2, ... FROM table_name WHERE condition1 OR condition2 OR condition3 ... ; EXAMPLE:- The followin...
Read more

SQL Joins

SQL JOINS:-  JOIN means to combine something. In case of SQL join clause is used to combine rows from two or more table, based on a related column between them. IMPORTANCE OF JOIN:- If you want to combine two or more table the SQL JOIN is used. If you want to access more than one table through a SELECT statement. The joining of two or more tables is based on common filed between them. TYPES OF JOIN:- INNER JOIN:- INNER JOIN returns records that have matching values in both the table. LEFT(OUTER) JOIN:- This join returns all records from the left table , and the matched record from the right table. RIGHT(OUTER) JOIN:- This join returns all records from the right table, and the matched records from the left table. FULL(OUTER) JOIN:- This join returns all records when there is s match in either left or the right table.
Read more