phpmyadmin allow empty values in the DB without using the Null value [duplicate]

150

September 30, 2018, at 11:20 PM

This question already has an answer here:

default a column with empty string 1 answer

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)?

Answer 1

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

Answer 2

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

POPULAR ONLINE

AngularJS Appending the DOM?

Triggering an on change event or fixing querySelectorAll / document.getElementsByClass Name

HTML exercise for exams [on hold]

PHP laravel parse data using jQuery or combine them to single array

issue in my custom report after DB migration from firebird to my sql

good evening iam having an issue with my jasber report after DB migration from firebird to my sql

136

MySQL

Calculate a row number for every distinct occurrence of

I am trying to number specific values within a columnYou can see I've already sorted the table based upon date, it is important for the query to number based upon the already sorted date (from lowest value based on date to highest value

136

MySQL

getting an Call to undefined function mysql_query() error in PHP [duplicate]

This question already has an answer here:

224

MySQL

problems handling significant digits in mysql converting float to double

I am inserting data from one table into another in a MariaDB database, where the column in the first table is FLOAT, and in the second it's DOUBLEThe data can have values of any size, precision and decimal places

142