Do triggers work on dbfiddle with MySQL 5.6? 7
dbfiddle mysql-5.6
Vérace Vérace
2 Triggers work, but the `DELIMITER` statement does not. It [isn't supported](https://stackoverflow.com/q/5311141/12757754) by the PHP driver, because it is not a mysql database command, but [mysql *client* command](https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html).
Jack Douglas
How can I constrain a v4 UUID?
mysql-8.0
Jack Douglas Jack Douglas
3 Use `binary(16)` with a check constraint that checks the 6 identifying bits for v4 UUIDs are set correctly.
Jack Douglas
Timezone aware datatypes - PostgreSQL & MySQL, potential inconsistencies with UTC? 2
postgresql mysql dbfiddle
Vérace Vérace
Feature request for db<>fiddle! Timezone support for MySQL (not just offset support). 1
mysql
Vérace Vérace
3 Thanks for pointing this out and including a link for how to resolve the issue. This is now fixed for all active versions of MySQL and MariaDB.
Jack Douglas
how to add aircraft company name or the transporter and make it shown beside each column 1
mysql
Anonymous 2193 Anonymous 2193
MySQL: Why is it that including all columns in group by is not allowing the table to aggregate the data? 1
mysql
anoldmaninthesea anoldmaninthesea
8 When you add a `GROUP BY` clause to your query, it means the output will have exactly one row per each distinct combination of columns/expressions provided in the `GROUP BY` clause. The underlying dataset may have more than one row matching any specific combination, but the output will produce only one of each.
Andriy M
find out the count of users who transacted for the first time on a Monday
mysql
Shiva Shiva
Query to get the count of users whose first transaction was on a Monday for each merchant
mysql
Anonymous 2043 Anonymous 2043
4 It would be easier to write a query if you provide test data.
FoggyFinder
Why does MySQL GROUP BY conflict with the SQL Standards?
mysql
rahularyansharma rahularyansharma
6 > Standard SQL would reject your query because you **can not SELECT non-aggregate fields** that are **not part of the GROUP BY clause** in an aggregate query
ypercubeᵀᴹ
2 > Is MySQL breaking the standard by allowing this? How?
Quassnoi
1 **Short answer**
Johan
Show me the median! Show me the Mediaaan! Shooow meee the Meediaaaan! =D 9
mysql
anoldmaninthesea anoldmaninthesea
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.