mysql and not null column

Question

i have a address field and null is set to no. but when i insert record to table with empty address field , record added to table. and address column is empty. why record add to table despite address empty?

More details??! This is very vague.

Basic
– Basic

2011-04-18 09:22:49 +00:00
Commented Apr 18, 2011 at 9:22 — Basic
– Basic, Commented Apr 18, 2011 at 9:22

BugFinder · Accepted Answer · 2011-04-18 09:23:01Z

2

Could depend on how you add the data, for example if you entered the string as '' its not null, its just empty.

answered Apr 18, 2011 at 9:23

BugFinder

17.9k4 gold badges42 silver badges58 bronze badges

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

Comments

Cyril Gandon · Accepted Answer · 2011-04-18 09:24:55Z

2

It is possible to insert an empty string into a nullable field.

Insert into myTable (address) Values ('')

will work even if Address is not nullable.

Check if your field is really null.

Select * from myTable where address is null

answered Apr 18, 2011 at 9:24

Cyril Gandon

17.1k15 gold badges84 silver badges124 bronze badges

Comments

Basic · Accepted Answer · 2011-04-18 09:24:13Z

1

Null and empty are two different things, you need to validate with php before sending data to database. ie;

if (empty($_POST['address'])) {
}

answered Apr 18, 2011 at 9:24

Basic

1,8665 gold badges22 silver badges31 bronze badges

1 Comment

user006779 Over a year ago

null and empty ae different? if i dont fill address field , it is empty or null?

Collectives™ on Stack Overflow

mysql and not null column

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related