MySQL - Prepare(변수설정느낌)

prepare myQuery from 'select * from usertbl where userid = "EJW"';
execute myQuery;
deallocate prepare myquery;

-- mytable 생성 (id auto_increment, pk, mdate datetime);

create table mytable(id int primary key auto_increment, mdate datetime);

-- curdate 변수에 날짜함수를 이용하여 현재 날짜와 시간을 시스템으로 부터 받아서 할당

set @curdate = current_timestamp();
select @curdate;

-- myquery 동적 쿼리 작성, mytable에 값을 파라메터 값으로 입력한다.

prepare myQuery from 'insert into myTable values(null,?)';

-- myquery 실행

execute myQuery using @curdate;

-- myquery 해제

deallocate prepare myQuery;

-- mytable 전체 정보 조회

select * from myTable;