Guest User

Untitled

a guest
Jan 18th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. si.no cus_name date status
  2. 1 JOHN 2012-05-02 active
  3.  
  4. 1 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.  
  8. CREATE 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;
Add Comment
Please, Sign In to add comment