Describe a table

sql

DESCRIBE users;

Explanation

`DESC users;` is a common shorthand.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing mysql client basics

Open an interactive mysql session.

Open In sheetbashsame section

Specify the host, port, user, and prompt for a password.

Open In sheetbashsame section

Open mysql and select the target schema immediately.

Open In sheetbashsame section

Execute a SQL statement non-interactively.

Open In sheetbashsame section

Display all databases visible to the current account.

Open In sheetsqlsame section

Set the active database for subsequent statements.

Open In sheetsqlsame section