CREATE DATABASE nodejs
CREATE TABLE member (
id VARCHAR(20),
pw VARCHAR(20),
);
npm install mysql
const mysql = require("mysql");
const conn = {
host: "127.0.0.1",
port: "3306",
user: "사용자 ID",
password: "사용자 PW",
database: "nodejs",
};
let connection = mysql.createConnection(conn);
connection.connect();
...
var sql = "INSERT INTO member VALUES (" + id + ", " + pw + ")";
connection.query(sql, function (err, result, field) {
if (err) {
console.log(err);
}
});
connection.end();