小白一个,求助大神们
第一张表:create table borrow
(id INT(20) not null AUTO_INCREMENT,
PRIMARY KEY(id) ,
zyname VARCHAR(100),
jcname VARCHAR(100),
phone VARCHAR(100),
jcjbname VARCHAR(100),
jctime VARCHAR(100),index(id))
engine=innodb;
第二张表:
create table borrow_1
(idborrow INT(20) not null,
index(idborrow),foreign key(idborrow) references borrow(id) on delete cascade on update cascade,
ghjbname VARCHAR(100),
ghtime VARCHAR(100)) engine=innodb;
第一张表:create table borrow
(id INT(20) not null AUTO_INCREMENT,
PRIMARY KEY(id) ,
zyname VARCHAR(100),
jcname VARCHAR(100),
phone VARCHAR(100),
jcjbname VARCHAR(100),
jctime VARCHAR(100),index(id))
engine=innodb;
第二张表:
create table borrow_1
(idborrow INT(20) not null,
index(idborrow),foreign key(idborrow) references borrow(id) on delete cascade on update cascade,
ghjbname VARCHAR(100),
ghtime VARCHAR(100)) engine=innodb;
create table borrow
(id INT(20) not null AUTO_INCREMENT,
PRIMARY KEY(id) ,
zyname VARCHAR(100),
jcname VARCHAR(100),
phone VARCHAR(100),
jcjbname VARCHAR(100),
jctime VARCHAR(100),ghjbname VARCHAR(100),
ghtime VARCHAR(100));
第一次填写这些内容,然后第二次填写以下表中‘归还经办人’字段。怎么获取鼠标所在行的记录,然后UPDATE记录