Tag Archives for sql

How can i populate database tables from excel spreadsheet

Recently i got a excel spreadsheet document with a couple of thousand records which needed to be put into the database, I use MySQL so i had to prepare equal number of insert queries for the number of records in the excel … Continue reading

14. April 2013 by Anand
Categories: Databases, Languages, MySQL, SQL | Tags: , , , , , | Leave a comment

How do i use joins in sql ?

For those who think SQL joins are tough. Just go through this once and i bet you cannot forget it again. Courtesy:  C.L.Moffett, 2008

20. September 2012 by Anand
Categories: Databases, Languages, MySQL, SQL | Tags: , , , , , | Leave a comment