Asked by SQL - DB2 Insert Example:
The following show you a sample SQL DB2 insert. This shows example code assuming you were inserting into a DB2 table that was named "SAMPTAB", where it has 3 columns in the table each defined differently. One is an integer column, one is a decimal column, and one is a 5 byte char column as shown.
Although this sample is showing a mainframe DB2 SQL sample, these are mostly the same everywhere so the platform doesnt really matter much.
INSERT INTO SAMPTAB
VALUES (5, 17.2, 'TEST1');
Add your reply below ...