📚Cheatsheets

Cheatsheet collection for go, rust, python, shell and javascript.

Show table Schema in MySQL

The query to get the schema of a table in MySQL is:

SHOW CREATE TABLE table_name;

table_name should be replaced with the actual name of the table whose schema you want to retrieve.

This query will return the CREATE TABLE statement that was used to create the table, which will include the names and data types of all of the columns in the table, as well as any constraints and indexes that have been defined on the table.