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.

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()',.....);

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

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.


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

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.