php - mysql: store a DEFAULT value as a variable

Solution:

You don't. You uselast_insert_id() to retrieve it AFTER you've performed the first insert.

INSERT INTO foo (bar) VALUES (baz)
SELECT @id := last_insert_id();
INSERT INTO other (id, parent) VALUES (null, @id)
INSERT INTO yetanother (id, parent) VALUES (null, @id)
Copy code

Note thatlast_insert_id() is not smart and will return the id of the LAST insert you did. If you do two inserts, and then try to get the ids, you'll get the id of the second (last) insert.

Solution:

MySQL: You can find this in MySQL by using theLAST_INSERT_ID() function, as the last insert ID will be returned that you inserted for an AUTO_INCREMENT value.

$sql = "INSERT INTO sales ( sale_id, sale_amt, sale_date) VALUES ( DEFAULT, # <--- how to store the resulting value of this? '$amt', '$date' )";

sql2 = "INSERT INTO records ( sale_id, customer_name, other_info) VALUES ( LAST_INSERT_ID(), <-------- correct sales_id '$name', '$info');