Table tblStudents columns: id, name, gender, SchoolName, SchoolId. Table tblSchool columns: id, name, location. select name, (select name from tblStudents as a where a.SchoolId=id limit 1) from tblSchool; I am looking to return SchoolName along with the first student enrolled…
For example, 2024-09-09 13:00:00 will be 2024-09-09 13:05:00 2024-09-09 13:00:50 will be 2024-09-09 13:05:00 2024-09-09 13:01:00 will be 2024-09-09 13:05:00 2024-09-09 13:04:00 will be 2024-09-09 13:05:00 2024-09-09 13:04:59 will be 2024-09-09 13:05:00 2024-09-09 13:05:00 will be 2024-09-09 13:10:00 The answers…
I am currently building a simple eccomerce platform using react, express js and mysql as database. now as i am retrieving data from the database to produce the products it does replicated it self into multiple instances like, product 1…
When I select all columns, the indexing does not work, but if I select just a few columns, it does. mysql> explain SELECT * FROM fatura USE INDEX (datapago_serv_pago) WHERE id_servidor = 10 AND pago = '1' AND data_pago <=…
I'm trying to use this to get contents of a specific table: let tablename = req.body.login connection.query('SELECT * FROM ?', tablename, (err, rows) => { if (err) throw err res.send(rows) }) But due to tablename being a string, it gets…
Wondering if it's possible to remove results with the same value. I have a payments table containing ADJUSTMENTS and REFUNDS entered as AJUSTE and ESTORNO. While both can exist in an invoice, if the total sum of each are equal,…
I want to sort/order a query in laravel. For example I have a model where 'id' ranges from 1 to 100. And I have an array of ids of selected model elements eg. [1,3,12,32,...]. I want to sort my model…
I'm trying to insert new users to a table in MySQL when they register. I am using a FlaskApp on PythonAnywhere. Here is my query: INSERT INTO user_profile (email, user_name, first_foo) VALUES (%s, %s, 0); This is run from my…
I want to make sure a specific MySQL account can't dump the whole database, or any table, in any way - be it using MYSQLDUMP or SELECT *, etc. I'd be happy to limit all queries from that account to…
I have a mysql table which has two columns id and attendancetime, I want to select count(id) hourly. id attendancetime 1 1725256398 2 1725258398 3 1725264581 4 1725277777 5 1725277777 6 1725277777 7 1725298931 8 1725299156 9 1725299156 My expected…