Questions tagged as 'mysql'

Tagged questions
1
answer

How to make a simple shopping system? [closed]

Example: I have a product with 10 units registered in a database, a customer buys 1 unit, this unit gives low and quantity of the product goes to 9 units. How to express this in PHP?     
asked by 16.11.2015 / 00:15
1
answer

Syntax error while testing the query in phpmyadmin [closed]

Error resolved. Query SELECT i.codiniciativa, te.nome as nome_tema, te.codtemaestrategico as cod_te, p.observacoes as per_obs, te.sequencia as tem_sequencia, p.sigla as per_sigla, p.nome as nome_perspectiva, p.co...
asked by 31.08.2016 / 22:09
2
answers

How to leave a php application running on the client's pc even if the connection to the server goes down? [closed]

By rectifying the previous question, I inform you that my idea is to let the client navigate between application pages , log in locally, and retrieve that data when the connection is restored.     
asked by 28.02.2016 / 22:11
1
answer

MySQL Simple Query [closed]

I know very little about SQL and I'm thinking of a very simple system - but I do not know how to mount it and it's for a public school that can not hire a programmer at the moment. I have a table in SQL with some student enrollment data and e...
asked by 14.08.2017 / 20:19
1
answer

Calculate time between dates in mysql [closed]

I have a log table with a TIMESTAMP column that records the user's login and logout time. I need a select that compares the user login and logout time to calculate the time that the user logged in. It sounds simple, but I'm not making...
asked by 17.05.2016 / 20:22
1
answer

How do I select in Mysql to get this result

I have 3 tables, I would like the return of the select to come with a value of 0 when it is not in the related table. Example tables The example shows the option data that it contains in the poll table, but would like it to show 0 if it...
asked by 20.10.2017 / 20:24
1
answer

How to break the table row with mysql data

Hello, I made a request system and I would like to know how I can do to break the line after the commas. So when I print the application in the kitchen it comes as follows Tambaqui Rib: 1 Fake Smoking: 1 Fanta Orange: 1 Fanta laran j...
asked by 29.01.2017 / 00:27
1
answer

how do I join inner join with these tables?

How would the SELECT query in Mysql of the Inf_musics table be?     
asked by 16.02.2018 / 03:17
1
answer

SELECT SQL WITH WHERE "DOUBLE" [closed]

I am trying to query the MySQL database with the following syntax SELECT id, codigo, faca, descricao, vendedor, imagem FROM produtos WHERE sit = 1 AND descricao = ESTE Until this part it works perfectly: SELECT id, codigo, faca, descr...
asked by 16.08.2018 / 18:32
2
answers

SQL Query with multiple conditions WHERE [closed]

I was trying to make a search system that searched in 2 fields of the table at the same time and could have several conditions in the WHERE of SELECT, I searched in several places and I found this query, but when I was running it gave the error:...
asked by 22.06.2018 / 19:24