How can I input only numeric data in mysql with php?

Question

I created a

CONSTRAINT chk_donate CHECK credit_card_no LIKE '[0-9][0-9][0-9][0-9][0-9][0-9][0-9]'

but with using an insert query to column name 'credit_card_no' with a numeric datatype with letters, there's no error and the value is 0. Please help.

MySQL doesn't support constraints. Why are you using a non-numeric type to store numeric data anyway? — GordonM, Jul 29 '14 at 08:10
GordonM I was trying to check if the constraints was working. — NewCoder, Jul 29 '14 at 09:31

score 6 · Accepted Answer · answered Jul 29 '14 at 08:07

6

Currently (MySQL 5.7.x) the CHECK clause is ignored by MySQL, see manual, CREATE TABLE:

The CHECK clause is parsed but ignored by all storage engines.

answered Jul 29 '14 at 08:07

VMai

10,156
9
25
34

Thanks. I read that manual. Its really helpful. – NewCoder Jul 29 '14 at 09:33

score 0 · Answer 2 · edited May 23 '17 at 10:33

0

This is because of your CHECK method.The latest versions of mysql uses CREATE TABLE method instead of CHECK..Changing CHECK to CREATE TABLE or you can use TRIGGER as mentioned here

edited May 23 '17 at 10:33

Community

1
1

answered Jul 29 '14 at 08:10

Avinash Babu

6,171
3
21
26

How can I input only numeric data in mysql with php?

2 Answers2