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.

Rent Charter Buses Company
READ ALSO
issue in my custom report after DB migration from firebird to my sql

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
Calculate a row number for every distinct occurrence of

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
problems handling significant digits in mysql converting float to double

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