Make sure you have setup a basic express application.
First create a Mysql Workbench Table
open mysql workbench, follow these steps:
- Create a New Schema
- Create a Table
- Create Fields (fields, datatype, nn, pk, ai) (nn-not null, ai-auto increase)
- Right click the table and select all rows
- Fill the data
Install MYSQL2
npm install mysql2
Create the Connection
const mysql=require('mysql')
const db = mysql.createConnection({
host: 'localhost',
user: 'myuser',
password: 'mypassword',
database: 'mydatabase'
})Make a GET Request (fetch data)
app.get("/api/product", (req, res)=>{
const q = "SELECT * FROM product"
db.query(q, (err, data)=>{
if(err) res.json(err)
return res.json(data)
})
})— Download Postman
First download the Postman App, its very helpful for REST API.
Now open the localhost url and send a GET request.
Now it’s time for sending a POST request.
Send a POST Request (Create a New Data)
app.post('/product', (req, res) => {
const query = `
INSERT INTO product
(product_name, small_des, big_des)
VALUES (?)
`;
const values = ['pineapple', 'mango', 'watermelon'];
db.query(query, [values], (err, data) => {
if (err) return res.json(err);
return res.json(data);
});
});
