Skip to content

Instantly share code, notes, and snippets.

@davidgg

davidgg/mysql-helpful-commands.md

Created February 28, 2019 10:16
Show Gist options
  • Save davidgg/7c8b4fd33e6508ec60d6200f549bf4e0 to your computer and use it in GitHub Desktop.
Save davidgg/7c8b4fd33e6508ec60d6200f549bf4e0 to your computer and use it in GitHub Desktop.
Download ZIP
MySql commands
Raw
mysql-helpful-commands.md

MySql Helpful Commands

Connect

mysql -u [username] -p;

Show all databases

show databases;

Use database

use [database];

Show all tables

show tables;

Show table structure

describe [table];

List users

SELECT User,Host FROM mysql.user;

source: https://gist.github.com/hofmannsven/9164408

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment