user avatar
user avatar
user avatar
artfulrobot
  • Member for 10 years, 7 months
  • Last seen more than a week ago
4 votes
2 answers
3k views

MySQL replication problem: slave has become out of sync

4 votes
1 answer
5k views

Understanding optimisation of complex SELECT queries

4 votes
3 answers
3k views

How to duplicate related rows

3 votes
2 answers
3k views

can mysql cli exit with error if no records returned?

3 votes
2 answers
5k views

MySQL Full Text search increase relevance for exact matches?

2 votes
2 answers
7k views

How do I update last row of a group in MySQL

1 vote
2 answers
118 views

Efficiency for contact-contact relationships schema

1 vote
3 answers
998 views

Mariadb replication slave can only access information_schema db

0 votes
2 answers
77 views

Optimize MariaDB query with table that self-joins

0 votes
1 answer
972 views

How to use FIRST_VALUE window function in MySQL/MariaDB to get one row per group?

0 votes
2 answers
57 views

LEFT JOIN subquery fails in the presence of an EXISTS clause in the main query

0 votes
0 answers
170 views

How to improve efficiency of multiple JSON_EXTRACT SELECT expressions

0 votes
1 answer
1k views

Optimising MySQL query with lots of self-joins