MyBatis查Java优学网教程：告别低效查询，掌握高效SQL编写技巧

SELECT id, username, email FROM users WHERE id = #{id}

SELECT * FROM products WHERE category_id = #{categoryId}

SELECT id, name, price, image_url 
FROM products 
WHERE category_id = #{categoryId}