I created a display page using php where all users records are displayed in a table and there are delete and edit buttons to manage users, for the delete option
I need to display data from the 'Members' table based on the selected 'grad_date' from a drop down. I have been trying to do it for a while now but have struggl
I have been trying to sort out my mysql records with mysql queries but seems like its just impossible to do it in the natural order. I have values such as a1, a
I am using Flutter for mobile app development. I need to make a POST request to a PHP file in order to save data in my MySQL server. However, I check the reques
I have recently attended an interview on SQL. Below is the question: Write a query to retrieve city name, state name, city population and return the following c
UPDATE There has been quite a few changes in the code, but the problem still persists. I was able to delete from the customer table (and the entire row on the D
Im making an API on nodejs with express and mysql. In the POST method i dont get any error but on mysql store al values as 0, like this: 1 0 0.00 0000-00-00 0
I have read almost all related questions. but its not working for me. I am trying to traverse through whole child parent data to do so I have made recursive sto
I recently started Flutter. I want to make a simple contacts application with "mysql1" but I failed to pull the data. I installed the MySQL plugin in VS Code an
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