Dev

1. 첫번째 방법 select name, count(name) from member where gaipday between date_format(now(), '%Y-%m-01') and date_format(now(), '%Y-%m-%d') and name='메뉴1' group by name; select 메뉴컬럼명, count(메뉴컬럼명) from 테이블명 where 날짜컬럼명 between date_format(now(), '%Y-%m-01') and date_format(now(), '%Y-%m-%d') and 메뉴컬럼명='메뉴1' group by 메뉴컬럼명; 1. 두번째 방법 SELECT name, count(name) FROM member WHERE MONTH(gaipday) = MONTH(CU..

create table reboard (num smallint auto_increment primary key, writer varchar(20), pass varchar(20), subject varchar(200), content varchar(2000), photo varchar(500), regroup smallint, restep smallint, relevel smallint, readcount smallint default 0, writeday datetime) 답변형 게시판 reboard num 오토 writer 작성자 pass 비번 subject 제목 content 내용 photo 사진 regroup 그룹번호 restep 그룹순서/ 출력할때 누구를 우선으로 둘까 relevel 들여쓰기 r..

delete member, cart from member inner join cart on member.mnum = cart.mnum where'51'; delete member, review from member inner join review on member.mnum = review.mnum where'51'; delete member, signup from member inner join signup on member.mnum = signup.mnum where'51'; member 와 mnum 를 공유하고 있는 cart, review, signup member에서 삭제시 조인 걸어서 cart, review, signup 도 삭제하게 만들려 했는데 delete 조인이 한 쿼리에 하나밖에 안된다. ..

-상품 DB- create table shop2(shopnum smallint auto_increment primary key, category varchar(30), sangpum varchar(50), photo varchar(50), price int, ipgoday varchar(20)) -장바구니 DB- create table cart(idx smallint auto_increment primary key, shopnum int references shop2(shopnum) on delete cascade, num int references member(num) on delete cascade, cnt int, cartday date) https://icandoitprogramming.tisto..

create table guest(num smallint auto_increment primary key, myid varchar(20), content varchar(2000), photoname varchar(50), chu smallint default 0, writeday datetime) create table answer (idx smallint auto_increment primary key, num smallint references guest(num) on delete cascade, myid varchar(20), content varchar(1000), writeday datetime) 왜 idx로 smallint를 하냐면 guest에 이미 num을써서. 겹치면 안되서 idx로 작성 ..

DB 데이터 추가 insert into member values(null, '홍길동','a1','1111','010-1111-1111','서울시 강남구','emmm@naver.com',now()); DB 테이블 전체삭제 drop table member; drop table 삭제할테이블명; DB 데이터 조회 select * from member where id='a1'; select * from DB테이블명 where 해당컬럼='값';

create table food(num smallint auto_increment primary key, foodname varchar(20), foodphoto varchar(30), price int, cnt int) create table student(num smallint auto_increment primary key, name varchar(20), photh varchar(30), java int, spring int)

create table team(num smallint auto_increment primary key, name varchar(20), driver varchar(10), addr varchar(50), writeday datetime); create table member(num smallint auto_increment primary key, name varchar(20), hp varchar(20), sdate datetime); mySQL문에선 오라클SQL문 과 다르게 varchar 아니면 text 를 쓴다 mySQL문 문자열 저장시 -> varchar(20), text(20)

1. 오른쪽 끝에 아이콘 클릭 (퀀텀DB) 들어가서 2. 데이터베이스 폴더 우클릭 -> properties 3. URL 주소 복사해서 가져오고 4. JDBC Driver 폴더에 있는 Driver Class Name 도 복사해서 가져오기

package mysql.db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DbConnet { //driver static final String MYSQLDRIVER ="com.mysql.jdbc.Driver"; //변하지 않는건 static final 상수로 //URL static final String MYSQL_URL = "jdbc:mysql://localhost:3306/sist"; //생성자 publ..