Introduction to SQL stored procedures A stored procedure is just like a method in Java, it can include more than one SQL statement, and it can take parameters. Moreover we can save the SQL code and reuse it again. Delimiter First we have to know some thing called delimiter. The default delimiter in MySQL is…

Basic SQL commands We will study the basic SQL commands to query and manipulate data in tables. From now on, we will work exclusively with the test database. At first we have to open the CMD window (or the terminal in Linux/MacOs) and type: Just enter password and we are good to go. Then in…

Basic SQL commands We will study the basic SQL commands to query and manipulate data in tables. From now on, we will work exclusively with the test database. At first we have to open the CMD window (or the terminal in Linux/MacOs) and type: Just enter password and we are good to go. Then in…

Basic SQL commands We will study the basic SQL commands to query and manipulate data in tables. From now on, we will work exclusively with the test database. At first we have to open the CMD window (or the terminal in Linux/MacOs) and type: Just enter password and we are good to go. Then in…

Introduction to Relational Database, SQL and JDBC JDBC stands for Java Database Connectivity, which is a Java Application Programming Interface for a client to access databases. So at first we should know about databases, especially relational databases. A database is a collection of data. A relational database is a database that stores data in tables,…