Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.1)


You can add a row using SQL in a database with which of the following?

[A]. ADD

Answer: Option C


No answer description available for this question.

Nithya said: (Oct 20, 2010)  
We can add rows using Insert keyword only.

Ankur said: (Nov 26, 2010)  
Insert into <table_name> values("&name",&age);

Ritu Singh said: (Dec 9, 2010)  
Create is a command to create a new table.

Navee said: (Mar 2, 2011)  
Insert is the only keyword to add a row in a table.

Piyush said: (Mar 16, 2011)  
Insert command can be used to easily add the complete row.

Aysha said: (Mar 25, 2011)  
Insert is the keyword to add all values into the table

Sangita said: (Aug 4, 2011)  
Insert into<table name> values(001,'rupali');

Saidareddy said: (Sep 17, 2011)  
Insert command is only add a row in a table.

Rani said: (Oct 2, 2011)  
Insert is the command used to add rows in a table.

Ahmed said: (Oct 5, 2011)  

Insert into <table_name>[(column names)] values(value1,value2,....);

In case of character input values must be written within single quotes.

Manche Shekhar said: (Nov 3, 2011)  
We can add a new row into table using insert command..

We can insert a row into table in two ways:
1)implicit insertion
2)explicit insertion

Shariff said: (Nov 11, 2011)  
What is implicit & explicit insertion?

Manche Shekhar said: (Nov 15, 2011)  
In implicit insertion we insert specific field values:
The syntax is:
insert into <tablename>(list of columns) values(list of values);

In explicit insertion we insert all field values:
The syntax is:
insert into <tablename>values(list of values);

Timir said: (Dec 24, 2011)  
Example of inserting a row as follows:


Srinivas said: (Jan 17, 2012)  
Insert into <table_name> values("&ColumnName1","&ColumnName2");

Kani said: (Jan 20, 2012)  
It's a keyword.

Raj said: (Feb 9, 2012)  
Insert command is only add a row in a table.

M G Balaji said: (Jun 2, 2012)  
Insert is a keyword in order to add the new row.

Vijayns said: (Jun 28, 2012)  
Add any row in a database by using INSERT key word accessing values by using & symbol it address the values of rows.

Naidu said: (Aug 30, 2012)  
We can add values into table using insert keyword.
ex:create table emp(name varchar2(20),age number(20)));
it will create emp table and now insert values into this table using fallowing insert query syntax:
insert into <tablename> values('if string or date',number);

Ex:insert into emp values('nani',25);

Deependera said: (Dec 1, 2012)  
We can use insert command to insert data in a table.


INSERT INTO student(stu_id,name,total) values(101,'Jitu',120);

Aniley Belayneh said: (Dec 3, 2012)  
The INSERT INTO statement is used to insert a new row in a table.

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,...)

Kitty said: (Aug 13, 2013)  
We can add a row using the key word of insert.

Vanesha said: (Jul 12, 2014)  
The correct answer is insert keyword only because this keyword is add new row.

Prasanth said: (Mar 25, 2015)  
Yes, absolutely. I will use insert keyword to insert a row in a table. No options.

Mahesh Karbhal said: (Apr 28, 2015)  
INSERT command is use for inserting row in a table.

Prasu said: (Jun 30, 2015)  
Insert command is used insert new values into table.

Mounika Pallapu said: (Oct 27, 2015)  
INSERT is a keyword it is used for ADD the values to the table.

Bhavya said: (Oct 28, 2015)  
Insert command is used to add/create the row in the table.

INSERT into TABLE -NAME values('value1','value2','value3');

Pawan Kumar said: (Mar 9, 2016)  
If change the serial of value like (value1', ' value3', ' value2) ; then variable will execute or not?

Pawan Kumar said: (Mar 9, 2016)  
What is use of add and make?

Sacdiyo Nuur Maxamuud said: (Mar 26, 2016)  
You can add a row using INSERT keyword.

Haddad said: (Apr 3, 2016)  
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 .

Mk Kashyap said: (Jul 7, 2016)  
INSERT is only keyword to add a row in database/table.

Suchithra said: (Oct 20, 2016)  
You can add a row using INSERT keyword.

Vramakrishna said: (Dec 7, 2016)  
Insert into <table_name>[(column names)] values(value1,value2,....); .

Kanimozhi said: (Dec 26, 2016)  
INSERT is for putting in a fresh record to a table.

Ajin_K said: (Jul 14, 2017)  
Queries explanation:

1] ADD : It is used to add the column in already created table using alter keyword.
ex. alter table table_name ADD (column_name data_type(size));

2] CREATE: it is used to create the new table .
ex. CREATE table table_name (column_name data_type(size) );

3] INSERT: it is used to insert the row values into the already created table.
ex. INSERT into table_name values (1 ,'XYZ', ....)
or INSERT into table_name values(&column1, '&column2()',.....);

Saikiran said: (Jul 20, 2018)  
"How to insert values into a table"?

Dksiva said: (Dec 1, 2019)  
insert into T.N values(1,2,3,4,5,....etc)

Murali Chavadi said: (Jul 5, 2020)  
insert into TABLENAME into VALUES(col1,col2,....);

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.