图书基本信息信息(book_info):图书id, 图书isbn, 书名, 作者, 出版社, 出版时间, 版次, 数量, 创建时间
图书封面图片信息(file_info):图片id, 图书id, 图书的isbn, 图片路径,图片名,图片大小, 图片类型, 创建时间
图书信息表(book_info)
图片信息(file_info)
更新图书信息
update book_info set book_isbn = ‘isbn’, book_name = ‘书名’, book_author = ‘作者’, book_press = ‘出版社’,
publish_dt = ‘2019-01-08 01:08:31’, book_issue = ‘版次’, book_nums = 10 where id = 12;
已知某本图书的isbn值,更新图书封面对应的图书id
update file_info f
set f.book_id = (select id from book_info where book_isbn = ‘isbn’ and is_effective = ‘Y’)
where f.is_effective = ‘Y’ and f.book_isbn = ‘isbn’;
批量上传了一批图书的封面,更新图书封面对应的图书id
update book_info b, file_info f
set f.book_id = b.id
where b.book_isbn = f.book_isbn
and f.is_effective = ‘Y’ and b.is_effective = ‘Y’;