Category Archives: mysqli

MySQLi – Insert Query To insert data into a MySQL table, you would need to use the SQL INSERT INTO command. You can insert data into the MySQL table by using the mysql> prompt or by using any script like PHP. Syntax Here is a generic SQL syntax of INSERT INTO command to insert data […]

MySQLi – Drop Table It is very easy to drop an existing MySQL table, but you need to be very careful while deleting any existing table because the data lost will not be recovered after deleting a table. Syntax Here is a generic SQL syntax to drop a MySQL table − DROP TABLE table_name ; […]

MySQLi – Drop Database Drop a Database using mysqladmin You would need special privileges to create or to delete a MySQL database. So, assuming you have access to the root user, you can create any database using the mysql mysqladmin binary. Be careful while deleting any database because you will lose your all the data […]