Tutorials and Guides on Databases (MySQL, MsSQL and other Databases and SQL)


Category Archives for "Databases"


SQL BETWEEN Operator is used to filter rows based on range of values in specified column. These values can be numbers, text or dates. Rows can be retrieved not in between the range of values specified column.

Continue reading

SQL LIKE Operator

SQL LIKE Operator is used in WHERE Clause of SQL statement, to search for specific pattern in column. And the pattern we can place it in different formats. Here I’ll provide different types of formats that you can use in SQL LIKE Operator.

Continue reading


SQL SELECT LIMIT, TOP, ROWNUM clauses are used to limit the number of retrieved records. SQL SELECT LIMIT, TOP, ROWNUM clauses are very useful to databases having lot of records, this clause helps to return limited number of results instead of all records. For large databases it takes lot of time to retrieve all the […]

Continue reading


SQL ORDER BY is used to filter results by ascending or descending order in SQL SELECT statements. We can add ORDER BY right after the table name or after WHERE clause in the SQL statement.

Continue reading


SQL WHERE Clause is used to retrieve specific records which matches the column names and values in WHERE clause. This SQL WHERE clause is used in any SQL statement, either it is SELECT, UPDATE, DELETE statements.

Continue reading


SQL DISTINCT function is used in SELECT statements, it is used to retrieve the results without duplicate values. That means SQL DISTINCT function will retrieve different values. Sample code for SQL DISTINCT is :

Continue reading

How to import a database using PHPMyAdmin

How to import a database using PHPMyAdmin, before importing database you need to have database file which will be imported in other web server. First create a database and select that database, after that you can see list of tabs on top, click on import under “File to Import:” select the sql file or compressed […]

Continue reading