Author: admin
-
Perl Conditional Statements – IF…ELSE
Perl conditional statements helps in the decision making, which require that the programmer specifies one or more conditions to be evaluated or tested by the program, along with a statement or statements to be executed if the condition is determined to be true, and optionally, other statements to be executed if the condition is determined…
-
Node.js MySQL Update Records
The UPDATE command is used to update records in the table. Example Update city in “employees” table where id is 1. Create a js file named “update” in DBexample folder and put the following data into it:PlayNextMute Current Time 0:08 / Duration 18:10 Loaded: 4.40%  Fullscreen Now open command terminal and run the following command: It will change the…
-
Hashes
A hash is a set of key/value pairs. Hash variables are preceded by a percent (%) sign. To refer to a single element of a hash, you will use the hash variable name preceded by a “$” sign and followed by the “key” associated with the value in curly brackets.. Here is a simple example of using…
-
Node.js MySQL Insert Records
INSERT INTO statement is used to insert records in MySQL. Example Insert Single Record: Insert records in “employees” table.PlayNextMute Current Time 0:02 / Duration 18:10 Loaded: 3.30%  Fullscreen Create a js file named “insert” in DBexample folder and put the following data into it: Now open command terminal and run the following command: Check the inserted record by…
-
Node.js MySQL Create Table
CREATE TABLE command is used to create a table in MySQL. You must make it sure that you define the name of the database when you create the connection. Example For creating a table named “employees”. Create a js file named employees.js having the following data in DBexample folder.PlayNextMute Current Time 0:02 / Duration 18:10 Loaded: 3.30%  Fullscreen…
-
Node.js MySQL Create Database
CREATE DATABASE statement is used to create a database in MySQL. Example For creating a database named “”. Create a js file named javatpoint.js having the following data in DBexample folder.PauseNextMute Current Time 0:05 / Duration 18:10 Loaded: 4.04%  Fullscreen Now open command terminal and run the following command: You can see the database is created. Verification To…
-
Arrays
An array is a variable that stores an ordered list of scalar values. Array variables are preceded by an “at” (@) sign. To refer to a single element of an array, you will use the dollar sign ($) with the variable name followed by the index of the element in square brackets. Here is a…
-
Node.Js Create Connection with MySQL
We can use Node.js in database applications. Here we use MySQL as a database with Node.js. Install MySQL on your computer. You can download it from here https://www.mysql.com/downloads/. Once the MySQL is installed and running, you can access it by using Node.js. Install MySQL Driver You have to install MySQL driver to access a MySQL database…
-
NestJS
Welcome to the tutorial of NestJS. This tutorial is solely intended to make you gain absolute knowledge of NestJS. You would be learning about it from a beginner level covering all the tiny staircases that will push you into installation, creating a new application from NestJS from scratch, and learn how to handle and implement in…
-
Scalars
A scalar is a single unit of data. That data might be an integer number, floating point, a character, a string, a paragraph, or an entire web page. Here is a simple example of using scalar variables − This will produce the following result − Numeric Scalars A scalar is most often either a number…