SQL

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

Allow Remote Connections to Mysql Server Ubuntu

Allow Remote Connections to Mysql Server Ubuntu

To Allow Remote Connections to Mysql Server, we have manually add some code to the configurations of the mysql server. This article is about Allow Remote Connections to Mysql Server Ubuntu operating system (Debian based). Ok. Let’s start, At the time of installation MySQL is already available to the localhost…
Read more

Upgrading Postgresql on Debian/Ubuntu/Mint

Upgrading Postgresql on Debian Ubuntu Mint

Upgrading Postgresql on Debian Ubuntu Mint ? Upgrading Postgresql on Debian/Ubuntu/Mint or Updating was not a tough procedure. Some times when you update your system, there may be a possibility that postgresql dependent files were missing or not found. On my computer, running elementary os generated and issue like this…
Read more