mysql column lists for inserts updates etc.

mysqlColumnLists.sql

set @schema = 'base_sms';
set @table = 'bayprofiles';

-- column name list
select concat('`',COLUMN_NAME,'`,') as columnName from information_schema.COLUMNS where TABLE_SCHEMA=@schema and TABLE_NAME=@table;
/*
`id`,
`profileId`,
`bayWidth`,
`bcolumn`,
*/

-- table param list 
select concat('@',COLUMN_NAME,',') as paramName from information_schema.COLUMNS where TABLE_SCHEMA=@schema and TABLE_NAME=@table;
/*
@id,
@profileId,
@bayWidth,
@bcolumn,
...  
*/

-- update list 
select concat('`',COLUMN_NAME, '` = @',COLUMN_NAME,',') as updateStmt from information_schema.COLUMNS where TABLE_SCHEMA=@schema and TABLE_NAME=@table;
/*
`id` = @id,
`profileId` = @profileId,
`bayWidth` = @bayWidth,
`bcolumn` = @bcolumn,
*/