create table TraineeDetals(
TraineeID smallint unsigned not null auto_increment primary key,
FirstName varchar(100) not null,
MiddleName varchar(100) not null,
LastName varchar(100) not null
)

create table CollegeDetails(
collegeName varchar(100) not null,
Specialization varchar(100) not null,
TraineeID smallint unsigned not null,
constraint 'fk_Trainee'
foreign key (TraineeID) references TraineeDetails (TraineeID)
on delete cascade
on update restrict
)

String url="jdbc:mysql://localhost/mysql";
   String user="root";
   String pass="root";

   private void
   SaveButtonActionPerformed(java.awt.event.ActionEvent evt) {

   try{

        Class.forName("com.mysql.jdbc.Driver");
        Connection con=DriverManager.getConnection(url, user,
        pass);
        String sql="Insert into TraineeDetails
        (FirstName,MiddleName,LastName)values(?,?,?)";
        PreparedStatement pst =con.prepareStatement(sql);

        pst.setString(1, firstNameTextFiled.getText());
        pst.setString(2, MiddleNameTextField.getText());
        pst.setString(3, LastNameTextField.getText());

        String sql2 = "Insert into CollegeDetails (CollegeName,
        Specialization,TraineeID)values(?,?,?)";
        PreparedStatement pst2 =con.prepareStatement(sql2);

        pst2.setString(1, CollegeNameTextField.getText());
        pst2.setString(2, SpecializationTextField.getText());
        pst.setString(3, TraineeIDTextField.getText());


        pst.executeUpdate();
        pst2.executeUpdate();


        JOptionPane.showInputDialog(this,"Insert
        Successfully");

        clearText();

    }
    catch(Exception e)
    {
        JOptionPane.showInputDialog(this,e.getMessage());
    }
    }

create table greetings
(i int generated by default as identity (START WITH
2, INCREMENT BY 1),
ch char(50));
-- specify value "1":
insert into greetings values (1, 'hi');
-- use generated default
insert into greetings values (DEFAULT, 'salut');
-- use generated default
insert into greetings(ch) values ('bonjour');