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.

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

Support for MySQL #22

Closed
ernstc opened this issue Jan 11, 2024 · 1 comment
Closed

Support for MySQL #22

ernstc opened this issue Jan 11, 2024 · 1 comment
Assignees
Labels
enhancement New feature or request

Comments

@ernstc
Copy link
Owner

ernstc commented Jan 11, 2024

Data inspector should be available also for MySQL databases.

The analysis of the extension below can be useful for the implementation of this feature:
https://github.com/microsoft/azuredatastudio-mysql

@ernstc ernstc added the enhancement New feature or request label Jan 11, 2024
@ernstc
Copy link
Owner Author

ernstc commented Apr 2, 2024

Queries for retrieving metadata about schemas, tables and columns.

-- Get the list of schemas
SELECT * FROM information_schema.schemata;

-- Get the list of tables
SELECT * FROM information_schema.tables WHERE table_schema = 'mydb';

-- Get the list of columns
SELECT * FROM information_schema.columns WHERE table_schema = 'mydb' AND table_name = 'test';

-- Get the list of table columns with their data types and primary keys
SELECT 
    ordinal_position, 
    column_name, 
    data_type, 
    character_maximum_length, 
    is_nullable, 
    column_key 
FROM 
    information_schema.columns 
WHERE 
    table_schema = 'mydb' AND table_name = 'test';

@ernstc ernstc self-assigned this Apr 11, 2024
@ernstc ernstc closed this as completed Aug 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant