Questions tagged as 'mysql'

Tagged questions
0
answers

MYSQL - Detect break in sequence, with conditional

Hello, I need help to make a query or procedure to detect gaps in a numeric field, I have a fiscal invoice table, which has a num_nfe field, it must follow a sequence, there can not be gaps in the numbers and I must check in another field, the s...
asked by 20.04.2018 / 14:29
3
answers

No select error using mysqli_query

I've done a php to list the rooms, but I'm having difficulty listing them, if anyone can help me, I would appreciate it. <?php $link = mysqli_connect("localhost","root","","hotel"); $result = mysqli_query("SELECT descricao FROM quartos WHER...
asked by 08.06.2015 / 21:53
1
answer

Create report displaying total and subtotal

I need to create a report in PHP in which the information will be searched in MySQL. In MySQL I have a boleto list issued, in which the majority has been removed. In this table (Historico) it has the following fields: Bold_Code Customer...
asked by 23.03.2018 / 21:06
0
answers

INSERT Database

I have a system similar to Vagalume / Spotify Where the artist has his page with the album list, and within the album, the songs ... But there are music with several artists participating in the title, I would like to use for example: Kid...
asked by 09.04.2018 / 00:05
0
answers

Maps Api JavaScript - Problem saving site search in MySql database

I need the user to click on the save button that is displayed when the marker is clicked, the location information is saved to the database. Hidden fields that receive values from the location when searched: <input type="hidd...
asked by 08.04.2018 / 00:13
3
answers

How to do SELECT on more than one database table?

I have two tables in the database: zip and users. Can I make a single query to get fields from the two tables? Both have idCep. I want to get the address data from the cep table and the name and user of the users table. As I'm working with ph...
asked by 25.04.2016 / 20:31
0
answers

Compare data from two different DBs

Good morning, I have the following scenario: BD1 from third parties where I can only perform queries. I created a web page to display the data from BD1, in case it would be a table where I have a field with a combobox that I have some optio...
asked by 19.04.2018 / 16:22
2
answers

Error handling hours in mysql

I'm having a problem to accomplish adding time to a field in mysql. Using the    date_add (Arrival, interval ". $ item [6]." minute) ...       ADDTIME (Arrival, "$ item [6].") ... The two in a given circumstance, return the value of '25:...
asked by 05.04.2018 / 14:00
1
answer

mysql random questions

I have a somewhat complex and helpful question: I have a database with the following links: Exemplifying:IaminhistoryclassonKarlMarx.Thisclassislinkedtoacertain"subject" group of Karl Marx that has a bank of 100 questions. However, of tho...
asked by 20.03.2018 / 06:35
0
answers

Too much query delay in MySql only

Here in the company we have PG and MySql databases, these two banks are networked and identical in structure and data, where a "robot" performs this mirroring between them every 10 minutes. So far so good ... It turns out now that the bases ar...
asked by 15.03.2018 / 18:38