Home > database >  Postgres database query syntax error, clearly no problem
Postgres database query syntax error, clearly no problem

Time:09-30

//the first query prompt syntax error
Beap=#
Beap=#? The select a. eap_cutomer_id, a.u nit_code from beap_customers as a, customer_status as b where a. eap_cutomer_id=biggest ustomer_id and b.o nline_status=1 and a.u nit_code like '4401%'.
Error: syntax errors in "? Select "or near
Line 1 select a. eap_cutomer_id, a.u nit_code from beap_customers...
^

//rewrite again select words
Beap=#
Beap=#? The select a. eap_cutomer_id, a.u nit_code from beap_customers as a, customer_status as b where a. eap_cutomer_id=biggest ustomer_id and b.o nline_status=1 and a.u nit_code like '4401%'.
Beap_cutomer_id | unit_code
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
2013250 | 44011321102813
2004863 | 44010421104480
2005381 | 44010521103539
2004716 | 44010421104250
2005030 | 44011121142282
801040036 | 44010421112769
801140016 | 44011421113002

CodePudding user response:

Not visible characters should be in a mess

CodePudding user response:

Stick up the code you see is the same (including special symbol), may be have other at sixes and sevens characters,,,
  • Related