Update mysql database using streamlit where the values not filled by user must assume past values of database

[saurabh_saroj]

i am trying to update a mysql database. but i need my program such that when i leave the value spaces blank the old values are not overridden.

Expected behavior is if places are null no change in value should occur… ex

Actual behavior:

This is happening the spaces left blank overides value in database and put blanks…how to resolve this problem??plz help

[Caroline]

Hi there,

Thanks for sharing your question with the community! Check out our guidelines on how to post an effective question here – in particular, please update your post to share a written code snippet rather than a screenshot of your code (so we can run the code to reproduce the issue).