Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

can't find TableId from INFORMATION_SCHEMA.TABLES. #30

Closed
supersdar opened this issue Nov 15, 2023 · 2 comments
Closed

can't find TableId from INFORMATION_SCHEMA.TABLES. #30

supersdar opened this issue Nov 15, 2023 · 2 comments

Comments

@supersdar
Copy link

hi,How to use TableId to find the corresponding table name?
@rusuly
Copy link
Owner

rusuly commented Nov 16, 2023

Hi, it looks like INFORMATION_SCHEMA.TABLES is a view and doesn't have table_id.
Instead, try querying INFORMATION_SCHEMA.INNODB_TABLES table like:

SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE TABLE_ID = 100

@rusuly
Copy link
Owner

rusuly commented Nov 17, 2023

Also TableName with TableId is included in the TableMapEvent event that precedes any WriteRowsEvent, UpdateRowsEvent or DeleteRowsEvent events.

@rusuly rusuly closed this as completed Nov 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@supersdar @rusuly