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?
Discussion:
43 comments Page 4 of 5.
Rani said:
1 decade ago
Insert is the command used to add rows in a table.
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.
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
We can insert a row into table in two ways:
1)implicit insertion
2)explicit insertion
Nithya said:
1 decade ago
We can add rows using Insert keyword only.
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);
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);
Timir said:
1 decade ago
Example of inserting a row as follows:
INSERT INTO table_name VALUES ('FOR STRINGS',FOR NUMERIC VALUES);
INSERT INTO table_name VALUES ('FOR STRINGS',FOR NUMERIC VALUES);
Srinivas said:
1 decade ago
Insert into <table_name> values("&ColumnName1","&ColumnName2");
Kani said:
1 decade ago
It's a keyword.
Raj said:
1 decade ago
Insert command is only add a row in a table.
M g balaji said:
1 decade ago
Insert is a keyword in order to add the new row.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers