JDBC – Insert, Update and Delete example.

Hello Friends,

This is the simple example for executing the SQL statements to INSERT, UPDATE or DELETE any records from the database using JDBC. In the below code I have explained all the three operations. When we insert, update or delete any records from the database we are updating the database, hence we use the executeUpdate() function with the Statement.

Continue reading “JDBC – Insert, Update and Delete example.”

Import/Export sql Dump into Mysql.

Hello Friends,

This is one of my tutorial related to MySQL database. While using MySql database you may have come across this issue to import your data from one place to another. But how to do that when the data we have is smaller in size but what when the data is heavy. In such case Mysql provides the option to export your data as a dump (.sql file) and then import the same data into new server or new system. The import and export of MySQL database not only is important to recover the data when disaster strikes, but also provides an easy way to migrate or move to another server, such as when switching web hosting providers. Continue reading “Import/Export sql Dump into Mysql.”

MySql Command Prompt-Tips and Tricks.

Hello Friends,

This is another tutorial for some of the basic points to remember for using MySQL Database.

MySQL is a client-server Database management system, and so to use MySQL we need a client, an application that we will use to interact with MySQL is its command prompt.(giving it commands to be executed).

Every MySQL installation comes with a simple command-line utility called mysql. This utility does not have any drop-down menus, fancy user interfaces, mouse support, or anything like that. Continue reading “MySql Command Prompt-Tips and Tricks.”

MySql Installation

Hello Friends,


This is one of my tutorials related to database. You all must be familiar with MySQL, but still for those who have not learned about this, for them I will recall it in short.

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.The most important feature of this is that it is open-source  i.e. it does not require any licence to use. I can be easily downloaded from the internet for personal use. Hence some of the free software projects that require a full-featured database management system often use MySQL. Continue reading “MySql Installation”