MySQL auto_generated returns NULL

dflkid

• September 20, 2017 00:00

• Answered

Follow

I have been unable to get a RETURNING statement to work with MySQL. The component connnected via port 1 returns the correct number of rows, but the auto_generated column is always NULL. My query is very simple, and I'm stumped. I'm using the commercial server 4.6

INSERT IGNORE INTO orders
(
	extid, storeid, purchasedat, clientid, loggedinassociateid
)
VALUES
(
	$OrderNumber, 57785, $OrderDate, $CustomerContact, 3787087
)
RETURNING $inserted_id:=auto_generated

• 

  dflkid

  • September 21, 2017 04:56

  0

  Comment actions Permalink

  Figured this out on my own. I didn't realize the IGNORE statement was kicking in because I duplicate ID's in the database. As such, nothing was actually getting inserted.

Please sign in to leave a comment.