Month: March 2010

Here’s my problem.  I’m making the following SQL call from my application: select a.*, b.* from foo a, bar b where a.[column]= b.[column] I don’t know on the application end what fields are in what table, and I don’t know what field the join will be on — that’s all dynamic. I need to know…

SELECT CONCAT(TABLE_NAME,’.’,COLUMN_NAME) FROM information_schema.COLUMNS where TABLE_SCHEMA=’foo’ and TABLE_NAME like ‘USER%’

I’ve been thinking about the Texas School Board flap, and I’ve decided that

double click on a word to highlight it.  Shift+F3 capitalizes the first letter.  Shift+F3 again capitalizes the whole word.  Shift+F3 a third time lower cases the word.  Probably should make a macro for this in Intellij…