[teratail] 複合主キーに後からAUTO_INCREMENTをつけたい (2015/12/02) [2019/06/12]
private static final String account_table = "create table " + Tablename +
" (mid INT(20) NOT NULL AUTO_INCREMENT, " +
"mdate VARCHAR(11), mcost VARCHAR(4), mitems VARCHAR(4), mdeposit VARCHAR(9), " +
"mpayment VARCHAR(9), mname VARCHAR(24), mseller VARCHAR(24), mshipping VARCHAR(11), " +
"mreceipt VARCHAR(11), mbalance VARCHAR(9), mremarks VARCHAR(24), UNIQUE KEY `mid` (`mid`))";