Date conversion in MySQL

-

With recent release, MySQL throws error when inserting dates. This is because, by default "strict mode" is enabled. To get rid of the errors, we need to do something as follows:

SHOW VARIABLES LIKE 'sql_mode';


set sql_mode='';

Comments

Post a Comment

Popular posts from this blog

Citrix receiver on linux version LUbuntu

-
Started my new year by installing Lubuntu on my old dell laptop. Usually I install via USB, so prepared USB again via usb-creator-gtk on my previous installation of linux mint. Installation always used to hang on certain point on installer and could not figure out why. After googling, came to know that it needs network during installation but does not give any error. So connected LAN cable and got it installed. First task was to make sure that no issues when connecting to office network. I installed receiver from https://www.citrix.com/downloads/citrix-receiver.html After installation, logged in and got an verisign ssl error. So did sudo cp /usr/share/ca-certificates/mozilla/* /opt/Citrix/ICAClient/keystore/cacerts One issue is chrome does not open citrix application right away. I need to open it via command line by executable located at /opt/Citrix/ICAClient/wfica
Read more

Installing 64 bit adobe in firefox

-
I have 64 bit ubuntu in office and for some strange reasons, it installs 32 bit flash player through apt-get. To install 64 bit version here are the commands to copy paste in terminal. wget -O flash.tar.gz http://download.macromedia.com/pub/labs/flashplayer10/libflashplayer-10.0.22.87.linux-x86_64.so.tar.gz tar xvzf flash.tar.gz mkdir -p ~/.mozilla/plugins mv libflashplayer.so ~/.mozilla/plugins pkill firefox firefox
Read more