How to prepared statement query at limit and offset

[M1n007]

im trying to querying prepared statement at limit and offset but error

Success

Error

[sidorares]

From the error text it looks like the problem is in the sql query. Could you show your .execute() or prepare() arguments?

[M1n007]

From the error text it looks like the problem is in the sql query. Could you show your .execute() or prepare() arguments?

this statement and values

if limit and offset not prepared statement

[sidorares]

you have 5 parameters in the first example and only 2 in a second while you are saying you replaced 2 placeholders with hardcoded text

[M1n007]

you have 5 parameters in the first example and only 2 in a second while you are saying you replaced 2 placeholders with hardcoded text

wait i miss to show 3 parameters

[sidorares]

oh right, I see you also removed like ? from the second example so it adds up

[M1n007]

oh right, I see you also removed like ? from the second example so it adds up

yes right

[sidorares]

I think the error is somewhere in the and concat part. Try to put it on a separate line ( and also add a space and ?and => and ? ) and :

#...start of your query
and (createdDate between ? and ?)
and (concat(...) like ?)
#... order by + limit + offset

[M1n007]

I think the error is somewhere in the and concat part. Try to put it on a separate line ( and also add a space and ?and => and ? ) and :

#...start of your query
and (createdDate between ? and ?)
and (concat(...) like ?)
#... order by + limit + offset

this sample with 3 parameter without limit and offset

this if 5 parameter include limit and offset prepared statement

[M1n007]

without concat error

without concat success

[M1n007]

thanks for help before @sidorares

[M1n007]

I think the error is somewhere in the and concat part. Try to put it on a separate line ( and also add a space and ?and => and ? ) and :

#...start of your query
and (createdDate between ? and ?)
and (concat(...) like ?)
#... order by + limit + offset

this sample with 3 parameter without limit and offset

this if 5 parameter include limit and offset prepared statement

also if using namedPlaceHolder

Success

Error

[M1n007]

Try in dbeaver success

[sidorares]

I'm not sure if dbeaver is using real server side prepared statements or does client side query building. More real test would be to do PREPARE command in mysql command line - https://dev.mysql.com/doc/refman/8.0/en/prepare.html

[M1n007]

still, can u helpme ?