Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mariadb
Search options not deleted
user 203092
Open source RDBMS that forked from MySQL. Add a version-specific tag like mariadb-10.5 if that context is important.
0
votes
1
answer
270
views
Throw no default value error even if we give value
A user of one of my product is using MySQL 10.7.3-MariaDB. …
- 181
3
votes
1
answer
435
views
How to allow window function in window specification?
, 1) OVER (ORDER BY brainffa) as brainffa
FROM time_played
WHERE automatic = 1 AND name LIKE 'all%'
ORDER BY uuid DESC LIMIT 15
This query works fine with MySQL, but on this another db server, on MariaDB … (version: 10.6.5-MariaDB-1:10.6.5+maria~bionic) it failed with this error:
#4016 - Window function is not allowed in window specification
I searched in PhPMyAdmin for an option to allow window function …
- 181
2
votes
Accepted
1
vote
1
answer
434
views
How to return list of content from subquery for the main query?
I have a create that have sub query. To show as example, here is a query that has similarity with my own. Personally I have more table and more arguments on table (The subquery have left join for exam …
- 181
0
votes
Accepted
How to return list of content from subquery for the main query?
I found a way. I'm make the check on the query of MyTable, store as variable and use it. I'm doing like that:
SELECT
Content,
CASE
WHEN S.UserAvailable = 1 THEN 'Here'
ELSE 'Not'
…
- 181
0
votes
2
answers
35
views
How to optimize multiple WHEN that are using differents static string?
I have a table like that:
Id
Note
Client
1
Long note that havemultiple linesClient: Name
null
2
Anoter note that have multiple linesCustomer: Name
null
3
Third note that have multiple lines …
- 181
0
votes
Accepted
How to optimize multiple WHEN that are using differents static string?
I found a way. By using the function proposed by Akina: SUBSTRING_INDEX, there is an easy way: find the key word, then use it as param.
DB Fiddle
The query:
UPDATE test SET Client = (SELECT SUBSTRING_ …
- 181
0
votes
1
answer
17
views
Filter some queries with mariadb's replication
I want to make a safe master/slave replication, without drop/truncate. Which can help if we made mistake about drop/truncate table, or in case of hack/injection.
I searched for a replication restricti …
- 181
0
votes
1
answer
99
views
How can I get a valid rank counter?
I'm making a raking system. I want get the line in one request.
Here is a DB fiddle of my complete example: https://www.db-fiddle.com/f/3Com2wnrhaqfiTKqJSZtft/0
In the example, the UUID used is 36619b …
- 181
0
votes
2
answers
67
views
Why making temporary table is faster than multiple WHERE conditions?
I have a table like that:
CREATE TABLE Sessions (
SessionId int(11) NOT NULL AUTO_INCREMENT,
ExternalId int(11) NOT NULL,
Active bit(1) NOT NULL DEFAULT b'0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 …
- 181
4
votes
1
answer
3k
views
How to fix performance issue with row_number and multiple schema?
After receiving answer to How can I get a valid rank counter?, I adapted to my own system. But now, I have a performance issue. All of my requests are very fast (less than 0.0005s for most of them), b …
- 181
-2
votes
1
answer
62
views
Why is it selecting date from another month that requested one? [closed]
Note: I'm using MariaDB 10.11.4. …
- 181