Category "mysql"

Array in mysql or something similar

I have a question. I made this procedure, and I am curious if I can make it to return more than 1 output. Let me know if you need the tables, but the code is wo

MySQL correlated subquery very slow when range is included

DB Fiddle: https://www.db-fiddle.com/f/u1N4YYV3wmiWndnZNb95xz/5 For the following tables nodes and leaves, with nodes having just 9 records and leaves having a

MariaDB docker not starting due to Innodb error

I have a local docker environment (MAC) for my Laravel set-up. The mariadb container in docker-compose.yml is defined as image: mariadb:10.6 container_n

Connection for controluser as defined in your configuration failed on ubuntu20.04 container

I'm trying to have one docker container with: ubuntu 20.04, on top of which I add apache, php, mysql and phpmyadmin (all on the same container) What's installed

NHibernate: How to insert C# [Guid] into MySQL [BINARY(16) DEFAULT (uuid_to_bin(uuid(),1))] column?

Environment: MySQL Server 8.0, .NET Core 3.1, MySql.Data 8.0.28, NHibernate 5.3.11 I have following table: CREATE TABLE `Master` ( `Row_Id` char(36) NOT NULL

Redshift SQL Query Between Current Date and 7 days ago

I've been trying to filter the data for the last X number of days. All these columns work as standalone results when I remove the time filter from the where cla

SQL COUNT with values from 2 tables

I have following two tables: comments comment_post_ID status comment_type 1 complete course_status 2 complete course_status a1 complete lesson_status a2 passed

mysql order by collation

I want to sort the results of MySQL based on the best match by using collate query => zeķ want to show Vīriešu zeķes Sieviešu

Flask check_password always return false

I create login for user in home page if user click on login then the login page is display there user enter email id and password if email id and password is co

How do you reconcile the path of a file inside mySQL with the domain name your browser puts in front of it, to view it?

I'm successfully uploading some files to a folder and saving the path in table. If I display the file's path in an html table, hovering over it, the address on

Using Node.js as an alternative of Spring MVC project

Hello to everyone who is viewing this question. I am currently running a web-application server, which only does CRUD operation (using MySQL) for android and iO

joining two tables with different columns into one

I have 2 tables that I want to join. They both have a uuid field and a text name field. Besides that they have no connection, The end result I wish to achieve i

Why is restore to a mariadb instance with log-bin enabled not working to database not in binlog_do_db and UNIQUE_CHECKS=0?

There is a mariadb version 10.7 instance running in Kubernetes. Recently log-bin was added to the server.cnf. The restore scripts stopped working for any databa

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'posts.post' doesn't exist

I'm very confused, i try to find what's wrong but i don't find it.. In my SQL Database i've 'posts' table created all my code are related with 'posts' table and

GCP CloudSQL increasing massive size of storage day by day

I wonder storage size of the MySQL Cloud SQL server in GCP is increased in TBs over time in just 4-5 days from just a few GB. I have checked the size of all the

How to resolve Python mysqlclient install error on Mac

I’m trying to install Python interface to MySQL (mysqlclient 2.1.0) for use with Django project (to be developed in MS Code) on my MacBook with M1 chip. W

Need help joining 2 tables on one [duplicate]

So I got an admin dashboard which are not linked by ID but by name. So developer.name is the core name, dateName and absentName are meant to j

Conditionally select values from an array in a nested JSON string in a Mysql database

I am struggling to conditionally extract values from a nested JSON string in the Mysql table. {"users": [{"userId": "10000001", "userToken": "11000000000001", "

Mysql2 error in starting rails server in mac m1

I have installed mysql2 in mac m1 using the below command gem uninstall mysql2 gem install mysql2 -v '0.3.21' -- --srcdir=/usr/local/Cellar/mysql/8.0.28_1/bin/i

MySQL under XAMPP won't start on MacOS - throwing "no such process"

I'm on MacOS (Catalina right now) but the issue has been there for the last couple of years. XAMPP works great and then all of sudden I can't start MySQL. Only