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, […]
Category Archives: mariadb
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. […]
MariaDB – Delete Query The DELETE command deletes table rows from the specified table, and returns the quantity deleted. Access the quantity deleted with the ROW_COUNT() function. A WHERE clause specifies rows, and in its absence, all rows are deleted. A LIMIT clause controls the number of rows deleted. In a DELETE statement for multiple […]