Question : We have some tables with row_format=Compact. The biggest table is around 30Gb, so how safely i can alter […]
Tag: format
PostgreSQL Query – how to subtract timestamps and format durations (with builitin functions or otherweise)
Question : I am looking for a solution to a problem with a select statement where I am trying to […]
How to select different format of the date in mysql
Question : I have this table and I can’t change its format to yyyy-mm-dd because I have so many scripts […]
Dynamic trigger function to delete oldest rows of a table
Question : I am trying to generalize a trigger that deletes the oldest rows in a table as new rows […]
Format for recording RGB color in MySQL [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Query result in a daily date from a date range selection Postgres 9.3
Question : I need to make a report that will output a result in a daily row result based on […]
Match phone numbers efficiently
Question : For a mobile application we are considering validating a user based on their mobile phone number. In the […]
Improve select query performance
Question : The following select query from my application is taking more than 200ms. The table has around 2 million […]
Format for recording RGB color in MySQL [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Improve select query performance
Question : The following select query from my application is taking more than 200ms. The table has around 2 million […]
- 1
- 2