1021 SeSAC(새싹) 3기 34일차

mysql => 데이터베이스의 하나

ORM

select
update
delete
insert

nodejs ORM

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '내가원하는비번';

mysql
아이디 : root
비번 : qa2213886*

mysql -u root -p #mysql 들어가는 명령어

var express = require('express');
var app = express();
var mysql = require( 'mysql' );

var conn = mysql.createConnection({
	user: 'root',
	password: 'qa2213886*',
	database: 'ssac'
});

app.listen( 9999, function () {
	conn.connect( ( err ) => {
		if ( err ) console.log( err );
		else console.log( "DB connected successfully!" );
    });

	// var sql = "INSERT INTO member VALUES('tom', '톰', '2021-10-21' );"
	
	// conn.query(sql, function(err) {
    //     if( err ){
	// 		console.log( 'failed!! : ' + err );
	// 	}
	// 	else {
	// 		console.log( "data inserted!" );
	// 	}
    // });
});

app.get( '/test', ( req, res ) => {
	var sql = "SELECT * FROM member";
	
	conn.query( sql, function( err, results ){
		res.render( 'test', { results: results } );
	});
});