CREATE TABLE `user` (
`id` int(11) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`lastname` varchar(255) DEFAULT NULL,
`gender` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- for npm libraries
npm install body-parser
npm install express
npm install mysql
npm install path
- for running server
node app.js