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.


Split URL into components using regex

  • 23 May 2016
  • ADM

Split URL into components (protocol, domain, port and uri) using regex in Java. Simple and tested example.


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 prepare a Windows Java Development Machine

  • 05 April 2016
  • ADM

How to prepare a Windows Java Development Machine using Eclipse, NetBeans, Ant, Maven, MySQL, MongoDB, GIT, SVN.


How to update a record using JDBC PreparedStatement

  • 29 April 2016
  • ADM

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