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
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
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
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
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
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
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
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
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
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
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
I am struggling to conditionally extract values from a nested JSON string in the Mysql table. {"users": [{"userId": "10000001", "userToken": "11000000000001", "
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
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 and show error I install mysql.connector package through pip This is Code import mysql.connector connection = mysql.connector.connect(ho
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'
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
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
keeps loading what should I do?
This is my register page: Registration was working before adding Email checker functionality. This function for check did someone used this email on database.