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_ […]
Category Archives: mariadb
MariaDB – Insert Query In this chapter, we will learn how to insert data in a table. Inserting data into a table requires the INSERT command. The general syntax of the command is INSERT followed by the table name, fields, and values. Review its general syntax given below − INSERT INTO tablename (field,field2,…) VALUES (value, […]
MariaDB – Drop Tables In this chapter, we will learn to delete tables. Table deletion is very easy, but remember all deleted tables are irrecoverable. The general syntax for table deletion is as follows − DROP TABLE table_name ; Two options exist for performing a table drop: use the command prompt or a PHP script. […]