All Questions
8 questions
-2
votes
2
answers
105
views
Dayofweek vs weekday [closed]
Why does MariaDb use these terms differently?
#drop table dbstructA;
create table dbstructA(datum date);
insert into dbstructA values('2025-01-01');
insert into dbstructA values('2025-...
- 91
0
votes
1
answer
69
views
How do I save a function that I want to frequently use?
Due to the nature of how I ingest data into my SQL database it's prone to duplicates so I have the following view:
SELECT IP, COUNT(*) AS Count
FROM ipdb
GROUP BY IP
HAVING COUNT(*) > 1;
Current ...
- 101
3
votes
1
answer
484
views
Error Sql (1064) creating a function in MariaDB
I am getting an error in MariaDB when trying to create a function. It gives me the following error and I leave the script below.
The script:
CREATE PROCEDURE `total_hh`(fechainicio datetime, ...
0
votes
1
answer
69
views
Collation conflicts between views and functions when using utf8mb4_unicode_ci collation
Currently running MariaDB 10.3.24 and I really want to fully support the utf8mb4 unicode character set in my databases.
The problem I am running into is that when I try and set everything up to use ...
0
votes
1
answer
155
views
Cannot get a user function to co-operate with a subquery in mariadb
The following is a demo of an issue we are having with a function and a subquery. I'm interested to know if it is a bug or if there is a reasonable explaination why it is failing.
Notes:
Problem only ...
- 111
2
votes
1
answer
628
views
Can't restore MySQL DB because of a function
I'm trying to restore a database dump that I took via mysqldump onto a new server. Here's how I made the dump:
mysqldump --routines --triggers database_name | pbzip2 > database_name.sql.bz2
This ...
- 121
0
votes
1
answer
301
views
Function for generate a huge and possible random relationship between tables
I have this two tables and N:M relationship between them:
Let's said I am managed to create a lot of media and emails records but I need to create the relationship between them. I can do this ...
- 1,888
1
vote
0
answers
457
views
MariaDB CUstom Functions
In MySQL, I wrote functions in C++, compiled them as .so, and added them to MySQL. I am trying to find a website that shows an example for doing the same in MariaDB. I cannot find any instructions, ...
- 1,404