MYSQL-具体代码-插入表-002

/*插入顾客数据*/

insert into customer

values('101001','孙杨','广州',1234),

('101002','郭海','南京',3526),

('101003','卢江','苏州',6892),

('101004','郭惠','济南',3492),

('101005','张三','济南',4188),

('101006','李四','南京',7455);

/*插入银行数据*/

insert into bank

values('B0001','工商银行'),

('B0002','建设银行'),

('B0003','中国银行'),

('B0004','农业银行');

/*插入存款数据*/

insert into deposite

values(1,'101001','B0001','2011-04-05',42526),

(2,'101002','B0003','2012-07-15',66500),

(3,'101003','B0002','2010-11-24',42366),

(4,'101004','B0004','2008-03-31',62362),

(5,'101001','B0003','2002-02-07',56346),

(6,'101002','B0001','2004-09-23',353626),

(7,'101003','B0004','2003-12-14',36236),

(8,'101004','B0002','2007-04-21',26267),

(9,'101001','B0002','2011-02-11',435456),

(10,'101002','B0004','2012-05-13',234626),

(11,'101003','B0003','2001-01-24',26243),

(12,'101004','B0001','2009-08-23',45671),

(13,'101005','B0001','2011-04-09',252016),

(14,'101006','B0001','2010-07-16',12745),

(15,'101006','B0002','2009-05-31',37258),

(16,'101005','B0003','2008-12-17',274159),

(17,'101003','B0001','2008-09-14',10257);

insert into deposite(amount) values(35000);