Making empty string to have 0 value in MySQL without using trigger

Question

My Query for today is that I wanted to set my MySQL value to zero whenever an empty string is saved. Is there a way to do this without using trigger? What I wanted is like this in the illustration

          TABLE DATA                                   MYSQL TABLE VALUE
name    age    years of experience      -->            name    age    yrs
John    23                              -->            John    23      0

use the default + an update script running the IFNULL() example from the answer to correct already existing entires in your db — Najzero
– Najzero, Commented Feb 27, 2014 at 9:53

deviloper · Accepted Answer · 2014-02-27 10:56:44Z

1

Set the field to stay NULL if hs no value

ALTER DATA MODIFY years_of_experience varchar(255) null;

And try this:

select name,age,IFNULL(years_of_experience,0) from DATA;

edited Feb 27, 2014 at 10:56

answered Feb 27, 2014 at 9:37

deviloper

7,25210 gold badges52 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Making empty string to have 0 value in MySQL without using trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related