List MySQL Views
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"sql
SQL query results into CSV file
You must have fired those select statements tons of times. So you hit a query, get your results and you are done. But what if the next day you felt like going through the results you found the other day. Simple..hit the query again. But what if the query was complex and you need the […]
Read more "SQL query results into CSV file"MySQL – Dump those tables
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"Letz Talk Ruby and Rails
This is about Ruby and of course Rails. So lets get onto Ruby on Rails wagon. These are some things that I keep using these days: To check for empty file field: @image = Image.create params[:image] unless params[:image][:file_data].kind_of? StringIO here params[:image][:file_data] is the hash for image to be loaded. If the file field is blank, […]
Read more "Letz Talk Ruby and Rails"