Edit MySQL Trigger in Workbench problem

2013-07-09 Thread Neil Tompkins
Hi, I've created a Trigger and want to edit it. Using MySQL Workbench, I can Alter the table, and click Triggers and select the trigger action I want to edit (on my local database, MySQL running on same PC) However, if I try the exact same procedure on a Trigger on a remote database, I don't

RE: Need query to determine different column definitions across tables

2013-07-09 Thread Rick James
Another flavor to try: SELECT COLUMN_NAME, group_concat(db_tbl SEPARATOR ' ') as db_tbls, group_concat(DISTINCT info SEPARATOR ' | ') as infos FROM ( SELECT COLUMN_NAME, concat(TABLE_SCHEMA, '.', TABLE_NAME) as db_tbl,