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_ […]
Author Archives: user
MariaDB – Create Database Creation or deletion of databases in MariaDB requires privileges typically only given to root users or admins. Under these accounts, you have two options for creating a database − the mysqladmin binary and a PHP script. mysqladmin binary The following example demonstrates the use of the mysqladmin binary in creating a […]
MariaDB – Drop Database Creation or deletion of databases in MariaDB requires privileges, typically, only given to root users or admins. Under these accounts, you have two options for deleting a database: the mysqladmin binary and a PHP script. Note that deleted databases are irrecoverable, so exercise care in performing this operation. Furthermore, PHP scripts […]