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.
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);
Shariff said:
1 decade ago
What is implicit & explicit insertion?
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
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.
Rani said:
1 decade ago
Insert is the command used to add rows in a table.
Saidareddy said:
1 decade ago
Insert command is only add a row in a table.
Sangita said:
1 decade ago
Insert into<table name> values(001,'rupali');
Aysha said:
1 decade ago
Insert is the keyword to add all values into the table
Piyush said:
1 decade ago
Insert command can be used to easily add the complete row.
Navee said:
1 decade ago
Insert is the only keyword to add a row in a table.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers