This lesson describes how to insert values into the FRIENDZ
database table.
You can insert values into the RDZSCHE.FRIENDZ table by running
the following set of statements in your SQL script editor:
- Remove the previous create statement. Alternatively,
you can save the previous script and open a new script in the SQL
script editor.
- Copy and paste the following INSERT statements into the
editor. Replace USERID with your DB2® user ID.
INSERT INTO USERID.FRIENDZ ( FNAME, LNAME, PHONE, EMAIL )
VALUES ( 'CATHY', 'CAHIL', '555-1234', 'CATHY@MYEMAIL.COM' );
INSERT INTO USERID.FRIENDZ ( FNAME, LNAME, PHONE, EMAIL )
VALUES ( 'JERRY', 'SOUTH', '555-2345','JERRY@MYCOMPANY.COM' );
INSERT INTO USERID.FRIENDZ ( FNAME, LNAME, PHONE, EMAIL )
VALUES ( 'CELESTE', 'DANE', '555-3456', 'CELESTE@FASTEMAIL.COM' );
INSERT INTO USERID.FRIENDZ ( FNAME, LNAME, PHONE, EMAIL )
VALUES ( 'TYRONE', 'SMITH', '555-45678', 'TYRONE@MYEMAIL.COM' );
INSERT INTO USERID.FRIENDZ ( FNAME, LNAME, PHONE, EMAIL )
VALUES ( 'MAT', 'COYOTE', '555-1234', 'MAT122@FASTEMAIL.COM' );
- Select Run SQL from the pop-up menu. You should see the following results:
- You can save this script or close the SQL script editor
without saving.