/
MySQL CRUD

MySQL CRUD

Apr 27, 2017

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

Assumptions:

  1. vutil is installed.

  2. MySQL 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:

CRUD Operations:

  1. Insert Query
    Insert query can be specified as shown in the following screenshot:

     

  2. Select Query
    Select query can be specified as shown in the following screenshot:

  3. Update Query
    Update query can be specified as shown in the following screenshot: 

     

  4. Delete Query
    Delete query can be specified as shown in the following screenshot: