I think that code section is broken and needs to be reviewed.
It is not too hard to just use the MySQL Workbench to set the squadrons.
Once connected you can right click on a table and select to 'Edit table data' which is easy enough to do.
Just add a new squadron in the squadron table and commit those changes.
Then select the rows from the squadron table to get the squadronId you want and edit the pilots table to set the squadronID for all pilots you want in that squadron.
WildWillie
|