Latest Posts

SQL Datatypes

SQL Datatypes Data types specify the type of data for a particular column.If a column called “LastName” is going to hold names, then that particular column should have a “varchar” (variable-length character) data type.The most common data types: SQL Datatypes – Numeric INT -A normal-sized integer that can be signed…
Read more

SQL Reference JOIN, UNION, SET Operations

SQL Reference JOIN, UNION, SET Operations. This article is all about those. Custom Names SELECT ct.ID, ct.Name, ord.Name, ord.Amount FROM customers AS ct, orders AS ord WHERE ct.ID=ord.Customer_ID ORDER BY ct.ID; Types of Join The following are the types of JOIN that can be used in MySQL: – INNER JOIN…
Read more

WordPress website transferring from remote to local machine

WordPress website transferring from remote to local machine, it is a necessary when it comes to backups or testing. This tutorial is all about WordPress website transferring from remote to local machine. Before we starting, we need the backups of Database, Website folder ((Normally, everything inside public-html folder of the…
Read more

How to solve, Classic error: Unable to update index for central|http://repo1.maven.org/maven2

How to solve, Classic error: Unable to update index for central|http://repo1.maven.org/maven2. Sometimes Eclipse failed to index the repository due to errors/configurations. In such scenarios, even if you try to search in the repositories, it will fail due to the non indexed repo.To fix these kind of problems, try the following….
Read more