09 2023 档案

 
sql集合-查询语句
摘要:1,张飞借阅书的籍-子查询SELECT b.book_name FROM bookinfo bINNER JOIN book_borrow bbON b.book_id =bb.book_id WHERE bb.card_id =(SELECT card_id FROM reader WHERE n 阅读全文
posted @ 2023-09-08 16:23 sunshine心 阅读(98) 评论(0) 推荐(0)
sql合集-简单语句
摘要:sql合集-简单语句1、选择:select * from table1 where 范围 插入:insert into table1(field1,field2) values(value1,value2) 删除:delete from table1 where 范围 更新:update table1 set fiel 阅读全文
posted @ 2023-09-08 16:16 sunshine心 阅读(53) 评论(0) 推荐(0)