Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 1)
1.
You can add a row using SQL in a database with which of the following?
Discussion:
44 comments Page 3 of 5.
Haddad said:
10 years ago
The "insert" is the only keyword to add rows into table
insert into ( table_name ) values ( 'value1' , 'value2' , ...);
If the value is number don't put the quotes .
insert into ( table_name ) values ( 'value1' , 'value2' , ...);
If the value is number don't put the quotes .
Rehan said:
3 weeks ago
The reason you use "INSERT" in SQL to add a row is that the "INSERT" statement is specifically designed to add new records into tables within a database. It allows you to specify both the table and the values for each column you want to add, making it the standard and correct command for this operation in SQL.
Shariff said:
1 decade ago
What is implicit & explicit insertion?
Ankur said:
2 decades ago
Insert into <table_name> values("&name",&age);
Ritu singh said:
1 decade ago
Create is a command to create a new table.
Navee said:
1 decade ago
Insert is the only keyword to add a row in a table.
Piyush said:
1 decade ago
Insert command can be used to easily add the complete row.
Aysha said:
1 decade ago
Insert is the keyword to add all values into the table
Sangita said:
1 decade ago
Insert into<table name> values(001,'rupali');
Saidareddy said:
1 decade ago
Insert command is only add a row in a table.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers