It is necessary to set a default value for column 'transactiondatetime' on page Data formats.

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
[email protected]
Posts: 1
Joined: Fri 29 May 2020 03:00

It is necessary to set a default value for column 'transactiondatetime' on page Data formats.

Post by [email protected] » Fri 29 May 2020 03:04

When trying to import an XLSX file of data into a table i get the following error:

It is necessary to set a default value for column 'transactiondatetime' on page Data formats.

I dont understand the error because i dont have any null values under the column "transactiondatetime"

alexa

Re: It is necessary to set a default value for column 'transactiondatetime' on page Data formats.

Post by alexa » Fri 29 May 2020 12:50

Could you please send us the file to reproduce this issue?

In case you are importing into an existing table, please also provide the CREATE definition of the table.

You can send the reply straight to our support system at supportATdevartDOTcom.

Post Reply