Go to Qiita Advent Calendar 2024 Top
LoginSignup
17
16

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

@yu_bookstore(勇)

MySQL Workbenchで、DDL文、INSERT文を生成

Posted at

DDL文を生成

  1. MySQL Workbenchで、データベースに接続
  2. Navigatorバーから、対象となるテーブルの名前を右クリック
  3. Table Inspectorをクリック
  4. 出てくる画面の中で、DDLタブをクリック

INSERT文を生成

  1. MySQL Workbenchで、データベースに接続
  2. Navigatorバーから、対象となるテーブルの名前を右クリック
  3. Select Rows - Limit 1000 をクリック
  4. メニューバー→Query→Export Resultsをクリック
  5. 好きなファイル名を入力
  6. ファイルの種類：SQL INSERT statementsを選択し、保存を押す
  7. Exportをクリック
17
16
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
17
16

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?