SELECT * FROM book JOIN borrow USING (book_id);
SELECT * FROM book JOIN borrow WHERE book.book_id = borrow.book_id;
这两条SQL语句等价(但第二条语句会查出两个book_id列)
故简而言之USING()函数的作用是简化等值连接语句.
SELECT * FROM book JOIN borrow USING (book_id);
SELECT * FROM book JOIN borrow WHERE book.book_id = borrow.book_id;
这两条SQL语句等价(但第二条语句会查出两个book_id列)
故简而言之USING()函数的作用是简化等值连接语句.