i have column register on table jadwal:
CREATE TABLE IF NOT EXISTS 'jadwal' ('register' int(5) zerofill NOT NULL AUTO_INCREMENT, PRIMARY KEY ('register')
i want to show register combine, this year + auto_increment like:
1800001
1800002
1800003
and reset become 1900001 when year is 2019
i try to add Y on mysql like CREATE TABLE IF NOT EXISTS jadwal ( register int(5) Y zerofill NOT NULL AUTO_INCREMENT, but not working
please help the source code and many thanks