mysql insert获取主键

INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2');
SELECT LAST_INSERT_ID();

INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2') RETURNING primary_key_column;

try (Connection conn = DriverManager.getConnection(url, username, password);
     PreparedStatement pstmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {
    pstmt.setString(1, "value1");
    pstmt.setString(2, "value2");
    pstmt.executeUpdate();

    try (ResultSet rs = pstmt.getGeneratedKeys()) {
        if (rs.next()) {
            int generatedId = rs.getInt(1);
            System.out.println("Generated ID: " + generatedId);
        }
    }
} catch (SQLException e) {
    e.printStackTrace();
}

START TRANSACTION;
INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2');
SELECT LAST_INSERT_ID();
COMMIT;

ALTER TABLE table_name MODIFY primary_key_column BIGINT AUTO_INCREMENT;