Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- si.no cus_name date status
- 1 JOHN 2012-05-02 active
- 1 PAUL 2012-05-02 active ( not a new record just an 1st-update )
- 1 JOSE 2012-05-02 active ( not a new record just an 2nd-update )
- CREATE TABLE IF NOT EXISTS `customer_record` (
- `si.no` int(11) NOT NULL,
- `cus_name` varchar(255) NOT NULL,
- `date` DATETIME NOT NULL,
- `status` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Add Comment
Please, Sign In to add comment