Even though there are multiple questions like this I can’t get my query to return the row with the most recent date with a group by. I have the following table.. | message_id | from | to | …
Tag: mysql
How to get percentage of rows which are not NULL in a specific column?
I have a database setup like this: Table called reviews How do I get the percentage of how many rows there are, which are NOT NULL? A basic “formula” of what I want: percentage = 100 * ( (Sum of rows where review is not null) / (Amount of rows) ) For the example above, this would be: percentage =
How to Update table row using regex
I have a table with rows like this: and I want to update my rows to keep only normal data and delete data inside “()” I’m wondering if there is a way to use regex inside my SQL update statement to delete all data after ” (” Answer You must use 2 SUBSTRING_INDEX like this if there…
Use UNIX_TIMESTAMP on update instead of timestamp
I want to add a column with a unix timestamp to see when the row was last altered. So far i could only figure out how to add a column with timestamp format. Is there any solution to use a unix timestamp – something like this: UPDATE: similar question As far as i understand this thread only shows how to
Alternative to BigQuery for medium-sized data
This is a follow-up to the question Why doesn’t BigQuery perform as well on small data sets. Let’s suppose I have a data-set that is ~1M rows. In the current database that we’re using (mysql) aggregation queries would run quite slow, perhaps taking ~10s or so on complex aggregations. On BigQ…
About set id=1 and password = ‘ ‘ in the SQL injection [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 5 years ago. Improve this question Here is certain expert’s code: https://github.com/DalerAsrorov/Security-Flaws-And-Thei…
Replace chars in string if it starts or ends with specified char
I have a column in my database with entries that starts or ends with a hyphen. I would like to find these rows and remove/replace the hyphens if it’s the last or first (or both) char in the string. …
Mysql Sum daily totals into weekly totals for given date range
Currently my db table has dailTotal values for every single day, I need to get these grouped into weekly totals. Is it possible to add the daily totals up into weekly totals and display a row each weekly total between the given date range. Im not quite sure where to start with this one. My current query to ge…
How to check if field value is same as combobox value?
So I am making a SQL query in which value of combobox (cboVU) shoud be same as field in table called Vrsta uredaja in table O klima uredaju. I am making this query in Access 2016. I am getting this: Tables and relations: Answer To continue on @Nathan_Sav’s comment:
Display contact database by all categories it is marked, then alphabetical order
I’m trying to build a Vendor Contact Database with categories. Various vendors are marked under more than one category. I have structured my table as the following: My Current Code This is just a basic idea. My contact database has more fields including phone number, email, etc. Seeing how our category …