Data visualization is simply the understanding of data or its presentation in a visual context. It helps the relevant parties understand what has been presented visually so that they have the right information to make …
Continue readingCategory: 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 …
Continue readingSQL 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 …
Continue reading
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). …
Continue reading
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 …
Continue readingHow to prevent SQL injection in PHP
How to prevent SQL-injection in PHP,many of you are using core php to built, large and scalable applications in Web.And, you face SQL Injection attacks many times after deploying the application.This tutorial is all about …
Continue reading