Category "mysql"

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

MySQL is not connecting through python

MySQL is not connecting and show error I install mysql.connector package through pip This is Code import mysql.connector connection = mysql.connector.connect(ho

Mysql 8.0 "ERROR 1030 (HY000): Got error 100" when adding index to very large table

I'm attempting to add an index to a very large table (2B rows) and the command fails after a few hours with: ERROR 1030 (HY000): Got error 100 - 'InnoDB error'

I can't figure out why I'm getting a ReferenceError: fileUploaded is not defined

Hi this is my first post! Here's the error I'm throwing when trying to submit a post on a website I'm making! This is the error and line 36 is where i call shar

How can I link to a custom library when building MySQL Server from source?

I installed MySQL server using a standard source distribution (mysql-server-8.0) according to this url: https://dev.mysql.com/doc/refman/8.0/en/installing-sourc

PopSQL is stuck at the startup and keeps loading, what should I do?

keeps loading what should I do?

MySQL error Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException

This is my register page: Registration was working before adding Email checker functionality. This function for check did someone used this email on database.

MySQL Select query between dates

I have a MySql table called contracts. I try to filter contracts applicable between two dates 2022-05-03 and 2022-05-07. MySQL query must be return id numbers: