I found something weird while executing query today and i want to know how this happens. Below is my query: select sum(price) as total from table_a where test
My setup: late 2018 MacBook Air macOS Big Sur 11.5.2 MySQL 8.0.26 Community Edition I am trying to run an SQL file I downloaded by doing File > Run SQL Scrip
I'm trying to access "category" table with LEFT JOIN. I need to retrieve the field "name" in this table. This is my code: void Product::read(MYSQL *connection)
Stack I am using: Python 3.10.x FastAPI 0.75.x SQLAlchemy 1.4.3x Summary I am building a unifying FastAPI project for several legacy databases (stored back-end
I'm trying to understand InnoDB indices, but have some confusion. Are InnoDB indices (Clustered and Secondary) constructed only in cache or constructed in disk
I have used mysqldump to create a table that is 12GB from MySQL 5.7 to MySQL 8.0.29. I want to add a column using ALTER TABLE documents ADD COLUMN meta_data jso
I am working on a booking system where users can book certain services online. I am stuck on finding and displaying available time slots within a specific day.
I have a table in Mysql that looks like: CREATE TABLE `overig`.`test`( `ID` INT(10) AUTO_INCREMENT, `Order_ID` DECIMAL(10) NOT NULL, `Price_total` DECIMAL(12,2)
I am not able to connect to mysql from dbeaver in ubuntu 20.04, I am adding the error screenshot. mysql is ruuning on machine on the below ports mysqld 5846
I am trying to rename parent table in partitions. I created 3 child tables on year wise manner. I can alter the name of parent table but I don't know how to alt
as the title states. I do have the following table: CREATE TABLE exampleTable( ID int NOT NULL, Text varchar(255), PRIMARY KEY (ID) ); By inserti
I am working in MYSQL and Python. I have a table that stores users login information and want to make this secure. How do I add the salt after the first two cha
While I am trying to select a table on a MySQL data base, I am getting the following error: SQL Error [1064] [42000]: You have an error in your SQL syntax; chec
I am using a TablePress of wordpress library and try to display 100 rows per page in admin account , Not user page. How can i do that ?
I'm creating a new app and this time using MySQL instead of cassandra because it's much harder to learn and setup. I learned about MySQL clusters and chose to u
I am trying to set up MySQL reasonably secured, on Ubuntu 22.04, using Ansible. This is my playbook (from a post by Lorin Hochstein) See Ansible idempotent MySQ
I have a table for all orders made by users and I would like to send them their order summary in email. However I have managed to create a table showing the cu
In C# My Sql Entity Framework 6 Insert is return exception Cannot add or update a child row: a foreign key constraint fails (portaldb.masterselectionhistory, C
I am getting this error while I am trying to send a put request to update a row of a product table in mysql using nodejs. Here's my code: exports.updateProduct=
I need help figuring out what's wrong. I want to install phpmyadmin on a server to import a wordpress DB but when I install it I have a problem with php-twig I