jm_p_op

orders & point_users same colums with table1 as (select column_name from information_schema.columns where table_name = 'orders'), table2 as (select column_name from information_schema.columns where table_name = 'point_users') select t1.column_name as '중복 테이블' from table1 t1 inner join table2 t2 on t1.column_name = t2.column_name;

/*주석*/ 실행 : Ctrl + Enter 문법 종료 : ; table 열기 : show table; order 열기 : select * from orders; order의 columns 열기 : (orders안에 order_no, created_at, user_id,email 보) select order_no, created_at, user_id, email from orders; order 조건부 열기 : select * from orders where course_title ='앱개발 종합반' 조건부 연결과 같지 않다: and payment_method !='card' 조건부 사이값: and created_at BETWEEN '2022-07-13' and '2020-01-15'; 조건부 선택적 일..