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 5 of 5.
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.
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);
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);
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);
Syntax:
INSERT INTO <TABLE NAME> (FIELD1,FILED2,FIELD3) VALUES (VALUE1,VALUE2,VALUE3);
EXAMPLE:
INSERT INTO student(stu_id,name,total) values(101,'Jitu',120);
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers