Skip to content

Latest commit

 

History

History
150 lines (123 loc) · 3.18 KB

README.md

File metadata and controls

150 lines (123 loc) · 3.18 KB

How to use MySQL App

Authentication

For the authentication you will need:

  • server;
  • username;
  • password;
  • database.

Note:

If you want to use authentication to create databases only, leave the database field empty.

You can set a dynamic value for the authentication fields by manually insert it. For example in the database field: $exec.database

Actions

Create Database

Create a new database. If you want you can also create one or more tables. Fields:

  • name;
  • tables.

Tables field example: Insert the table name and the query.

{
    "employees": "CREATE TABLE `employees` (`emp_no` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(14) NOT NULL,  `last_name` varchar(16) NOT NULL,  PRIMARY KEY (`emp_no`)) ENGINE=InnoDB",
    "departments": "CREATE TABLE `departments` (`dept_no` char(4) NOT NULL, `dept_name` varchar(40) NOT NULL, PRIMARY KEY (`dept_no`), UNIQUE KEY `dept_name` (`dept_name`)) ENGINE=InnoDB"
}

Create Tables

Create one or more tables. Fields:

  • tables.

Tables field example: Insert the table name and the query.

{
    "employees": "CREATE TABLE `employees` (`emp_no` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(14) NOT NULL,  `last_name` varchar(16) NOT NULL,  PRIMARY KEY (`emp_no`)) ENGINE=InnoDB",
    "departments": "CREATE TABLE `departments` (`dept_no` char(4) NOT NULL, `dept_name` varchar(40) NOT NULL, PRIMARY KEY (`dept_no`), UNIQUE KEY `dept_name` (`dept_name`)) ENGINE=InnoDB"
}

Insert Data

Insert data into mysql table.

Fields:

  • table;
  • data.

Data field example: MySQL field data in JSON format, it can be a list or not.

[{
    "title": "New Function1",
    "text": "testing",
    "time": 1617032159000
},
{
    "title": "New Function2",
    "text": "testing",
    "time": 1617032159000
}]

Query Data

Query the data inside a table.

Fields:

  • table;
  • fields;
  • condition.

Fields example: Table fields to be return.

username, fname, lname, age

Condition example: Query condition text after a WHERE clause.

age=23 and gender='M'

Update data

update data inside the table Fields:

  • table;
  • fields;
  • condition.
  • data fields.

Fields example: Table fields to be return.

["first_name","last_name"]

Condition example: Query condition text after a WHERE clause.

emp_no=1

Data Fields example: Table fields value to be updated.

["jaydeep","kotak"]

Delete data

delete data inside the table Fields:

  • table;
  • condition
  • fields;(optional)

Condition example: Query condition text after a WHERE clause.

emp_no = 1

Data Fields example: Table fields value to be deleted.

["jaydeep","kotak"]

Join Query

join two or more table and display data Fields:

  • type;
  • fields.

Fields example: Table fields to be return.


SELECT * from employees INNER JOIN departments ON employees.emp_no = departments.emp_no

Upcoming

  • Improve the tables field to be needed just to insert the table name once in the json as key, and for the value the table fields syntax.