Change null to not null lost data

Problems, tips, hints - all about usage.

Change null to not null lost data

Postby Reinierus » Wed Aug 30, 2017 6:09 pm

Hello.
I have a SQlite database with data. When I change the structure from "null" to "not null", I lost almost all data of the database. How can I recover that data? It is normal?
Please help me!

Thanks
Reinierus
 
Posts: 1
Joined: Wed Aug 30, 2017 6:02 pm

Re: Change null to not null lost data

Postby Googie » Mon Sep 11, 2017 8:00 am

It's not normal. I'm not sure if you can recover the data.
How did you enter the data into database in first place? Did you insert it with SQLiteStudio, was is there before?
Googie
Site Admin
 
Posts: 772
Joined: Wed Jul 27, 2011 8:04 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 1 guest

cron