This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori 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`);