General Articles
What is NewSQL? Bridging SQL and NoSQL
Hey there! If you’ve ever heard about databases and wondered what the deal is with NewSQL, you’re in the right…
Tag: SQL
General Articles
Adding a Column to Existing Table in SQL Server
In the dynamic world of database management, the ability to adapt and modify your database structure according to changing requirements…
SQL Statements
How to Calculate the MySQL Database Size
A MySQL database’s size is an important aspect to monitor as it impacts the performance, backup, and recovery process of…
General Articles
How to Prevent SQL-injection in PHP using Prepared Statements
SQL injection is a common form of attack that targets web applications that use SQL databases. In this type of…
Security
Preventing SQL injection attacks with prepared statements in MySQL
SQL injection attacks are one of the most common security threats that web applications face today. These attacks occur when…
SQL Server
How To Restore SQL Server Database
Microsoft SQL Server (MSSQL) is a relational database management system used on Windows servers. The latest versions are also available…
MongoDB
How to Use LIKE Statement in MongoDB
MongoDB is an powerful Nosql database server. MongoDB uses JSON-like documents with optional schemas to store data. Its always a…
General Articles
MySQL case-sensitive Search with LIKE
The LIKE statement is used for searching records with partial strings in MySQL. By default the query with LIKE matches…
MySQL
How To Install MySQL 5.7 on Fedora 31/30
MySQL is a relational database management system. This tutorial will help you to install MySQL 5.7 on Fedora Linux systems.…
MariaDB
How to Install MariaDB 10.4 on CentOS/RHEL 7/6
MariaDB 10.4 stable version has been released. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better…