I have a spring boot application with mariaDB, after updating the connector ("org.mariadb.jdbc:mariadb-java-client") from version 2.7.5 to 3.0.3 the datetimes (
I'm trying to import a CSV file into MariaDB. I've created the table with "varchar(300)" for each field, so it's not missing space. Also, when I loaded the file
I have a MySQL database And I want to add a column: MariaDB [(none)]> use myDatabase; Database changed MariaDB [myDatabase]> ALTER TABLE material add new
I migrated my data to M1 Monterey MacOS from intel macmini. I was happy to use django and mariadb until I installed a package using homebrew. I installed homebr
Database : Maria DB 10.6.5 Issue: Data transfer from partitioned table to Non-Partitioned table Table A - partitioned on Date (range partitioned) Table B - Not
Database : Maria DB 10.6.5 Issue: Data transfer from partitioned table to Non-Partitioned table Table A - partitioned on Date (range partitioned) Table B - Not
I need to run the mysqld_safe command in a MariaDB installation, but I cannot find it inside the \bin folder...
I have this on a MariaDB version 5.5.65 datetimeconnect datetimeend queue agent event 02/05/2022 10:02:31 02/05/2022 10:02:31 "5009" "Mikey Blogs" "ADDME
pod logs: 2022-01-04 10:43:13+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.1+maria~focal started. 2022-01-04 10:43:14+00:00 [Note] [En
i'm facing a question without answer. I can't understand why the auto generated index from the FK creation is not working when the column seems to be the first
def getLevels(userName, levelID, levelName, levelLength, coins, starStars, amognus): try: statement = "SELECT userName, levelID, levelName, levelLength, coins
I read this post and I wish to fix it the same way as the answers but I can't find the backup folder in my CentOS. Where is C:\xampp\mysql\backup\ located in Li
I have MariaDB on my server with 16/32 CPU cores, Everything seems to be ok when running mysqltuner except InnoDB Write Log efficiency, taking 1953.15%, wonderi
Data I have a couple of tables like so: CREATE TABLE cycles ( `cycle` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cycle_type` varchar(140) COLLATE
I'm trying to replace an expensive where in ... query with a CTE. I've done this previously in other sql dialects, but can't get the syntax right for MariaDB/My
I have a 'locations' table as follows: Using an API, if I send a valid record, the table will start normally with index 1. If I send something that won't be ac
When connecting to an aurora db using the mariadb java client (version 2.7.5) i am getting this error (I only put the first few lines because the entire stack i
I'm trying to do pagination, but the SQL query returns the same values on different pages. I show them the queries and the results, and it shows that there are
Trying CONVERT() Trying STR_TO_DATE() Trying CAST() - neither DATE or DATETIME work Trying CAST(STR_TO_DATE()) Hi, I cannot figure out what I'm doing wrong with
I have a strange problem: There is a price in a JSON column in a table and the following statements give different results while they should give the same thing