Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 1)
You can add a row using SQL in a database with which of the following?
Answer: Option
No answer description is available. Let's discuss.
41 comments Page 1 of 5.

Suchithra said:   7 years ago
You can add a row using INSERT keyword.

MURALI CHAVADI said:   3 years ago
insert into TABLENAME into VALUES(col1,col2,....);

Ajin_k said:   6 years ago
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()',.....);

Kanimozhi said:   7 years ago
INSERT is for putting in a fresh record to a table.

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

Aniley Belayneh said:   1 decade ago
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,...)

Deependera said:   1 decade ago
We can use insert command to insert data in a table.


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

Kitty said:   1 decade ago
We can add a row using the key word of insert.

Vanesha said:   9 years ago
The correct answer is insert keyword only because this keyword is add new row.

Prasanth said:   9 years ago
Yes, absolutely. I will use insert keyword to insert a row in a table. No options.

Post your comments here:

Your comments will be displayed after verification.