· 7 years ago · Jan 19, 2019, 03:46 AM
1si.no cus_name date status
2 1 JOHN 2012-05-02 active
3
41 PAUL 2012-05-02 active ( not a new record just an 1st-update )
5
6 1 JOSE 2012-05-02 active ( not a new record just an 2nd-update )
7
8CREATE TABLE IF NOT EXISTS `customer_record` (
9`si.no` int(11) NOT NULL,
10`cus_name` varchar(255) NOT NULL,
11`date` DATETIME NOT NULL,
12`status` varchar(255) NOT NULL
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;