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.

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)

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

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

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

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

Haddad said:   8 years ago
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 .

Ahmed said:   1 decade ago
Query:

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

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

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

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.

Bhavya said:   9 years ago
Insert command is used to add/create the row in the table.

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


Post your comments here:

Your comments will be displayed after verification.