DROP TABLE tablename; DROP command is used for deleting the table and its structure from the data base.Use this command when you don’t need that table any more. Other Spec: 1. Removes a table from the database.Table structures, indexes, privileges, constraints will also be removed. 2. Cannot be rolled back. 3. No Triggers can…
ACID(Atomicity Consistency Isolation Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. Atomicity Atomicity is an all-or-none proposition. Modifications on the data in the database either fail or succeed. Each transaction is said…
If your databases are located on same MySQL server.You don’t need two connections, you can access them both as unique user. You also don’t need to select a DB. Just use the database-name as prefix when specifying the tables. That’s it. Or if you want to select database, you can do Please note there can…
PHP: Backup Your Website’s MySQL Database It is always good to backup your MySQL database regularly. You should also create a backup before making any major changes, in case something goes wrong and you need to revert to the unmodified version, then you will found yourself in safe hand. Database backups can also be…
Turning or convert MySQL data latin1 to utf8 The default character set for MySQL is latin1 (As of PHP 5.6.0, default_charset value is used as the default. From PHP 5.4.0, UTF-8 was the default, but prior to PHP 5.4.0, ISO-8859-1 was used as the default. It’s therefore a good idea to always explicitly specify…
Delete all duplicate rows except for one in MySql having no primary key. Someone asked me to delete all rows from a table except one entry with a single query. This is not so easy for me :), Anyway after work and research I have found the solution, I am sharing with you How you can…
