# Create table

CREATE TABLE items (
	id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100)
);

# Demo data

INSERT INTO items(name)
VALUES ('aaa'), ('bbb'), ('ccc'), ('ddd');

# New query, select

select-items

SELECT * from items;

# Base64 encode auth

https://www.base64encode.com/

username:password


# Insomnia

http://martha.jh.shawinigan.info/queries/select-items/execute

add auth header

# New query, insert

insert-item

INSERT INTO items(name) VALUES ("?name");

Aller dans query detail pour demo payload test
{"name": "new item"}

# Insomnia, suite

Dupliquer select request

http://martha.jh.shawinigan.info/queries/insert-item/execute

Body JSON payload
{"name": "new item insomnia"}

Montrer le API Requests log