« first day (3077 days earlier)      last day (2086 days later) » 

Andriy M
Andriy M
07:32
@JackDouglas Maybe he meant something like this.
Morning
 
1 hour later…
ypercubeᵀᴹ
ypercubeᵀᴹ
08:53
Andriy I Don, 't think that mysql.tables is a proper table.
Andriy M
Andriy M
@ypercubeᵀᴹ You are probably right, I have no idea :) Was just trying to reproduce the issue
Jack Douglas
Jack Douglas
@AndriyM thanks I learnt something from that :)
ypercubeᵀᴹ
ypercubeᵀᴹ
09:41
morning
@AndriyM no problem. I wasn't sure either. dev.mysql.com/doc/refman/5.7/en/system-schema.html
This works however (I did not expect that!): dbfiddle.uk/…
Andriy M
Andriy M
Interestingly, it shows something entirely different in version 8: dbfiddle.uk/…
ypercubeᵀᴹ
ypercubeᵀᴹ
09:59
Ah nice. So it has become a view in 8.0
And there is a mysql.tables as well in that version
Andriy M
Andriy M
Yes, that's actually how I got to trying SHOW on mysql.tables in the first place
I didn't know about its existence before that
ypercubeᵀᴹ
ypercubeᵀᴹ
> Data dictionary tables are invisible. They cannot be read with SELECT, do not appear in the output of SHOW TABLES, are not listed in the INFORMATION_SCHEMA.TABLES table, and so forth.
> However, in most cases there are corresponding INFORMATION_SCHEMA tables that can be queried. Conceptually, the INFORMATION_SCHEMA provides a view through which MySQL exposes data dictionary metadata.
Yeah, Data Dictionary Tables is an addition / change in 8.0
Unclear, voted to close: dba.stackexchange.com/questions/240115/…
 
3 hours later…
Paul White
Paul White
13:37
morning
Sami
Sami
14:08
Afternoon
Sami
Sami
14:24
Try to run SSMS with the -log parameter and see the error. eg: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" -log D:\log.txt — Sami 1 hour ago

« first day (3077 days earlier)      last day (2086 days later) »