Select all POS settings for documentation

set group_concat_max_len = 10000000;
set @branchid = (select ´value´ from config where particular = 'branchid' limit 1);
set @terminalno = (select ´value´ from config where particular = 'terminalno' limit 1);
set @schema_ = 'nelsoft_retail';

SET @column_names = (select group_concat(concat('concat("',column_name,':",','´',´column_name´,'´)'))
	from information_schema.columns
	where ´table_schema´ = @schema_ and ´table_name´ = 'possettings' );

set @stmt = concat('select concat_ws("\r",',@column_names,')
	as "cls" from possettings
	where ´branchid´ = ? and ´terminal´ = ?');

PREPARE stmt1 FROM @stmt;
EXECUTE stmt1 using @branchid, @terminalno;
DEALLOCATE PREPARE stmt1;


SET @column_names = (select group_concat(concat('concat("',column_name,':",','´',´column_name´,'´)'))
	from information_schema.columns
	where ´table_schema´ = @schema_ and ´table_name´ = 'terminal' );

set @stmt = concat('select concat_ws("\r",',@column_names,')
	as "cls" from terminal
	where ´branchid´ = ? and ´terminalno´ = ?');

PREPARE stmt1 FROM @stmt;
EXECUTE stmt1 using @branchid, @terminalno;
DEALLOCATE PREPARE stmt1;