1-1. 원격 접속을 종료하더라도 서버가 계속 돌아가게 하기nohup python app.py &1-2. 서버 종료하기 - 강제종료하는 방법ps -ef | grep 'python app.py' | awk '{print $2}' | xargs kill2-1. EC2 서버
app.py-----from flask import Flask, render_template, request, jsonifyapp = Flask(name)from pymongo import MongoClientclient = MongoClient('mongodb+srv
doc = {'name':'bobby','age':21}db.users.insert_one(doc)user = db.users.find_one({'name':'bobby'})all_users = list(db.users.find({},{'\_id':False}))db.
단축키 모음새로고침F5저장Windows: Ctrl + S전체선택Windows: Ctrl + A잘라내기Windows: Ctrl + X콘솔창 줄바꿈shift + enter코드정렬Windows: Ctrl + Alt + L들여쓰기Tab들여쓰기 취소 : Shift + Tab주석
SELECT u.user_id , u.email , SUBSTRING_INDEX(email, '@',-1)FROM users u ;SELECT o.order_no , o.created_at, SUBSTRING(o.created
SELECT pu.user_id , pu.point , ( CASE when pu.point > 10000 then '잘 하고 있어요!' ELSE '조금난 더 파이팅!' END) as msg FROM point_users pu
select co.title, a.course_id, a.cnt_checkins, b.cnt_total, round(a.cnt_checkins/b.cnt_total,3) as ratiofrom ( se
SELECT \* FROM checkins c limit 10;select count(\*) from checkins;SELECT week, count(\*) FROM checkins c group by week ;SELECT \*
select co.title, a.course_id, a.cnt_checkins, b.cnt_total, round(a.cnt_checkins/b.cnt_total,3) as ratiofrom ( se
SELECT \* FROM users u group by name ; 이\*\* abc3b3@hanmail.comselect name, count(\*) from users group by name ;SELECT payment_metho
SELECT FROM users u left join point_users pu on u.user_id = pu.user_id ;SELECT FROM users u inner join point_users pu on u.user_id = pu.
select from orders where payment_method = 'kakaopay';select from point_users where point >= 5000;select from orders where course_
1) show tables로 어떤 테이블이 있는지 살펴보기2) 제일 원하는 정보가 있을 것 같은 테이블에 select \* from 테이블명 limit 10 쿼리 날려보기3) 원하는 정보가 없으면 다른 테이블에도 2)를 해보기4) 테이블을 찾았다! 범주를 나눠서
tables 살펴보기;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;show tables;SELECT \* FROM orders o ;SELECT order_no ,created_at ,course