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

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
– GordonM, Commented Jul 29, 2014 at 8:10
GordonM I was trying to check if the constraints was working. — NewCoder
– NewCoder, Commented Jul 29, 2014 at 9:31

VMai · Accepted Answer · 2014-07-29 08:07:08Z

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, 2014 at 8:07

VMai

10.4k9 gold badges28 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NewCoder Over a year ago

Thanks. I read that manual. Its really helpful.

Community · Accepted Answer · 2017-05-23 10:33:31Z

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, 2017 at 10:33

CommunityBot

11 silver badge

answered Jul 29, 2014 at 8:10

Avinash Babu

6,2534 gold badges23 silver badges26 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related