基于ssm健身俱乐部网站，java技术经理面试题及答案

---

DROP TABLE IF EXISTS banka;

CREATE TABLE banka (

id int(11) NOT NULL AUTO_INCREMENT,

huiyuankazhonglei varchar(50) DEFAULT NULL,

dengji varchar(50) DEFAULT NULL,

zhekou varchar(50) DEFAULT NULL,

jianjie varchar(50) DEFAULT NULL,

yonghuming varchar(50) DEFAULT NULL,

cheng varchar(50) DEFAULT NULL,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

---

– Records of banka

---

INSERT INTO banka VALUES (‘2’, ‘’, ‘’, ‘3’, ‘无’, ‘007’, ‘’, ‘2020-04-12 09:23:17’);

INSERT INTO banka VALUES (‘3’, ‘’, ‘’, ‘4’, ‘abc’, ‘014’, ‘’, ‘2020-04-12 09:23:17’);

INSERT INTO banka VALUES (‘4’, ‘’, ‘’, ‘2’,