Skip to content
Advertisement

Tag: mariadb-10.4

Get data from same row with MAX()?

[MariaDB 10.4, PHP8.0] How can I rewrite this so it works so it get weight_date from the row with MAX(total_weight) and list it AS highest_weight_date? I have read that we can’t use MAX() among with WHERE? I have tested to rewrite several examples, but I give up and embarrassed show my latest try: I try to add it to this

How to select one random id from the child table?

I am using 10.4.13-MariaDB. I have a parent table and a child table. Parent table (tasks) In interface it looks like And I have a child table (puzzles) – puzzles table – puzzles can belong only to child themes I want to get ONE random PUZZLE from EACH LEVEL. How to write a proper query? Expected result: My fiddle: https://dbfiddle.uk/?rdbms=mariadb_10.4&fiddle=7bed2a19a0f98abccbe06ba9e0ae358b

MYSQL codes not being read

When I input a code or anything into MySQL and hit “enter” it moves down and “->” appears. It is as if the code is not going through or the code is not being read. I have attempted to download “add-ons” but I am really not sure what I am doing. This is for school and I am having trouble

Occurrence of a string inside another string

I was wondering if there is an easy way to look for a occurrence of a string inside another string. I’m using this query: $checkfileName[0] will be set in a if-statement, where it’s set to GiM1_0. My problem is that the column doesn’t contain that specific string, only a part of it. Image of sql table So is there a

Advertisement