how to pass a null parameter to date field in mysql procedure using python

Question

I'm new to the Mysql,so i'm getting the problem while passing the null value to date field from the python script calling the procedure.Can you please help me out

I have table in mysql db_test with fields name and date,date column allows null value.

i call the procedure from python like these

cursor.execute("CALL date_insert(%s,%s) ;" %('john',None))

But it shows an error

Error No:1292 Incorrect value 'None' for the date column

Steve Barnes · Accepted Answer · 2015-01-07 18:04:36Z

2

Try:

cursor.execute("CALL date_insert(%s,%s) ;" % ('john', 'NULL')

Or

cursor.execute("CALL date_insert(%s,%s) ;" % ('john', '\\N')

You might even need:

cursor.execute('CALL date_insert("%s", %s) ;' % ('john', 'NULL')

Just remember that while they are used similarly the various languages:

None, NULL, Null, null, NIL, 0, void, void *, '', "". <>, ?

are not the same and not necessarily interchangeable.

edited Jan 7, 2015 at 18:04

answered Jan 7, 2015 at 6:29

Steve Barnes

28.5k6 gold badges68 silver badges80 bronze badges

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

2 Comments

Srilatha Over a year ago

I try with Null instead of None as your suggestion but still i getting the error as (1292, "Incorrect date value: 'Null' for column 'amc_date' at row 1")

Steve Barnes Over a year ago

@Srilatha NULL is not the same as Null - Many languages are case dependent especially for "special" or "reserved" names.

Stephen Lin · Accepted Answer · 2015-01-07 06:24:24Z

0

Try NULL instead of None for MYSQL:

cursor.execute("CALL date_insert(%s,%s) ;" %('john','NULL'))

answered Jan 7, 2015 at 6:24

Stephen Lin

4,9021 gold badge16 silver badges26 bronze badges

Comments

Moinuddin Quadri · Accepted Answer · 2015-01-07 06:36:49Z

0

Use:

cursor.execute("CALL date_insert(%s,%s) ;" % ('john', 'NULL')

None is the Python's way to represent empty objects. MySQL do not have any idea what it is. Instead,MySQL uses 'NULL' for representing empty values.

Refer "MySQL - Working with Null" for more details.

answered Jan 7, 2015 at 6:36

Moinuddin Quadri

48.4k13 gold badges101 silver badges137 bronze badges

Collectives™ on Stack Overflow

how to pass a null parameter to date field in mysql procedure using python

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related