Questions tagged as 'mariadb'

Tagged questions
1
answer

Why does not this sql query work for me?

The first_advisory column is of type DATE, I put an image of the records entered so far: Making this query: SELECT primer_aviso FROM tabla_principal WHERE 'primer_aviso' < '2017-12-01' Is not it supposed that only records that a...
asked by 18.12.2017 / 18:30
4
answers

Avoid quote (') when using INSERT in java

Good morning, I am encountering a problem when performing the INSERT command in java. One of the fields is the name of the game, and being in English there are some that include a quote ('), that is why if for example the name of the g...
asked by 27.02.2017 / 23:23
1
answer

Query with Node Js and MariaDb

I'm trying to do a query with Node and MariaDb , but I'm getting this error:    GET / - - ms - -   (node: 3244) UnhandledPromiseRejectionWarning: Error: pool is closed       at Object.module.exports.createError (/Users/dmn/Desktop/apirestI...
asked by 06.12.2018 / 17:01
2
answers

SQL query with mariadb in which the first 3 rows will be shown and the last row added with their position to make a classification

I'm doing a classification for a game, to do the classification I'm using the following query with MariaDB 10.1.21 : SELECT @rownum:=@rownum+1 'posicion', nombre, dificultad as fallos, palabra, fecha, id F...
asked by 04.01.2019 / 14:17
1
answer

Error Call to undefined function storage_patch () when I run a seeder in laravel

I'm trying to run a seeder but I get the error: Call to undefined function storage_patch() I could not find the one. I have a table in migration called user with the sgts fields: use Illuminate\Support\Facades\Schema; use Illuminate\...
asked by 26.10.2018 / 21:08
2
answers

How to save array of select Mariadb and save values in different variables (not the complete array) PHP?

Hello, I have a function that returns an array but I want to access by means of its indexes to the value that I want from the selected fields in the database, for example, to save the variable at the index [0] in other words the first value of t...
asked by 13.09.2017 / 21:19
1
answer

how to make a difference in mysql?

I have the Table A: ------------------- * fechaA * ------------------- * 2017-09-01 * * 2017-09-02 * * 2017-09-03 * * 2017-09-04 * * 2017-09-05 * * 2017-09-06 * * 2017-09-07 * * 2017-09-08 * *...
asked by 18.09.2017 / 17:05
2
answers

Mariadb: inner join of two queries

I have a table that relates reflections to categories to which it belongs. idReflexion | idCategoria --------------------------------- 1 | 2 1 | 3 1 | 5 2 | 3 2 |...
asked by 21.08.2017 / 13:22
2
answers

Constraint or trigger greater than 18 SQL

I need to check when adding a "voter" in the database if it is over 18 years old, I have tried it with a constraint and a check, but it does not support functions for the current date. What other options are there? ALTER TABLE votantes ADD CON...
asked by 30.01.2017 / 11:04
2
answers

How to join 2 elements of different tables and that match?

I have this relationship diagram, I want to show the names of the teachers and the name of the subjects they taught. I have seen that with some query Join can be done but I have tried several and it throws me an error or shows me only the...
asked by 25.10.2018 / 23:37