MySQL Cheat Sheet - Quick Reference Guide
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
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
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
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
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
How to delete a record using JDBC PreparedStatement to avoid SQL injection.
Search
Other Posts
Follow Us On