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 ggl_links VALUES (101,

'http://www.rendc.org',

NULL,

0,

'30-Jul-2008');

1 row created.

SELECT * FROM ggl_links;

 ID URL    NOTES  COUNTS CREATED

----- ------------------------ -------- ------- ---------

 101 http://www.rendc.org NULL   0 30-Jul-08