Feb 032017

ADM

How to export and import a .sql file in MySQL from command line

  • 03 February 2017
  • ADM

How to export and import a .sql file in MySQL from command line. Simple commands with multiple parameters.

Jul 152016

ADM

How to generate tables from entities using EclipseLink

  • 15 July 2016
  • ADM

How to generate entities from tables using EclipseLink. Simple example using one-to-one database relationship. @MappedSuperclass example included

Jul 082016

ADM

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

May 202016

ADM

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.

May 192016

ADM

How to delete a record using JDBC PreparedStatement

  • 19 May 2016
  • ADM

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

Apr 052016

ADM

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.