Questions tagged as 'mysql'

Tagged questions
2
answers

How would the query return values in a given interval?

I have a table with the following rows : code (int) vaccine (varchar) dt_volution (datetime) I need a query to return all vaccines that will expire within 10 days, counting today's date. I tried something like this that I saw i...
asked by 23.01.2017 / 16:58
0
answers

Access Control Doubt [closed]

I want to make an Android application that CRUD performs on a MYSQL database. I've already figured out that the way to do this is to use Webservice . I'm new to this area but I've already done a simple PHP via REST and I've been res...
asked by 09.01.2017 / 22:43
0
answers

Remote Connection Mysql 5.6 and Ubuntu 15.10

I have a Droplet on DigitalOcean with Mysql 5.6 on Ubuntu 15.10. Normally for remote connection I change the /etc/mysql/my.cnf file in the bind-address = 0.0.0.0 parameter. It turns out that in this version the file my.cnf...
asked by 09.01.2017 / 04:46
2
answers

Error with select in mysql

I'm having an error log that does not happen often. On average 1 time per month. Problem is, I'm not picking the error. I'll put my select so you can see if something is wrong. $result = $mysqli->query(" SELECT SUM(a.qtd) FROM...
asked by 10.01.2017 / 11:18
1
answer

How to store multiple checkboxes

I'm creating a system and how could I store multiple checkboxes and inputs in mysql? I know I can do it this way but only if it goes to a column, in my case there are four how I could do    if (! empty ($ _ POST ['gender']) & count ($ _ P...
asked by 19.01.2017 / 01:24
1
answer

How to compile the database to install together with a C # application?

I'm developing a C # application, and I need to know if I can build the database to install with the application, I've already seen something here about SQLite, but I do not know the tool and I do not know if it stores images, my case will have...
asked by 18.12.2015 / 06:25
2
answers

Date field update in string format

Personal I took an old bank from a client where it has a birth date column that is in the string format and does not date. So far so good so that there are certain dates recorded that do not have 0 in the month or the day when smaller than 10. I...
asked by 13.02.2017 / 16:54
0
answers

How to check new fields inserted in a mysql table in real time? [closed]

In my work there is a database where a ratchet system inserts new fields into the table and the NodeJS application needs to check when new fields are inserted. What is the best way to monitor a table in real time? I researched and saw that...
asked by 12.02.2017 / 14:46
1
answer

insertion in related tables

Hello, I'm working with some related tables and I can not insert the values in the next rabla, I discovered that I need to retrieve the last id inserted in the I still can not use it, without the relation the tables work perfectly. Follow the com...
asked by 28.12.2016 / 21:34
1
answer

Add an array inside another

Hello, I researched how to add an array inside the other but the result was not quite what I expected. I have the following code: else if ($_GET['type'] == "listaJogos") { //echo 'Tipo de operação: ' . $_GET['type'] . '<br>'; $campeonat...
asked by 26.12.2016 / 17:23