从过程中过滤出纯mysql查询

Question

使用SHOW CREATE PROCEDURE GetWishlistFromToken它返回以下数据

' gettwishlistfromtoken '， ''， 'CREATE DEFINER=kortnick@%PROCEDUREGetWishlistFromToken(rn IN userToken VARCHAR(255)rn)n SQL SECURITY INVOKERnBEGINrn SELECT wi。product_id从oauth_token0 0 rn加入愿望列表0 0。customer_id = w.customer_idrn JOIN wishlist_item wi ON w.wishlist_id = w.customer_idwishlist_idrntoken= userToken ANDcustomer_id IS NOT NULLrn ORDER BY wishlist_item_id DESC;rnEND'， 'utf8mb4'， 'utf8mb4_general_ci'， 'latin1_swedish_ci'

我不知道如何过滤纯mysql查询从这个

i have try use

选择wi。product_id fromoauth_tokenJOIN wishlistclienter_id = w.customer_id IN wishlist_item wi ON w.w .wishlist_id = w.wishlist_idot的地方。token= '11d587j0cks5jntb4lmr92t6e6efwk7z' AND ot。ORDER BY wishlist_item_id DESC

但是显示错误

Error in query (1064): Syntax error near 'wishlist_item wi ON w.wishlist_id = wi.wishlist_id WHERE ot.`token` = '11d587j0' at line 1

Answer 1

我认为您忘记在oath_token之后复制别名ot，并且您还在其中一个joins中犯了错别字。试试这个:

SELECT   wi.product_id
FROM     oauth_token ot
JOIN     wishlist w ON ot.customer_id = w.customer_id
JOIN     wishlist_item wi ON w.wishlist_id = wi.wishlist_id
WHERE    ot.token = '11d587j0cks5jntb4lmr92t6e6efwk7z' AND
ot.customer_id IS NOT NULL
ORDER BY wishlist_item_id DESC;

(如果'11d587j0cks5jntb4lmr92t6e6efwk7z'真的是一个令牌更改它…)