//第一次查詢提示語法錯誤
beap=#
beap=# ?select a.beap_cutomer_id, a.unit_code from beap_customers as a, customer_status as b where a.beap_cutomer_id=b.customer_id and b.online_status=1 and a.unit_code like '4401%';
錯誤: 語法錯誤 在 "?select" 或附近的
第1行select a.beap_cutomer_id, a.unit_code from beap_customers ...
^
//重寫一遍select單詞
beap=#
beap=# ?select a.beap_cutomer_id, a.unit_code from beap_customers as a, customer_status as b where a.beap_cutomer_id=b.customer_id and b.online_status=1 and a.unit_code like '4401%';
beap_cutomer_id | unit_code
-----------------+----------------
2013250 | 44011321102813
2004863 | 44010421104480
2005381 | 44010521103539
2004716 | 44010421104250
2005030 | 44011121142282
801040036 | 44010421112769
801140016 | 44011421113002
uj5u.com熱心網友回復：
應該是有亂七八糟的不可見字符uj5u.com熱心網友回復：
你粘上來的代碼看是一樣的（包括特殊符號）。可能就是有其他亂七八糟的字符。。。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/98101.html
標籤：PostgreSQL
上一篇：救急~mysql無法啟動，顯示[ERROR] Aborting無其他原因。
下一篇：mysql 怎么 查詢 包含欄位