1

This is probably server settings but if I have a table with column ID: ID 12000

and I run this query

Select * from myTable where ID = "12000"

I get the row. My problem is that if I run

Select * from myTable where ID = "12000anystring" 

returns the same row....

Can I force the server not to allow it. (happens both in mysql and mariadb)

2
  • Please share the table structure and sample data, such that this question contains a reproducable example of that problem Commented Mar 23, 2020 at 6:46
  • Additionally, have a look at stackoverflow.com/questions/21762075/… Commented Mar 23, 2020 at 6:46

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.