SQL

When you try to connect to a Database using a tool like MySQL Workbench then you may run into an error like below, as the user is not allowed to access the Database from a remote location. Access denied for user ‘username’@’192.168.2.2’ (using password: YES) Note: You’ll require Administrator privileges. How to Enable Remote Access […]

Delete Delete is used to remove the records that are contained in a Database Table. For example, if we have a table named Employees and we want to delete all the records from that table, then our SQL query looks like: If we want to delete only a specific record, say employee with employee id […]

Difference between DDL, DML and DCL Commands

Thumbnail image for Difference between DDL, DML and DCL Commands February 24, 2014

In this article we are going to explain Difference between DDL, DML and DCL Commands and their usage with examples. So let us get started. 1. DDL – Data Definition Language 2. DML – Data Manipulation Language 3. DCL – Data Control Language Data Definition Language – DDL 1. CREATE CREATE is used to create […]

Read the full article →

SQL WHERE Clause – Things beginners must know

January 30, 2014

SQL Where clause is basically used to fetch the data from a particular table or multiple tables by joining tables. Only when the SQL where clause condition is processed, the database will return a value from the table specified by filtering the entries (records in the table). In short, the SQL Where clause in the […]

Read the full article →

How to use SQL Like operator

Thumbnail image for How to use SQL Like operator September 29, 2013

SQL LIKE operator is used to search for a string with specific pattern. It uses wildcard characters ‘%’ and ‘_’ to search for a pattern in the string. % represents a single or multiple characters whereas ‘_’ represents a single character, let us see How to use SQL Like operator. How to use SQL LIKE […]

Read the full article →

How to create a new user in Oracle SQL Plus?

September 14, 2013

The default login credentials of SQL Plus will be. Username : scott Password : tiger. But, we do have the password and user expiry time feature on SQL Plus software and we need to disable that thing, else you can’t login to your SQL Plus scott account. Same thing happened with me and I was […]

Read the full article →

How to Get MIDDLE Character of a String in SQL

March 18, 2013

In this article we will discuss about how to get middle character of a string in SQL. We have already explained about Substring function in our earlier article. We have a different case here, We need to get Middle character of a String. Only Middle Character? What if we need 3 characters after the middle […]

Read the full article →

How to Import CSV to MySQL

Thumbnail image for How to Import CSV to MySQL March 16, 2013

Do you have your client list in the form of Excel sheet and you would like to use it on your Website or a Project by retrieving the data from MySQL Database. You can do this by converting the Excel sheet into a Comma Separated Values (CSV ) file. So, How to import CSV to […]

Read the full article →

How to get Max Count in MySQL

March 14, 2013

Yay! This is our 50th article and we are very happy with our readers support. Today I got a query from one of the user on How to get MAX COUNT in MySQL MAX(COUNT(*)). Actually, when I wrote this query in Oracle SQL, I got the output. Where as coming to MySQL I got an […]

Read the full article →

Display Records if nth Character is A or some other letter

March 12, 2013

In this we will discuss about Displaying Records if nth character is A or some other letter. For example if we want to display username records which have an alphabet “a” as second character in it. Basically if we want to display username which start with alphabet A, then we will use: In the same […]

Read the full article →