How To Insert a New Row into a Table?

Answer 1

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 temp_links VALUES (101,
  'dev.tempsite.com',
  NULL,
  0,
  '30-Sep-2010');
1 row created.

SELECT * FROM temp_links;
   ID URL                      NOTES     COUNTS CREATED
----- ------------------------ -------- ------- ---------
  101 dev.tempsite.com NULL           0 30-SEP-10