MariaDB – Indexes & Statistics Tables Indexes are tools for accelerating record retrieval. An index spawns an entry for each value within an indexed column. There are four types of indexes − Primary (one record represents all records) Unique (one record represents multiple records) Plain Full-Text (permits many options in text searches). The terms “key” […]
Category Archives: mariadb
MariaDB – Alter Command The ALTER command provides a way to change an existing table”s structure, meaning modifications like removing or adding columns, modifying indices, changing data types, or changing names. ALTER also waits to apply changes when a metadata lock is active. Using ALTER to Modify Columns ALTER paired with DROP removes an existing […]
MariaDB – Create Tables In this chapter, we will learn how to create tables. Before creating a table, first determine its name, field names, and field definitions. Following is the general syntax for table creation − CREATE TABLE table_name (column_name column_type); Review the command applied to creating a table in the PRODUCTS database − databaseproducts_ […]