개발자 Q&A

개발하다 막혔다면? 여기서 질문하세요! 초보부터 고수까지, 함께 고민하고 해결하는 공간입니다. 누구나 자유롭게 질문하고 답변을 남겨보세요!

2025.03.10 01:32

getLastInsertId 메서드 사용疑問

목록
  • 개발하는곰돌이 13일 전 2025.03.10 01:32
  • 12
    1
제가 최근에 SQLStatementResult 클래스를 사용하여 데이터베이스에 INSERT 연산을 수행하였습니다.
이러한 경우 getLastInsertId() 메서드를 사용하여 마지막으로 INSERT된 ID를 가져오려고 합니다.
하지만 getLastInsertId() 메서드의 사용법에 의문이 있습니다.

getLastInsertId() 메서드는 반드시 실행된 SQL문이 INSERT 연산일 때만 작동하는 것인가요?
만약 그렇다면 getLastInsertId() 메서드를 사용하기 위해서는 COMMIT 연산을 수행해야 하는 것인가요?

예를 들어, 아래와 같은 코드를 작성하였습니다.

php

$db = new PDO('mysql:host=localhost;dbname=test', 'root', '');

$stmt = $db->prepare('INSERT INTO user (name, email) VALUES (?, ?)');

$stmt->execute(['John Doe', 'johndoe@example.com']);



$lastId = $stmt->getLastInsertId();



print($lastId);


위의 코드에서는 getLastInsertId() 메서드를 사용하여 마지막으로 INSERT된 ID를 가져오는 것을 시도하였습니다.
하지만 마지막으로 INSERT된 ID를 가져오지 못하였습니다.

getLastInsertId() 메서드를 사용하여 마지막으로 INSERT된 ID를 가져오기 위해서는 어떤 조건을 만족해야 하는지 알려주세요.

    댓글목록

    profile_image
    나우호스팅 　13일 전



    getLastInsertId 메서드는 INSERT, REPLACE, DELETE, TRUNCATE, ALTER TABLE, DROP TABLE, DROP VIEW, DROP INDEX, DROP PROCEDURE, DROP FUNCTION, CREATE TABLE, CREATE INDEX, CREATE VIEW, CREATE PROCEDURE, CREATE FUNCTION, CREATE EVENT, ALTER TABLE, RENAME TABLE, RENAME INDEX, RENAME COLUMN, RENAME TABLESPACE, LOAD DATA, LOAD XML, LOAD XML LOCAL, LOAD CSV, LOAD JSON, LOAD JSON LOCAL, LOAD XML LOCAL INFILE, LOAD CSV LOCAL INFILE, LOAD JSON LOCAL INFILE, TRUNCATE TABLE, TRUNCATE TABLESPACE, TRUNCATE TABLESPACE LOCAL INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE, TRUNCATE TABLESPACE LOCAL INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE INFILE IN

    2025-03-10 01:33

  • 개발자 Q&A 포인트 정책
      글쓰기
      50P
      댓글
      10P
  • 전체 5,739건 / 229 페이지

검색

게시물 검색