Can I combine these two Mysql queries?
I have a database with a lot of data in it already that is seperated by state, year, and quarter. So the DB layout is something like this: jurisdiction total_miles quarter year AL 300 3 2022 AL 500 3 2022…
Store number of likes of a post in MySQL
I am creating an application which will enable users to create posts and also like posts. I am using MySQL to store all the data. I have the tables users and posts. I want to prevent the situation where a…
I'm using amazon linux and trying to install mysql in ec2, but I keep getting the error "GPG key a is already installed" It happens
I am currently trying to install mysql in ec2, but the "GPG key" error keeps occurring. - errormessage [root ec2-user]# sudo yum install mysql-community-server Last metadata expiration check: 3:41:39 ago on Thu Jan 25 23:25:24 2024. Dependencies resolved. =================================================================================================== Package…
Updating wrong integer value in increment mysql Codeigniter 4
I want to increase integer value in blog post view. I used this code top of the controller in Codeigniter4: $db = ConfigDatabase::connect(); $builder = $db->table('blog'); $builder->set('view', 'view+1', FALSE); $builder->where('id', $id); $builder->update(); It is updating ..2,4,6,8.. in database instead of…
PyMySQL Data types
I'm new in Python and trying to learn MySQL as we import pymysql import pymysql from datetime import datetime conn = pymysql.connect( host = 'localhost', user = 'root', password = '', database = 'test' ) mycursor = conn.cursor() sql =…
Mysql – Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory
I'm connecting to a MariaDB database using PHP PDO library. When running the code on PhpStorm, everything works fine, but when running on LAMPP I get the following exception: 127.0.0.1:45536 [500]: POST /register - Uncaught PDOException: SQLSTATE[HY000] [2002] No such…
Mysql – SQL – Select values from one field that does not contain 0 value in an other field
Do you know how can i get values from Field 1 that does not contain 0 value in Field 2. For example I would like to select only "BBB" and "DDD" from the table below : Field 1 Field 2…
mysql configuration file order of read
I was reading about my.cnf in mysql docs and I dont understand this part On Unix and Unix-like systems, MySQL programs read startup options from the files shown in the following table, in the specified order (files listed first are…
Mysql – How to prevent decimal values entering in db?
-- Table: Cabin CREATE TABLE IF NOT EXISTS Cabin ( cabinID BIGINT AUTO_INCREMENT PRIMARY KEY, cabinType VARCHAR(150) NOT NULL, cabinDescription VARCHAR(255), pricePerNight BIGINT NOT NULL, pricePerWeek DECIMAL(10,2) NOT NULL, photo VARCHAR(50) ); INSERT INTO Cabin (cabinType, cabinDescription, pricePerNight, pricePerWeek, photo)…
Mysql – How to load last 7 days into a string(list)
I'm trying to create a program that watches and searches for any logs within given dates. How can I load the last 7 days in DATE format (YYYY-MM-DD) to a string/string list, or via SQL, or Qt/C++. Currently, I have…