cool tag line goes here...

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('columnA','ColumnB') AND TABLE_SCHEMA='YourDatabase';

show tables like '%part_of_table_name%'

concat(ucase(left( column_name , 1)), substring( column_name , 2))

ALTER TABLE table_name AUTO_INCREMENT = value ;

Stop MySQL Server # /etc/init.d/mysqld stop Start MySQL Server # /etc/init.d/mysqld start Restart MySQL Server # /etc/init.d/mysqld restart

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'

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

select table_name     from information_schema.columns     where column_name in ('column1','column2')         and table_schema='yourdatabase';