How To Insert a New Row into a Table?
Page 1 of 1
How To Insert a New Row into a Table?
by Micheal Sat Jan 16, 2010 9:34 pm
To insert a new row into a table, you should use the INSERT INTO statement with values
specified for all columns as shown in the following example:
INSERT INTO fyi_links VALUES (101,
'http://dev.fyicenter.com',
NULL,
0,
'30-Apr-2006');
1 row created.
SELECT * FROM fyi_links;
ID URL NOTES COUNTS CREATED
----- ------------------------ ------------ ------- ---------
101 http://dev.fyicenter.com NULL 0 30-Apr-06
specified for all columns as shown in the following example:
INSERT INTO fyi_links VALUES (101,
'http://dev.fyicenter.com',
NULL,
0,
'30-Apr-2006');
1 row created.
SELECT * FROM fyi_links;
ID URL NOTES COUNTS CREATED
----- ------------------------ ------------ ------- ---------
101 http://dev.fyicenter.com NULL 0 30-Apr-06
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» How To Create a New Table by Selecting Rows from Another Table?
» How To Create a New Table by Selecting Rows from Another Table?
» Insert command in SQL
» What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema?
» How To Create a New Table?
» How To Create a New Table by Selecting Rows from Another Table?
» Insert command in SQL
» What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema?
» How To Create a New Table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL