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…