Nodejs MySQL Insert Records

Node.js MySQL Insert Records

A record can be inserted into MySQL Table simply by using “INSERT INTO” statement.

Example :- Let’s insert a record in  “employees” table under “nodemysql” database.

Step 1:-  Let’s, create a node_mysql_insert_tbl.js file and put the following code in it –

Step 2:- Save the code and open the terminal again, and type the following command in order to run the file.

you will see following output on terminal –

Node.js MySQL Insert Records 1

Node.js MySQL Insert Records 1

Node.js MySQL Insert Records 2

Node.js MySQL Insert Records 2

Insert Multiple Records

Step 1:-  Let’s, create a node_mysql_multi_insert_tbl.js file and put the following code in it –

Step 2:- Save the code and open the terminal again, and type the following command in order to run the file.

you will see following output on terminal –

Node.js MySQL Insert Records 3

Node.js MySQL Insert Records 3

Node.js MySQL Insert Records 4

Node.js MySQL Insert Records 4