Skip to content

Instantly share code, notes, and snippets.

@nekoya

nekoya/sqlite.md

Created February 15, 2013 06:40
Show Gist options
  • Save nekoya/4958865 to your computer and use it in GitHub Desktop.
Save nekoya/4958865 to your computer and use it in GitHub Desktop.
Download ZIP
sqlite <-> mysql
Raw
sqlite.md

sqliteでどうすればmysqlの〇〇が出来るのか

show tables

.tables

desc {table}

.schema {table}

テーブル指定しないと、全テーブルのスキーマを表示する

その他

.help

各コマンドは省略可能なので、.heとか.taとかもOK

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