I want to do some testing without changing records' timestamps nor queries. My queries have NOW() in them, and I don't want to wait. So is there a way to tempor
I am running into issues trying to start my database locally with Docker. I keep receiving the error: 2022-03-05 15:43:51+00:00 [Note] [Entrypoint]: Entrypoint
When I open XAMPP and click start MySQL button and it gives me an error. I had started it just before, but now it isn't working. It given error below in xammp E
as you can see in my picture i have got an eer-model with 6 tables. Now I want from the table "catalog" the "ItemID", from "Users" the "UserID" and from "Roles
There are two columns in a MySQL table: SUBJECT and YEAR. I want to generate an alphanumeric unique number which holds the concatenated data from SUBJECT and
I have a project where certain records in a table will "expire" after so many days. I use soft deletes so basically all I have to do is set the deleted_at colum
I need to save into database list of prefix valid sms mobile phone number including operator name from "ALL COUNTRY". For example: PREFIX: +62812 COUNTRY: INDON
I have a web app with Python and Flask that takes user input and stores it in a database, then I populate all the data in an HTML file. However, I want the user
I have to allow my users to make an update with 24 hours of delay from their previous update, so because date operations in this case are going to be on the bac
I got a customers table with this column: hashtag VARCHAR(255), that contains lowercase words separated by white spaces. We added a new table: hashtag ( id INT,
So I have a SQL column that stores data like this. "[1338,0,8523]" I was wondering if I can then garb each one individually and because the value is minutes, i
I've made this ER diagram for my college project but i have to use forward engineering to see SQL code. MySQL version is 8.0.27 when i try it, it come up with e
Within a TYPO3 10 extension I would like to access an external MySQL-database that contains a table with two fileds like "name" and "firstName". For this I adde
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.