Re: INSERT INTO - date type problem

[test test]

I don't obviously fully understand your question.

Where do the order dates come from ? Allways NOW () ???

Do you mean :

INSERT INTO tbl_order (customerId)
SELECT customerId
FROM tbl_customer
ORDER BY customerId DESC
LIMIT 1;
UPDATE tbl_order SET orderDate = NOW();

which is equivalent to :

INSERT INTO tbl_order (customerId, orderDate)
SELECT customerId, NOW()
FROM tbl_customer
ORDER BY customerId DESC
LIMIT 1;

Why do you use the 'LIMIT' clause ?