All articles: General SQL

Checkout our self-help content, created by our top Experts!
Understanding MySQL Spatial Types – Querychat
In addition to storing data types of int, float, char and string, MySQL also supports storage of spatial data. Spatial data can be of either geometric or geographic type. What is spatial data? Spatial data is widely used to represent geometrical and geographical information used by various services. An example...
How to open SQL file in SQL Server? – Querychat
There are many ways to open an SQL file type using query editor of any database management system. We will learn specifically about opening SQL file in MS SQL Server. We will be using SQL Server Management Studio (SSMS) as query editor in this article. There are following options to...
How to Modify Data Types of Columns in MySQL Tables – Querychat
In this article, we learn how to modify the data type of columns in MySQL tables. Providing examples of how to do it correctly so that the data in the table does not conflict or get corrupted. For each structure change of tables in the database, we must use the...
How to Put Zero Values in Front of Numbers Using MySQL ZEROFILL Attributes – Querychat
In this article, we learn how to put 0 (Zero) values in front of numbers using ZEROFILL attributes in MySQL tables, along with an example of using the LPAD function to create the same ZEROFILL format. When processing data in a database, we may need to format data in different...
Candidate, Super, Primary, and Alternate Keys in SQL – Querychat
In this article, we will learn about the four type of keys used in relational databases. The super key. The candidate key. The primary key. The alternate key. Among these keys, the primary key is the only practical key in SQL while the rest are important concepts in the Relational...
Important MySQL Files – Querychat
In this article, we learn important files used and produced by MySQL Database Management System. These files either contain SQL queries or configurations. They are also created by MySQL Server when clients create or change databases or the program encounters with errors.  SQL files The Structured Query Language or SQL...
How to export MySQL data to Excel – Querychat
In this article, we will learn how to export data from a MySQL database to an MS Excel file. To achieve our goal, we will rely on the phpMyAdmin tool. First, we are going to create a Worker table on which we will develop our example. The Worker table will...
How to Create a SQL Server Automatic Backup Schedule – Querychat
Backup is the process of duplicating data or backing up data from existing data in the database. The purpose of backups is so that we can later restore them for any data loss. Because of the importance of data backup, in this article, we learn how to create the SQL...
How to Implement UTC Date and Time using getUTCDate Function in Javascript – Querychat
In the article, we learn how to implement UTC date and time using the getUTCDate function in Javascript. We will also take a look at some examples of implementing various UTC Javascript date methods. Javascript UTC date and time methods UTC date and time methods in Javascript can contain the...
MySQL Full-Text Searching: Boolean vs. Query-Expansion Type – Querychat
The article provides information about the differences between Boolean and Query-Expansion types in MySQL. It also provides examples of doing the Full-Text Search process by utilizing the two methods mentioned. In searching for data in a database, the speed and relevance of the search results are required. MySQL introduces the...
1 2 20 21