MySQL

Foreignkey relation

ALTER TABLE SUBCATEGORY ADD FOREIGN KEY (CATEGORYID) REFERENCES CATEGORIES(ID) ON DELETE CASCADE;

Serial number column

@a:=@a+1 serial_number,

Get CurrentDate

CURDATE();