All articles: Data Definition Language (DDL)

Checkout our self-help content, created by our top Experts!
How to Set and Change Passwords on MySQL Users – Querychat
In this article, we learn how to set passwords on MySQL users along with examples of changing the password using the SET PASSWORD, ALTER USER and UPDATE statements. Providing passwords to MySQL users is intended to make the database safer when accessing objects in the database. Passwords on MySQL users...
MySQL FLOAT vs DOUBLE vs DECIMAL- Querychat
In this article, we will talk about three different floating types in MySQL: FLOAT, DOUBLE, and DECIMAL. We will discuss their distinctive features and illustrate them with an example, that will compare FLOAT vs DOUBLE vs DECIMAL types.  What are the floating types? These data types are used to indicate...
Can SQL Server manage the longest phone number in the world? – Querychat
In this article, we will cover a common question about the SQL Server that goes around the Web, which is if the SQL Server can manage the longest phone number.  First, let us check how a phone number is assembled. A phone number forms part of a telephone numbering plan,...
What is SQL Fiddle?– Querychat
In this article, we will check what SQLfiddle is, the basics of the tools that it provides, and how it works. Sometimes we do not have access to a local SQL testing engine. SQLfiddle.com is one of the online options to test different SQL versions.  SQL has several online testing...
Managing Assemblies in SQL Server – Querychat
In this article, we will cover the basics of how to manage Assemblies in SQL server, including how to create, alter, and drop an Assembly with simplified examples. An SQL server assembly is considered a gather unit for different compiled objects from a database, including triggers, functions, or stored procedures....
How to use cascade delete and cascade update in MySQL – Querychat
In this article, we will see what CASCADE mode is and how to use it in MySQL when deleting or updating the rows from a table. The content will be illustrated with practical examples. What is CASCADE in SQL Cascading in SQL is related to foreign keys. It refers to...
How to do a case sensitive/insensitive search in MySQL -Querychat
In this article, we will learn how to perform case sensitive and case insensitive searches in MySQL. We will also learn how to define the columns of a table so that their values are case sensitive or insensitive in searches. Is MySQL case sensitive on searches? MySQL will be sensitive...
How to count decimal digits in SQL Server? – Querychat
In this article, we will cover how decimal digits are defined in SQL Server, basic knowledge from how it works, and identifying how to count decimal places with a simplified example. When we talk about decimal digits, these are defined as all the numbers that are to the right side...
How to move System Databases? – Querychat
In this article, we will cover how to move system databases in SQL Server, identifying the necessary steps to do it, with a basic example, for better understanding. There are several reasons why we would consider moving a system database, like the following: Relocating system databases for disk maintenance or...
Importing XML into MySQL – Querychat
In this article, we will cover the basics of how to import XML into MySQL by using the LOAD XML statement, including examples for better understanding. LOAD XML statement The LOAD XML statement takes the data that is allocated in an XML file and loads it to a MySQL table....
1 2 12 13