SQL Queries

To count number of columns in a Table
The INFORMATION_SCHEMA COLUMNS Table
Sntax :
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'tbl_name'
[AND table_schema = 'db_name']
[AND column_name LIKE 'wild']

SHOW COLUMNS
FROM tbl_name
[FROM db_name]
[LIKE 'wild']
Click here to see More From MySQL development site
Example:
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'mrc_tav'
AND table_schema = 'noon_test'
Click here to view Short List of MySQL Commands
To display all the table names in Database
Syntax:
SHOW TABLES [FROM database_name]

Latest Tamil new SONGS available here!!!!

Download the latest tamil movies songs from this below link asa soon as possible...

Tamilbeat.com

This link also will give you the latest tamil movie songs but not updated regularly like the link above..

Tamilmp3

JasperReports

Embeddable open source Java reporting library
JasperReports is the world's most widely used open source reporting engine.

Tips and Tricks
http://fecplanner.com/jasperreports/docs/tutorial/index.html

Download iReport from jasperforge
http://jasperforge.org/plugins/project/project_home.php?projectname=ireport
Articles on JasperReports

Reports made easy with JasperReports
http://www.javaworld.com/javaworld/jw-09-2002/jw-0920-opensourceprofile.html

Tutorial on Generating Reports and PDFs From a Web Application Using NetBeans5.5
http://netbeans.org/kb/55/vwp-reports.html

Basic Jasper-Report-Tutorial
http://www.docstoc.com/docs/2139263/Jasper-Report-Tutorial

To Browse Forums-Question and Answers
http://jasperforge.org/plugins/espforum/browse.php?group_id=102&forumid=103