Questions tagged [mariadb-10.6]
36 questions
0
votes
0 answers
Error while inserting values to table : Incorrect Date Value
So I have created a table with several date values of which one column is not mandatory, meaning it may go with null value. In the table structure, I have set "NULL" as "YES" and "DEFAULT" as "NULL" but every time I try to make an entry with NULL…
Anna
- 1
0
votes
1 answer
Polymorphism in Create Package (MariaDB 10.6.4)
is it possible (or maybe will it be?) to use polymorphism in CREATE PACKAGE and CREATE PACKAGE BODY statements in MariaDB?
This is due to a migration of some package from Oracle to MariaDB. I have to recode some parts but I cannot change names (i.e.…
Alex
- 1
- 1
0
votes
0 answers
Convert the SQL Server script to MariaDB script
I want to convert the SQL script from SQL Server to MariaDB of the following below but I can't figure out.
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'client')
CREATE USER `client` FOR LOGIN `client` WITH…
amstriker
- 339
- 7
- 19
-1
votes
1 answer
Error 1064 on create trigger mysql trigger
I try to do tregger BEFORE UPDATE but keep getting an error
I need to create trigger BEFORE UPDATE test what change and put that change to table logi
DROP TRIGGER IF EXISTS `logs`;
DELIMITER //
CREATE DEFINER=`ams`@`%` TRIGGER `logs`
BEFORE UPDATE…
Michał Skorupski
- 1
- 1
-1
votes
2 answers
get first occurrence of last changed value of a column for each unique id
How to get first occurrence of last changed value of "sval" column?
for id = 22, 71 is the last changed value so wants to fetch first occurence of 71.
same way for id = 25, 74 is the last changed value so wants to fetch first occurence of…
Juned Ansari
- 5,035
- 7
- 56
- 89