This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
Like the title says, how in SQL, can I see if a column exists? If I know 'tableA' exists, I can do: SHOW COLUMNS FROM 'tableA' - but how can I see if there is a column named 'columnA' ? The following does not work: SELECT COUNT(Field) FROM 'tableA' WHERE Field = 'columnA' IN (SHOW COLUMNS FROM `tableA`);