If you have a local database, Staging/UAT database, Production database 1)Say 10 developers have the database script to generate the database (I'm using liquiba
I have a database where I store all transactions made in a game (picture of DB). Now I want to get the value of the last transaction for each player. I already
How can I replace a specific value in MySQL if it's exist? I have a servers table in that table I have an opts row the row's value is: +set net_port 28112 +set
I have a MySQL database And I want to add a column: MariaDB [(none)]> use myDatabase; Database changed MariaDB [myDatabase]> ALTER TABLE material add new
I have connected to the database on MySQL, and was able to input data to a table. However, I am not able to input data to another table when it seems that I'm u
I have connected to the database on MySQL, and was able to input data to a table. However, I am not able to input data to another table when it seems that I'm u
First things first, I'm new to the forum, anything I write that isn't concise or just flatt out adjective let me know! I'm developing an app that can retrieve d
I have the following table of orders for users like the following: CREATE TABLE orders ( order_id UUID, user_id UUID, date date,
There are 2 tables ost_ticket and ost_ticket_action_history. create table ost_ticket( ticket_id int not null PRIMARY KEY, created timestamp, staff bool, statu
I have seen a 2 years old similar question to this but the question did not specify the MySQL version and there is no answers to the question. I'm use the djang
I have a knex chema migration to create a table, with the line - exports.up = async function(knex) { return knex.schema.createTable("newTable", table => { ta
I have a knex chema migration to create a table, with the line - exports.up = async function(knex) { return knex.schema.createTable("newTable", table => { ta
I migrated my data to M1 Monterey MacOS from intel macmini. I was happy to use django and mariadb until I installed a package using homebrew. I installed homebr
I have a requirement to create a room reservation system with dynamic booking slots (a reservation can start at any time and last anywhere from 15 minutes up to
I'm trying to make a history page where users can see the videos they recently uploaded or downloaded. I'm writing it in NextJS. I'm using Mysql to store the da
Foreign key 'FK_NhanVien.....' references invalid table 'PhongBan". Why is it invalid? create table NhanVien( MaNV varchar(9) not null primary key foreign k
I have one table with below column Table I want to find missing nodes Missing node definition: node present on day and missing the next day will be missing node
Just want to ask if how can I use the INNER JOIN function on CodeIgniter 4? I'm trying to convert the SQL statement below to CodeIgniter 4 but since I'm just ne
Let say yesterday was Wednesday; I need to get all records for Wednesday of previous week. How to achieve this in MySQL statement condition?
CodeIgniter 4 has a handy solution for migrations and seeders. Without the usage of foreign keys, everything is working perfectly. But when I use foreign keys I