After the tables are created using DDL, you can optionally populate the database with data using SQL script. To do this, specify the path (absolute file path or path relative to the application) to the SQL script file that has to be executed. The script is run only when dbcreate is set to dropcreate. The SQL script file lets you populate the tables before the application is accessed. Ensure that each SQL statement starts on a new line and ends with a semi-colon.
Example
Mysqlscript.sql
insert into Artists(artistid, firstname, lastname, address, city, state, postalcode, email, phone, fax, thepassword) |
