MySQL insert statement

Question

I have a MySQL beginner question. I populated my database through the EER diagram, meaning that I created my tables on the EER diagram, and populated them with imported Excel files.

Once I'm on the server, I created the tables by using "Copy SQL to Clipboard". Since I'm not populating it manually row by row on the server, my question is how do I create a script file which lists all the statements that populated my database?

Possible duplicate of [How to export a mysql database using Command Prompt?](https://stackoverflow.com/questions/3031412/how-to-export-a-mysql-database-using-command-prompt) — Matt S, Apr 15 '18 at 16:08

score 0 · Answer 1 · edited Apr 06 '20 at 09:37

0

For each table use a statement like this:

INSERT INTO tbl_name
   (firstName,lastName,Age)
VALUES
    ("John","Smith",93)

You can repeat the entries under VALUES if you wish to insert multiple rows, e.g:

VALUES
    ("Basil","Smith",42),
    ("Day","Crockett",232)

edited Apr 06 '20 at 09:37

halfer

19,824
17
99
186

answered Apr 15 '18 at 17:26

Aethelbald

232
1
7

MySQL insert statement

1 Answers1