Versions Compared

Old Version 1

changes.mady.by.user Dheeraj Kumar Aggarwal

Saved on

compared with

New Version Current

changes.mady.by.user Dheeraj Kumar Aggarwal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this post, we will look at, how we can perform CRUD operation on MySQL MSSQL Database.

Assumptions:

  1. vutil is installed.
  2. MySQL MSSQL connection is configured in the config.json file in vutil directory.

First create a test case which will fire a HTTP request on vutil server to validate the database state:

Image RemovedImage Added

CRUD Operations:

  1. Insert Query
    Insert query can be specified as shown in the following screenshot:
    Image Removed Image Added
  2. Select Query
    Select query can be specified as shown in the following screenshot:
    Image RemovedImage Added
  3. Update Query
    Update query can be specified as shown in the following screenshot: 
    Image Removed Image Added
  4. Delete Query
    Delete query can be specified as shown in the following screenshot:
    Image RemovedImage Added