Author Archive: Preprogrammer

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