Tag: Database


13

Apr 2016

SQL UPDATE Statement

SQL UPDATE Statement The UPDATE statement is used to update records in a table. The SQL UPDATE Statement The UPDATE statement is used to update existing records in a table. SQL UPDATE Syntax UPDATE table_name SET column1=value1,column2=value2,… WHERE some_column=some_value; Note Notice the WHERE clause in the SQL UPDATE statement! The WHERE clause specifies which record or records that should be updated. If you omit the...

Read More


13

Apr 2016

SQL INSERT INTO Statement

SQL INSERT INTO Statement The INSERT INTO statement is used to insert new records in a table. The SQL INSERT INTO Statement The INSERT INTO statement is used to insert new records in a table. SQL INSERT INTO Syntax It is possible to write the INSERT INTO statement in two forms. Demo Database In this tutorial we will use the well-known Northwind sample database. Below...

Read More


13

Apr 2016

SQL ORDER BY Keyword

SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set. The SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set by one or more columns. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in a descending order, you can use the DESC keyword. SQL ORDER BY Syntax Demo...

Read More


13

Apr 2016

SQL AND & OR Operators

SQL AND & OR Operators The AND & OR operators are used to filter records based on more than one condition. The SQL AND & OR Operators The AND operator displays a record if both the first condition AND the second condition are true. The OR operator displays a record if either the first condition OR the second condition is true. Demo Database In this...

Read More


13

Apr 2016

SQL WHERE Clause

SQL WHERE Clause The WHERE clause is used to filter records. The SQL WHERE Clause The WHERE clause is used to extract only those records that fulfill a specified criterion. SQL WHERE Syntax Demo Database In this tutorial we will use the well-known Northwind sample database. Below is a selection from the “Customers” table: CustomerID CustomerName ContactName Address City PostalCode Country 1 Alfreds Futterkiste Maria...

Read More


15

Aug 2015

Database Connectivity using Type I – JDBC Driver in Java(J2SE)

What is JDBC? JDBC(Java DataBase Connectivity) is used for connecting to different database by which user can shift from one database to another database very easily in platform independent manner. JDBC contains set of functions & specification in the form of packages i.e.: java.sql.*–Core SQL Package javax.sql.*–Extended SQL Package JDBC Driver act like an interface between front end application and back end database. There are four types of JDBC Driver Type...

Read More