0

I have a table in my database and wanted to have empty values that will be updated later on. I dont want the values to be defined as null and when I use None as the default I get a database error when trying to enter values into the database. Help I dont want to use Null. Im running mysql on phpmyadmin.

Is there a configuration on phpmyadmin that would allow empty values to be passed or allow empty strings (without using the NULL)?

Improve this question
1
  • How do I do it on phpmyadmin??? Commented Sep 29, 2018 at 21:34

2 Answers 2

Reset to default
0

Use NOT NULL when defining the column. Or, in phpmyadmin, simply don't check the NULL checkbox.

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

8 Comments

Not null means there has to be a value. I just wanted an empty field that will be updated later on
You can leave the field empty (= no value)
When I leave as none it gives me an error that nothing has been passed on that field
hmm - not here...
Is there a configuration on the phpmyadmin that would allow empty values to be passed or allow empty strings?
|
0

For varchar, text or blob fields You can use '' as an value.

Improve this answer

1 Comment

I just want the fields to be completely blank

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.