cool tag line goes here...

SELECT c . column_name FROM INFORMATION_SCHEMA . COLUMNS c WHERE c . table_name = 'tbl_name' -- AND c.table_schema = 'db_name' ORDER BY c . column_name

select   TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where   REFERENCED_TABLE_NAME = 'table_name'

apachectl restart     or   /sbin/service httpd restart

select COLUMN_NAME as 'Field' , COLUMN_TYPE as 'Type' , IS_NULLABLE as 'Null' , COLUMN_KEY as 'Key' , COLUMN_DEFAULT as 'Default' , EXTRA as 'Extra' from INFORMATION_SCHEMA . COLUMNS where TABLE_NAME = 'table' and TABLE_SCHEMA = 'database' -- add ordering -- order by Type ;

select column_name, count(*) from table_name group by column_name order by count(*) desc;

RPM packages typically have file names like foo-1.0-1.i386.rpm . The file name includes the package name ( foo ), version ( 1.0 ), release ( 1 ), and architecture ( i386 ). To install a package, log in as root and type the following command at a shell prompt: rpm -Uvh foo-1.0-1.i386.rpm

netstat -tulpn