Nodejs MySQL Select Records

Node.js MySQL Select Records

Records can be selected from MySQL Table simply by using “SELECT” statement.

Example :- Let’s select all records from  “employees” table under “nodemysql” database.

Step 1:-  Let’s, create a node_mysql_select_all.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 Select Records 1

Node.js MySQL Select Records 1

Node.js MySQL Select With Where

Example :- Let’s select a record from  “employees” table “emp_name” is “Keith”.

Step 1:-  Let’s, create a node_mysql_select_single.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 Select Records 2

Node.js MySQL Select Records 2