Not sure if this is
servlet or
jdbc but here goes.
MySql only lets you do AUTO_INCREMENT on one column and I am using it for the invoice id.
What can I do to do an auto generated INVOICE_NUMBER?
I would rather not select the max(invoice_id) and use that as the INVOICE_NUMBER
What else could I do?
CREATE TABLE INVOICE (
INVOICE_ID INT NOT NULL AUTO_INCREMENT,
USER_ID INT,
INVOICE_NUMBER INT NOT NULL,
INVOICE_DTE DATE,
SUBTOTAL NUMERIC(15,2),
SHIPPING_CHARGE NUMERIC(15,2),
TOTAL NUMERIC(15,2),
TAX NUMERIC(15,2),
COUPON_CODE_NUM VARCHAR(20),
IS_TAXED CHAR(1),
HAS_APPROVED CHAR(1),
HAS_SYNCED CHAR(1),
HAS_PROCESSED CHAR(1),
PRIMARY KEY (INVOICE_ID));
DAO