Skip to content

Preprogrammer

Transcend your Programming Skills and Thoughts

  • Programming
    • Java Programming
    • C Programming
    • Linux Programming
    • PHP Development
    • Web Development
    • Network
  • Anti-Hacking and Security
    • Security
  • References
    • JavaScript
    • PHP
  • Contact Us

Category: SQL

The Right Programming Languages to Use in Data Visualization

On December 26, 2018 By Preprogrammer In MySQL, Programming, SQL

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 reading

SQL Datatypes

On April 27, 2017 By Preprogrammer In Programming, SQL

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 reading

SQL Reference JOIN, UNION, SET Operations

On April 18, 2017 By Preprogrammer In C Programming, Java, Java Programing, PHP, Programming, SQL

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

Allow Remote Connections to Mysql Server Ubuntu

On June 9, 2016 By Preprogrammer In Errors Solved, Guide, Linux Programming, MySQL, Network, PHP, Programming, SQL, Web Development

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

On April 18, 2016 By Preprogrammer In Linux Programming, Operating System, PostgreySQL, Programming, SQL

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 reading

How to prevent SQL injection in PHP

On March 10, 2016 By Preprogrammer In PHP, Programming, SQL

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

Recent Posts

  • The Right Programming Languages to Use in Data Visualization December 26, 2018
  • SQL Datatypes April 27, 2017
  • SQL Reference JOIN, UNION, SET Operations April 18, 2017
  • WordPress website transferring from remote to local machine April 18, 2017
  • Installing Composer on Debian April 17, 2017
  • VestaCP Creating Packages, adding Users April 13, 2017
  • Vestacp Hosting Control Panel Setup April 13, 2017
  • Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’ on Intellij April 13, 2017
  • IntelliJ vs Eclipse Keymap March 22, 2017
  • Debian Linux Mint F.lux error quick fix March 17, 2017

Subscription

Enter your email address:

About Me

I am Jinto Antony. I am a Software Engineer and Researcher. I love cooking my head inside the codes. And this is my blog, where I share my skills and knowledge.
To find out more about me click here: Jinto Antony
Trying to be Unique, Special and Resourceful..

Advertisements

WordPress Theme: Chronus by ThemeZee.