MySQL Cheat Sheet - Quick Reference Guide

  • 24 April 2023
  • ADM

A concise MySQL cheat sheet providing a quick reference guide for common MySQL commands, database and table operations, data manipulation, and more.


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.


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


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.