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 1 of 5.
Kaivu said:
3 months ago
You have to add a row, not a table because of that I used the insert query to add the row.
For adding the table you can write the add table.
For adding the table you can write the add table.
(1)
MMD said:
8 months ago
Thanks everyone for explaining the answer.
(1)
MURALI CHAVADI said:
5 years ago
insert into TABLENAME into VALUES(col1,col2,....);
(5)
DKSIVA said:
6 years ago
insert into T.N values(1,2,3,4,5,....etc)
(3)
Saikiran said:
7 years ago
"How to insert values into a table"?
(1)
Ajin_k said:
8 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()',.....);
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()',.....);
(3)
Kanimozhi said:
9 years ago
INSERT is for putting in a fresh record to a table.
(1)
Vramakrishna said:
9 years ago
Insert into <table_name>[(column names)] values(value1,value2,....); .
(1)
Suchithra said:
9 years ago
You can add a row using INSERT keyword.
(3)
Mk kashyap said:
9 years ago
INSERT is only keyword to add a row in database/table.
(2)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers