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?
ADD
CREATE
INSERT
MAKE
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
41 comments Page 1 of 5.

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

Suchithra said:   8 years ago
You can add a row using INSERT keyword.
(3)

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

Mk kashyap said:   8 years ago
INSERT is only keyword to add a row in database/table.
(2)

DKSIVA said:   5 years ago
insert into T.N values(1,2,3,4,5,....etc)
(1)

Saikiran said:   6 years ago
"How to insert values into a table"?
(1)

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

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

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

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

Syntax:
INSERT INTO <TABLE NAME> (FIELD1,FILED2,FIELD3) VALUES (VALUE1,VALUE2,VALUE3);

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


Post your comments here:

Your comments will be displayed after verification.