We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
It's a table that's built into MySQL, the user doesn't create it. The purpose of it is to show information about each table in your current database. It's especially useful if you are creating tables or exploring a database for the first time to get a feel for what tables are in it. (see the image below for what information_schema.tables looks like in a database).
For this question however, the information_schema.tables is only being used as a dummy table to output the query.
Draw The Triangle 1
You are viewing a single comment's thread. Return to all comments →
It's a table that's built into MySQL, the user doesn't create it. The purpose of it is to show information about each table in your current database. It's especially useful if you are creating tables or exploring a database for the first time to get a feel for what tables are in it. (see the image below for what information_schema.tables looks like in a database).
For this question however, the information_schema.tables is only being used as a dummy table to output the query.
Source: https://www.mssqltips.com/sqlservertutorial/196/informationschematables/