CODEWITHSUNDEEP
mysqlmamptable-plus
Hanie Asemi
Hanie Asemi

Reputation: 1500

How to Solve Getting Different Result of Query in MAMP MySQL Server and TablePlus MySQL Server?

I have a table and I want to run a query, first I've tried the MySQL server on MAMP and I've got this result: enter image description here

After that, I imported my table into the TablePlus MySQL server, and this time I'm getting a different result. enter image description here

Why the result of this query is different from the MAMP's result? How can I solve this inequality?

Upvotes: 0

Views: 126

Answers (1)

Hanie Asemi
Hanie Asemi

Reputation: 1500

It's because of the timezone in tablePlus and with changing the timezone configuration I'm getting the same result: enter image description here

Upvotes: 1

Related Questions