Best way to keep your mySQL info out of a public repo
I am working on a website and using git. The repo is public but I don't want the mySQL info to be part of it. Should I just put the connection code in a file then block that file with…
Mysql – how to maximize query performance for uploading to the cloud if a huge table does not have an autoincrement primary key column
I have a huge table for load to Cloud (BigQuery). Table have very simple structure: CREATE TABLE `my_huge_table` ( `user_id` int(10) NOT NULL, `value_id` int(11) NOT NULL, `some_value` tinyint(2) unsigned NOT NULL DEFAULT '1', `created_at` datetime DEFAULT NULL, `updated_at` datetime…
Mysql – select consecutive duplicate records from the table
This is my sample record set. I want to SELECT (DELETE after confirmation) all the consecutive duplicate records having the same lid, same sid, same stype, same bid and 0 or null noOfDays. The lastest record should be preserved and…
MySQL connect pycharm: Process finished with exit code -1073741819 (0xC0000005)
I am trying to connect MySQL to Pycharm. With this code: import mysql.connector db = mysql.connector.connect( host="localhost", user="root", passwd="password", database="test" But I got this: Process finished with exit code -1073741819 (0xC0000005) What should I do? I have done many things…
Mysql – Spring Boot project and React project integration problem
I am developing this project using Spring Boot for backend and react for frontend, I connected this front end and back end. Then Sign Up and Sign in is working without any error but when I am going to get…
MYSQL – How to find registers with same data in a field, but different data in another field?
I'm trying to identify in my database which users are using other users' "IDs". MY DB: ID | NAME | CARDNUMBER | SHOPNUMBER 1 JO 1234 73839 2 ANDY 9876 79487 3 KARL 5432 87399 4 MIKE 1234 53637 I…
Setting mysql timezone same as php
I am trying to set the timezone for codeigniter v4 and if I set using php code, it is setting in IST, whereas the updated_at column is still at UTC timezone. From the below records the created_at and last_active_on, both…
Mysql – It seems that the characters are getting corrupted when stored in the database
I'm working on a project with Spring Boot and MySQL, and I’ve been storing data without any issues. However, in one specific table, data suddenly starts saving with encoding errors only for Korean text. It used to save Korean characters…
Mysql – The subquery has non-existent fields, but the entire SQL runs without any errors
When I ran this sql in MySQL, it didn't get any error. However, entity_id doesn't exist in table b. select entity_id from a where entity_type = 2 and is_deleted = 0 and entity_id in ( select strategy_id from b where…
Trouble Upgrading MySQL 5.7 to 8: The auxiliary tables of FTS indexes on the table are created in system table-space due to bug
My team and I are attempting to upgrade our multi-tenancy AWS RDS/MySQL instance from MySQL 5.7 to 8. After trying the upgrade, we received a report showing a large number of errors for the customers, and lineitems tables. Example Errors…