In case you wanted to list all views in your database, you could use the following mysql statement SHOW FULL TABLES WHERE Table_type = ‘VIEW’Read more "List MySQL Views"
Databases are all about saving data. With DBMS and RDBMS, the entire data became relational and all the records became related to each other as in the real world. So came into existence the concepts of primary keys, foreign keys, foreign key constraints and whole bunch of other terms like composite keys, referential integrity, indexes […]Read more "MySQL – Temporarily disable Foreign Key Checks or Constraints"
With the new face of Rails (Rails 2.1 and beyond), came the change in the way migrations used to work. So lets see some of the changes that went into migrations (that is when Rails was 1.2.3)… the then and now changes … First of all, serial numbers for migrations are gone and they have […]Read more "Migrations: Did they mature with Rails 2.1.#"
So how do you take backup of your MySQL database? Simple, launch SQLYog or HeidiSQL and export your database. Well its an easy solution on Windows. How would you go about it on Linux or simply put how wud you do it on command prompt. The answer is mysqldump. Its there on your system once […]Read more "MySQL – Dump those tables"