SELECT column_name, data_type --SELECT CONCAT(column_name, ',') FROM information_schema.columns WHERE table_name = 'foo' ORDER BY ordinal_position;
SELECT column_name, data_type --SELECT CONCAT(column_name, ',') FROM information_schema.columns WHERE table_name = 'foo' ORDER BY ordinal_position;