All articles: General SQL

Checkout our self-help content, created by our top Experts!
Start mysql and common errors – Querychat
Once a MySQL Server is installed and configured, we also need to start and restart the server in the future. This task applies to owners of the database or to a DBA (Database Administrator). In this article, we look at step-by-step instructions on how to start a MySQL Server on...
MySQL stored procedure and example – Querychat
Itself a procedure is the procedure which database preserves on the server. Before there were not supported triggers, events, and stored functions, this feature appeared from MySQL 5.0. Why are procedures used? Flexibility and adoption; Stored procedures process complex logic without the need to sending intermediate results to the application....
MySQL guide to Ports – Querychat
In the network protocol terms, ports are a mechanism that allows a server to support multiple connection sessions with clients on the network. This article provides an explanation of the port as a path and as a connectivity guide to the MySQL standard port. An overview of the network protocols...
MySQL Varchar vs text – Querychat
The String type is the basic data type that contains a collection of characters with a certain length. The characteristic of string types are values enclosed in quotation marks (“). To store strings in Memory, it takes 1 byte for each character. This article will provide information about the differences...
MySQL Workbench – Querychat
MySQL Workbench is a visual tool for performing Data Modelling, Development and Database Administration tasks. Before getting into fancy options of MySQL Workbench, Let’s brief a bit on “How to Install MySQL Workbench on Mac/Linux/Windows”. How to Install MySQL Workbench for Mac/Linux/Windows To Install MySQL Workbench on Mac: MySQL Workbench...
Download, Install, Start, and Stop MySQL in OS – Querychat
Before we start MySQL Server through Xampp on Windows OS, it is good to get acquainted with XAMPP. The XAMPP stands for Cross-Platform, Apache, MariaDB, PHP, and Perl. This article will explain how to start MySQL using XAMPP in Windows OS. Download MySQL XAMPP To download MySQL using the installation...
Introduction to Boolean data type in MySQL – Querychat
The data type is used as the basis of variable declarations and can provide information about what data is contained in a database table. Data types in a database table can be divided into several categories namely numeric, date and time, string, spatial, also the JSON. The Boolean Data Type...
Difference between SQL, MySQL, and Oracle – Querychat
SQL is a standard database programming language that has been widely implemented by various Relational DBMS. It is currently available with SQL versions and additional features besides the existing standards such as MS SQL, MySQL, and Oracle. Although by its standard language, SQL uses also has differences even the basic...
1 2 18 19