To insert rows into a table, do the
following:
INSERT INTO ANTIQUES VALUES (21,
01, 'Ottoman', 200.00);
This inserts the
data into the table, as a new row,
column-by-column, in the pre-defined
order. Instead, let's change the order
and leave Price blank:
INSERT INTO ANTIQUES (BUYERID,
SELLERID, ITEM)
VALUES (01, 21, 'Ottoman'); |