mysql

Alpine Linux | Docker | S3CMD | Go | System | Security | MySQL | InfluxDB

• See all the views in a database

SHOW FULL TABLES IN _database_name_ WHERE TABLE_TYPE LIKE 'VIEW';

• Create an index

CREATE INDEX <index_name> ON <table_name>(<column_name>);