Ph: 786-539-6996

Mysql: Incorrect date value: ‘0000-00-00’ for column ‘date’ at row…

To avoid this issue, you need to remove NO_ZERO_DATE from the mysql mode configuration. Go to ‘phpmyadmin’. Once phpmyadmin is loaded up, click on the ‘variables’ tab. Search for ‘sql mode’. Click on the Edit option and[…..]

March 15th, 2023 | aesio

Substring Function Mysql

How to use Substring Function Mysql: Name of the table: wp_divisions, name of the field: name, string to find: GBB update `wp_divisions` set `level_id` =0 WHERE SUBSTRING(`name`,2,2)=“GBB”

December 4th, 2015 | aesio

Time Programmer Corp Since 2014 ®