SELECT CONCAT(  'public static final String ', COLUMN_NAME,  ' = "', COLUMN_NAME,  '";' ) AS column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema =  tietokannan nimi thn
ORDER BY table_name ASC
LIMIT 0 , 500

SELECT CONCAT(  'public static final String ', TABLE_NAME,  ' = "', TABLE_NAME,  '";' ) AS table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema =  tietokannan nimi thn
ORDER BY table_name ASC
LIMIT 0 , 500