So I need help in trying to make a database field where it's default 7 and each day minuses 1 until its 0 then the day count starts again from 7. Is it possible
I am new to aws. I have a mysql rds instance and I just created 2 read replicas. My application is written in Java, and what I have done up until now is using
I have two database tables. First table: | ID | Sub-Name | Marks | 01 | french | 50 | 01 | russian | 50 | 02 | french | 30 | 02 | russian
I try to create a table using sequelize it goes fine with no error but instead of creating a table is show this message as a result Executing (default): SELECT
enter image description here I am trying to map some entities to tables in MySQL database using Spring Boot JPA. I have a problem with one of the tables because
I'm using MySQL 5.7.12 and this is my query. select objectid, (JSON_EXTRACT(fullobject, '$.mail')) as mail from openidm.managedobjects where objecttypes_id=5 a
I try to create a table using sequelize it goes fine with no error but instead of creating a table is show this message as a result Executing (default): SELECT
What I currently have is: UPDATE card, records IF(records.date_returned == null) THEN SET card.last_seen = records.date_loaned ELSE SET card.last_seen = records
So my goal is to output some mysql info to a table. I want it to start a new column every 18th record. Here is my current code: $hostname = "localhost"; //SET
I was hoping you could help me figure this out. I would like to run a query that would search a table and all it's rows and the date matches the current month.
I am using PREPARE statement in store procedure but it is taking much time at the time of records insertion. Please suggest me the replacement for PREPARE state
I am working in grafana with MySQL. I have a template variable and it has multiple values and I want to use that template variable with MySQL query using 'like'
I have select with more then 70 milion rows I'd like to save the selected data into the one large csv file on win2012 R2 Q: How to retrieve the data from MySQ
I'm creating a database for all the Magic the Gathering cards... The card table looks like this: cardID name text rarityID colorID editionID other colu
I have created a Stored Procedure in a MySQL DataBase that have 2 output parameters like this (for Example) : CREATE PROCEDURE `invite_user`(fUName VARCHAR(15)
I am trying to output data from 2 different tables in my database which are joined by a junction table. Table 1: musician Columns: musicianID, surname, fName
I have a table table_categories (id INT(11), cname VARCHAR(25),survey_id INT(11)) I want to retrieve the values for the column cname without duplication, that
In my code, I have my registration page send out a verification email once the form is filled out and submitted. They receive the link to their email to verify
I am dynamically forming MySQL statements in PHP and can't figure out why this one is failing to execute: INSERT INTO users ( `email`, `pa
I have a table with 60 boolean (TINYINT(1)) searcheable columns. User has possibility of using any subset of the given columns as search condition. Based on tha