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 3 of 5.

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);

Naidu said:   1 decade ago
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);

VijayNS said:   1 decade ago
Add any row in a database by using INSERT key word accessing values by using & symbol it address the values of rows.

M g balaji said:   1 decade ago
Insert is a keyword in order to add the new row.

Raj said:   1 decade ago
Insert command is only add a row in a table.

Kani said:   1 decade ago
It's a keyword.

Srinivas said:   1 decade ago
Insert into <table_name> values("&ColumnName1","&ColumnName2");

Timir said:   1 decade ago
Example of inserting a row as follows:

INSERT INTO table_name VALUES ('FOR STRINGS',FOR NUMERIC VALUES);

Manche Shekhar said:   1 decade ago
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);

Shariff said:   1 decade ago
What is implicit & explicit insertion?


Post your comments here:

Your comments will be displayed after verification.