account.sql 730 B

123456789101112131415161718
  1. /*
  2. SQLyog Ultimate v11.3 (64 bit)
  3. MySQL - 5.5.16
  4. *********************************************************************
  5. */
  6. /*!40101 SET NAMES utf8 */;
  7. create table `account` (
  8. `id` int (11),
  9. `no` varchar (60),
  10. `name` varchar (30),
  11. `balance` double
  12. );
  13. insert into `account` (`id`, `no`, `name`, `balance`) values('1','12580','lns','20000.00');
  14. insert into `account` (`id`, `no`, `name`, `balance`) values('2','12581','xjh','60000.00');
  15. insert into `account` (`id`, `no`, `name`, `balance`) values('3','12582','cjs','15000.00');
  16. insert into `account` (`id`, `no`, `name`, `balance`) values('4','12583','wtr','10086.00');
  17. insert into `account` (`id`, `no`, `name`, `balance`) values('5','11111','asd','11111.00');