1
I created a table called "billy".
mysql> SELECT * FROM billy ORDER BY f1;
+----------+-------+
| f1 | f2 |
+----------+-------+
| soho10 | test5 |
| soho12 | test1 |
| soho123 | test2 |
| soho1234 | test4 |
| soho222 | test3 |
+----------+-------+
5 rows in set (0.00 sec)
which ...
I am trying to write a query using group_concat, concat and other functions, but I am getting stuck not able to join and group the data to represent them in 1 cell.
Here's how my data is...
table1
id
---
1
2
3
---
table2
---------------
id | env | i...
It's absolutely not clear why you want this but you can use the hint USE INDEX () to tell the optimizer not to use any index. From MySQL docs: index hints
It is syntactically valid to omit index_list for USE INDEX, which means “use no indexes.” Omitting index_list for FORCE INDEX or IGNORE IN...
Perhaps this is but my first impression of DBA, but it's surely a pleasant one.
I recently asked a fairly basic question about Postgres's indexing abilities. I was greeted with AMAZINGLY cordial and thoughtful answers, that not only addressed my question, but did so without making me feel like a...
Database Administrators' fourth moderator election has come to a close, the votes have been tallied, and the new moderator is:
He'll be joining the existing crew shortly — please thank him for volunteering, and share your assistance and advice as he learns the ropes!
For details on how the v...
It is possible to get to the desired result in a simpler way.
First, you could start with this simple query:
SELECT
t1.id,
t2.env,
CONCAT(t3.inftype,
': [',
GROUP_CONCAT(t3.infname ORDER BY t3.infname SEPARATOR ', '),
']'
) AS inftypeandnames
FROM
tabl...
What special privileges do diamond moderators have?
Diamond moderators are human exception handlers. The main function of diamond moderators is to follow up on flagged posts but they also have some special abilities necessary to handle rare exceptional conditions:
They have access to all the ...
Moderators in general have an unlimited amount of flags, close votes, delete votes and also reviews.
Moderators are still subject to rate limits, but any other limits related to moderation duties don't apply to diamond moderators.
