How to define one-to-one relationship in MySQL

  • 08 July 2016
  • ADM

How to define one-to-one relationship in MySQL using the foreign key and unique property to limit the row count from the child table


Split a string and loop in SQL Server

  • 20 May 2016
  • ADM

How to split a string and loop it's values in Microsoft SQL Server. Simple solution used to insert data into tables.


How to delete a record using JDBC PreparedStatement

  • 19 May 2016
  • ADM

How to delete a record using JDBC PreparedStatement to avoid SQL injection.


How to update a record using JDBC PreparedStatement

  • 29 April 2016
  • ADM

How to update a record using JDBC PreparedStatement to avoid SQL injection.


How to select records using JDBC PreparedStatement

  • 05 April 2016
  • ADM

How to select records from MySQL database using JDBC PreparedStatement to avoid SQL injection.


How to insert a record using JDBC PreparedStatement

  • 05 April 2016
  • ADM

How to insert a new record using JDBC PreparedStatement in Java to avoid SQL injection. Example with auto-increment table.