Questions tagged as 'mysql'

Tagged questions
1
answer

How do I select a date in the format dd / mm / yyyy in mysql? [duplicate]

Good morning / afternoon / evening I need to select a field of TYPE DATE in mysql, the data is in the format yyyy-mm-dd , I need to return dd/mm/yyyy . Is there any way to do this in select? I have seen solutions with...
asked by 03.05.2017 / 15:50
1
answer

item listbox (UWP)

With this code I add items to listbosx with the amount of registration I have. How to have a check before to know if the item of that record has already been added and does not act item with the same none of id? private void button_Click(obje...
asked by 14.03.2017 / 12:19
1
answer

Problem with MySQL Text field

I'm having a hard time storing a simple text field in my DB. I have the following textarea: <textarea class="txtarea" rows="4" cols="50" name="Text" id="txt_area_post" value="" placeholder="Insira uma descrição detalhada."></textarea&...
asked by 14.03.2017 / 20:02
1
answer

Select a row where a column has an element of a CSV

I have a table in the database with the following structure: +---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+--------------...
asked by 15.03.2017 / 18:35
1
answer

Data in listview (uwp)

How to display information from a MySQL database record in a listview? I tried it like this but it did not work. using (_connection = new MySql.Data.MySqlClient.MySqlConnection("Database=teste; Data Source=192.168.0.17;User Id=RFID;Password...
asked by 14.03.2017 / 14:25
2
answers

No Netbeans works, no Jar

I know you have some similar topics, but none answers my question. I created a program to insert information into the database and it works perfectly when I send netbeans to compile. I made Jar, and when I use the program from Jar, nothing...
asked by 15.03.2017 / 05:23
1
answer

Form, PHP and MYSQL - mysqli_num_rows always equal to zero

Friends, I'm doing pro bono work for a public service, and I've been trying to figure out what's wrong with my code for days. If anyone can help me, thank you very much. O formulário é esse: <html> <style> ::-webkit-input-placeh...
asked by 14.03.2017 / 18:12
1
answer

Alternative to the use of view variables in mysql

I need to create a view that gets the percentage of each product in relation to the total of products, I made the query below and it works as a normal select: set @total := (SELECT round(sum(gin.Caixa_9L /1000),4) FROM gin where sales_channel...
asked by 10.04.2017 / 15:20
2
answers

Two fields from one table associated with One field from another table

Hello, I'm developing a system that has a table named teams , and another table is called posts . Tabela equipes id, nome, foto Tabela posts id, titulo, id_time_1, id_time_2 What I really wanted and tried to do and did not succeed at is...
asked by 11.05.2017 / 18:34
2
answers

MYSQL: sort by specific rows within SELECT

I've been trying to resolve this for about three days and found the answer nowhere. I have a table in the database where I need to do a SELECT on all products but they need to be sorted according to the average between date X and date X, a ba...
asked by 04.03.2017 / 18:11