[Koha-bugs] [Bug 26997] Database Mysql Version 8.0.22 failed to Update During Upgrade
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Feb 10 18:00:40 CET 2021
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26997
--- Comment #11 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
'''
SELECT col.table_schema AS database_name,
col.table_name,
col.ordinal_position AS column_id,
col.column_name,
col.data_type,
col.datetime_precision
FROM information_schema.columns col
JOIN information_schema.tables tab
ON tab.table_schema = col.table_schema
AND tab.table_name = col.table_name
AND tab.table_type = 'BASE TABLE'
WHERE col.data_type IN ( 'date', 'time', 'datetime', 'year', 'timestamp' )
AND col.table_schema NOT IN ( 'information_schema', 'sys',
'performance_schema',
'mysql' )
AND col.table_schema = 'database_name'
ORDER BY col.table_schema,
col.table_name,
col.ordinal_position;
'''
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list