SELECT CONCAT(  'public static final String ', COLUMN_NAME,  ' = "', COLUMN_NAME,  '";' ) AS column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema =  'paattitesti'
ORDER BY table_name ASC

SELECT CONCAT(  'public static final String ', TABLE_NAME,  ' = "', TABLE_NAME,  '";' ) AS table_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema =  'paattitesti'
ORDER BY table_name ASC