Blog Archives

What is Difference between MySQL delete and truncate table

This very common question in interviews.  Both remove records from the table, so what is the difference. Delete :                      Syntax :  Delete from TableName [where condition]; Deletes record  from table

Posted in Mysql

Location of mysql database files in Ubuntu

Location of mysql database files in Ubuntu: Taking backup in phpmyadmin is very easy… but when I want see where these tables stores that very interesting for me , after googling finaly got postion of database in Ubuntu… as… /var/lib/mysql

Posted in Mysql, Ubuntu