Questions tagged as 'mysql'

Tagged questions
1
answer

Return only the last record entered in the MySQL database [duplicate]

Hello everyone, I have a project but I have to make a query and return it to the "last line" or last record inserted in the database.     
asked by 13.05.2017 / 20:09
1
answer

Parameter passing

I have the following code that passes the date that is in the MySQL database to the textblock: textBlock8.Text = (reader.GetString("Data")); What happens is that it is passing the date and time. I would like to spend only the date.     
asked by 31.03.2017 / 01:40
2
answers

Creating a MySQL default date string from a Java Date

I need to pass a string in this format: "yyyy-mm-dd + HH: mm: ss" (where the "+" should be a space) for a webservice from a Java Date object. How can I do this?     
asked by 28.03.2017 / 22:45
1
answer

Mysql Query - Get the next value greater than 0

Example, I need the query to return these circled values. The previous result was 0 (zero). The current one does not. I need to get the current value. And list     
asked by 26.05.2017 / 20:49
1
answer

List the last message of each user

Does anyone know how I could list the last message of each user? I was able to do this but list the last message of only one user, and I wanted it to list everyone who sent the message to the user in question (code 3). SELECT m1.codigo,...
asked by 27.05.2017 / 04:20
2
answers

Customers who bought in one year but not in another [closed]

I need to make a select that brings me which customers I bought in 2016 and did not buy in 2017 and vice versa. This is my select: SELECT tc.'cod-emitente' AS CODIGO, tc.'nome-emit' AS CLIENTE, fg.'ano' AS ANO FROM tb_clientes tc LEFT JOI...
asked by 26.05.2017 / 18:54
1
answer

table always active with Ajax and php

I'm studying, I'm a beginner, and I'm doing a site with php, jquery and ajax, everything's blz, so I need to load the data from the database and put it on a table, only the data has to be real-time , that if it has an inclusion in the database t...
asked by 25.03.2017 / 00:50
1
answer

Problem to open file

When I search for a .txt file to import, it returns me the warnings    Warning: fopen (Clients.txt): failed to open stream: No such file or   directory in /var/www/html/systems/help-desk/processa/proc_letxt.php   online 9       Warning: fget...
asked by 24.03.2017 / 14:28
2
answers

function to use query data

I'm building a function that via ajax makes the query a query in the database and via json returns the result. But everything else works I can not use the json object anywhere except inside the function. I have tried to use global variable de...
asked by 27.03.2017 / 22:41
1
answer

Save object with uppercase vs. lowercase letter

I think I had posted a question earlier than this, but I did not find it. I have a Manufacturer entity where I want to persist, to avoid differentiating between uppercase and lowercase letters, can I save an Object with all capital letters or...
asked by 28.03.2017 / 03:51