Total Page Preview:   000000000621

What is SQL insert statement in English and Hindi

 

SQL insert statement in English

SQL INSERT statement is a query language statement used to insert one or more new rows of data into a table in a database. The INSERT statement specifies the table name and the values for one or more columns of the table. 

let me explain the SQL INSERT statement with a detailed example in tabular form.

Consider a table named "employees" with the following columns:

 
We want to add a new employee to this table using the INSERT statement. Here's an example of the INSERT statement:
In this example, the INSERT statement adds a new record with the following values to the "employees" table:
 
Note that the column names and their corresponding values in the INSERT statement must match the column names and their data types in the table definition. Also, if the table has an auto-incrementing column, you can omit the column name and its corresponding value from the INSERT statement.
 
Here's another example where we want to add multiple employees to the "employees" table using a single INSERT statement:
 
In this example, the INSERT statement adds three new records to the "employees" table with the specified values:
Note that each record is separated by a comma and enclosed in parentheses.
Overall, the SQL INSERT statement is a powerful tool to add new records to a database table quickly and easily.
 
 
 
 
SQL insert statement in Hindi
SQL INSERT statement ek command hai jo table mein naye records insert karne ke liye use ki jati hai. Yeh statement ek database management system mein data add karna aasan banati hai.
Yaha ek tabular example diya gaya hai jisme hum INSERT statement ka use karte hue ek naya record add karenge:
Consider a table named "students" with the following columns:
 
Ab hum INSERT statement ka use karke is table mein ek naya record add karenge:
Is example mein, INSERT statement "students" table mein ek naya record add karegi jiska is tarah se data hoga:
 
Note kare ki INSERT statement mein column names aur values ke beech kehne wale parentheses ka use kiya jata hai. Yeh record ke sabhi fields ko ek sath add karta hai.
Agar hum INSERT statement ka use karke ek se jyada record add karna chahte hain to hum ise is tarah se kar sakte hain:
 
Is example mein, INSERT statement "students" table mein teen naye record add karegi jinka data is tarah se hoga:
Is tarah hum INSERT statement ka use karke table mein naye records add kar sakte hain.
 

 

 

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments


                           
                           

                           

                           

Facebook User: