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:
43 comments Page 2 of 5.
Kitty said:
1 decade ago
We can add a row using the key word of insert.
Aniley Belayneh said:
1 decade ago
The INSERT INTO statement is used to insert a new row in a table.
SQL INSERT INTO Syntax
It is possible to write the INSERT INTO statement in two forms.
The first form doesn't specify the column names where the data will be inserted, only their values:
1.INSERT INTO table_name
VALUES (value1, value2, value3,...)
2.The second form specifies both the column names and the values to be inserted:
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)
SQL INSERT INTO Syntax
It is possible to write the INSERT INTO statement in two forms.
The first form doesn't specify the column names where the data will be inserted, only their values:
1.INSERT INTO table_name
VALUES (value1, value2, value3,...)
2.The second form specifies both the column names and the values to be inserted:
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)
Vanesha said:
1 decade ago
The correct answer is insert keyword only because this keyword is add new row.
Prasanth said:
1 decade ago
Yes, absolutely. I will use insert keyword to insert a row in a table. No options.
Mahesh Karbhal said:
1 decade ago
INSERT command is use for inserting row in a table.
Prasu said:
1 decade ago
Insert command is used insert new values into table.
Mounika Pallapu said:
10 years ago
INSERT is a keyword it is used for ADD the values to the table.
Bhavya said:
10 years ago
Insert command is used to add/create the row in the table.
INSERT into TABLE -NAME values('value1','value2','value3');
INSERT into TABLE -NAME values('value1','value2','value3');
Pawan kumar said:
9 years ago
What is use of add and make?
Pawan Kumar said:
9 years ago
If change the serial of value like (value1', ' value3', ' value2) ; then variable will execute or not?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers