Month: April 2020

Categories
Php

PHP

Started working with Fedora again…  installed laravel.  It could not find pdo mysql driver.

Fedora:

sudo dnf install php-mysqlnd

Debian:

sudo apt-get install php7.0-mysql
Categories
java Mariadb

Java Mysql

Oh my… switched to java spring a while ago and finally started to log my notes. lots of jpa/hibernation to come..

In the database, the date column can be null. jpa doesnt like this.
one shop says that 2 different ways to get rid of the issue:
1.

UPDATE table SET datefield = NULL WHERE datefield = '0000-00-00 00:00:00';

I like it.
2.

jdbc:mysql://localhost:3306/yourMySqlDatabase?zeroDateTimeBehavior=convertToNull

I like it also.
I guess it is a preference thing. both methods are easy enough to implement. database defaults to null value …