tag:blogger.com,1999:blog-2159223640923533538.post2465527663265566330..comments2023-03-28T23:44:46.458-07:00Comments on Expert of PHP: Mysql data get and show in google sheet Pardeep kumarhttp://www.blogger.com/profile/11142783094392760988noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2159223640923533538.post-89694788126362851972021-05-09T21:07:36.821-07:002021-05-09T21:07:36.821-07:00Work Ok!!!! txs!!Work Ok!!!! txs!!PabloPhttps://www.blogger.com/profile/02151547800012919976noreply@blogger.comtag:blogger.com,1999:blog-2159223640923533538.post-52045854759284908702021-05-01T05:33:13.146-07:002021-05-01T05:33:13.146-07:00What will the code be to PUSH the data from Google...What will the code be to PUSH the data from Google Sheets to MySQL Database??? Do tell.Cyb3r Gh0sthttps://www.blogger.com/profile/04959185605597436744noreply@blogger.comtag:blogger.com,1999:blog-2159223640923533538.post-64388846907908270882021-03-28T11:26:51.285-07:002021-03-28T11:26:51.285-07:00you need to cast the columnyou need to cast the columnugzhttps://www.blogger.com/profile/08902463708697084652noreply@blogger.comtag:blogger.com,1999:blog-2159223640923533538.post-21822096533976266712020-12-23T22:48:52.825-08:002020-12-23T22:48:52.825-08:00What if your mysql source data contains "zero...What if your mysql source data contains "zero dates" (0000-00-00 00:00:00)? Those aren't valid in jdbc. And jdbc usually allows you to add ?zeroDateTimeBehavior=convertToNull to the connection string. But google doesn't allow any parameters to connection strings. I feel like I need something in the SELECT statement to replace zero dates with nulls during query execution.Anonymoushttps://www.blogger.com/profile/07163377965194020529noreply@blogger.com