This example creates the table PROCLIB.PAYLIST and inserts data into it.

A DBMS trigger might prevent you from updating observations in a DBMS table. Refer to your DBA to determine if triggers are used in your DBMS tables. Some DBMSs require the SQL procedure's UNDO_POLICY ...

You should see the data listed (Figure A). Figure A Continue adding data to the table in the same fashion. And that’s all there is to creating a table and inserting data into it on MySQL.