Author Archives: user

SQL – DROP Table Table of content SQL provides command to DROP an existing table completely in a database. Once SQL DROP command is issued then there is no way back to recover the table including its data, so be careful before issuing this command in production system. The SQL DROP Table Statement The SQL […]

SQL Backup Database Table of content In this SQL Backup Database tutorial, we will explain how we can take a backup of a database in and . It is very important and basic development practice to have a backup of the database in case the original is corrupted or lost due to power surges or […]

SQL – Rename Table Table of content SQL provides two ways to rename an MySQL table. You can use either SQL RENAME TABLE or ALTER TABLE statement to change a table name in MySQL RDBMS. The SQL RENAME TABLE Statement You can change a MySQL table name using SQL RENAME TABLE statement. Syntax Following is […]