Questions tagged as 'mysql'

Tagged questions
2
answers

Concatenate array of selected checkboxes to use as search filter

I have a search with several checkboxes that can be selected and added dynamically by the user. As I do not know the quantity, I was thinking of doing the following: go through all of them and go concatenating with AND and use that in the...
asked by 08.06.2014 / 05:45
3
answers

MySQL 6.1 Workbench CE does not start any more

I do not know if anyone here uses it, I tried to use it for the first time, downloaded it, installed it and used it the first time in a good way, I found it cool, I created a database, I shut down the PC and the next day it did not start at al...
asked by 25.07.2014 / 17:39
4
answers

SQL query returns total days in a month on two dates

I have the following tables: official : official_id other information ... history : official_id data_entrada data_out I tried some querys but could not get what I wanted. What I need is, after the user has chosen a mon...
asked by 31.08.2014 / 04:06
2
answers

How to save space in audit log?

I was creating a system that would give me data from my users according to the date I requested, from X to Y for example. And the only way I found it was to create a table like this: date with date inserted in DATE format name...
asked by 27.12.2014 / 18:55
2
answers

Read phpMyAdmin column with multiple records

I have a table in phpMyAdmin with a field that stores several values, the column is named as subfilter id, I need to read each value of that, since they are id's that are related to another table, the field is a varchar. p> The table is this,...
asked by 29.01.2015 / 01:16
1
answer

Problem with autocomplete

Good evening, I'm trying to auto-complete an input via query in mysql database, but I'm having problems. I did all the code following a tutorial and even then it will not, nor will any errors appear to me. When I type, there are no options to co...
asked by 13.09.2018 / 01:34
2
answers

PHP variable problem with peliculas [duplicate]

I'm bringing this variable from the mysql database into a text input, but the result I'm not able to show because of the peliculas. $cota = '946.9"1968/1975" AMA Ant'; echo '<input type="text" value="'.$cota.'" />'; result: 946.9...
asked by 23.02.2018 / 13:23
3
answers

Problems with SELECT RIGHT JOIN

I have two tables, A and B. In Table A, I have a column with machine names (Cortadeira, Baler, Packer and Rewinder) and in the other column some causes that made them stop Lack of Electric Power, Coil Replacement, etc). In Table B , I have a...
asked by 07.03.2018 / 12:29
1
answer

Search all records of a respective year and month

In my DB I have the date field of type date (YYYY-mm-dd). What happens is that I want to fetch all records for a given year and month. For example, I want to go fetch all the records for 2014 from month 08. How can I do this? I tried something l...
asked by 29.08.2014 / 18:08
1
answer

Command to display a limit of records in a table

Assuming a database has a locacoes table, which SQL command would display between the tenth and twentieth registers of this table, sorted by field titulo ?     
asked by 30.08.2014 / 02:27