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.
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