Query the name of any student in STUDENTS who scored higher than 75 marks. Order your output by the last three characters of each name. If two or more students
I'm trying to install Joomla 2.5.14 and getting Installation notice INSTL_ERROR_INITIALISE_SCHEMA. Do anyone know the reason for this? Does it required CREATE R
I try to perform this query with Zend DB: $this->db->query(" CREATE EVENT turn_tonormal ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVA
I have multiple csv files generated everyday with same name and they should be imported to Mysql database . I can import a single file to table where I have def
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