Skip to content

Instantly share code, notes, and snippets.

@keyama4
Last active July 24, 2016 17:56
Show Gist options
  • Select an option

  • Save keyama4/7d489a307cdb442d163793ec19a1eda9 to your computer and use it in GitHub Desktop.

Select an option

Save keyama4/7d489a307cdb442d163793ec19a1eda9 to your computer and use it in GitHub Desktop.
MySQL基本操作まとめ ref: http://qiita.com/keyama4/items/d0ad6e5dbbdb23ae1aea
$ mysql -u [ユーザー名] -p [パスワード];
mysql> SHOW CREATE TABLE [テーブル名];
mysql> SHOW DATABASES;
mysql> CREATE DATABASE データベース名;
mysql> DROP DATABASE [データベース名];
mysql> USE [データベース名];
mysql> SELECT DATABASE();
mysql> SHOW TABLES;
mysql> SHOW TABLES FROM [データベース名];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment