Questions tagged as 'mysql'

Tagged questions
1
answer

I can not insert data into the array

I linked two drives to this product, but when I select it I have no way of linking to another new drive, since% is done at all, not being distinguished a new record that I try to link to As below, I am trying to register the drive code P1, af...
asked by 31.10.2017 / 20:46
1
answer

Compare Coordinates

In my mysql I have a column where it contains positioning coordinates coming from a polygon, drawn in google maps api, the question is how can I compare the coordinates I have inside the column with a specified coordinate coming from a GET I'...
asked by 26.03.2016 / 20:46
2
answers

Duplicate value in the table. How to remove?

I inserted a TSE tables into my database and have duplicate values from the SQ_CANDIDATO column representing the image placed above. How can I do a maintenance with sql that will remove ALL ID ? ... Leave only one SQ_CANDID...
asked by 06.03.2015 / 04:36
2
answers

Avoiding duplicate data by applying counter for usage log

In a simple form that writes the following data:    ID, IP, Date / Time, Name, Email, State / City. When a person fills out the form, this data is recorded in the database. But if the same user is to fill out the form again, a new record...
asked by 29.01.2015 / 00:36
3
answers

How to compare data with accents in the database?

I am having the problem in a search I made in that user filter content by district and county, it works fine when I choose district and county without accents but when I choose a district and a county that contains accents does not give me any v...
asked by 19.02.2015 / 01:19
2
answers

How to create this rule in mySQL

I have a field in my table: tipoEndereco char(1); However this field only receives two possible values, which are: 1-> i (Instalação) 2-> c (Cobrança) Because of this, I'm thinking, and I would like your opinion, to change i...
asked by 17.09.2015 / 15:53
2
answers

Add consecutive fouls

I am creating a journal module on line, I need to get students with 3 consecutive absences, follow the input select, when the student has more than 2 hours of class, select displays different. <select name="d_status[<?=$i?>]" size="1"...
asked by 24.09.2015 / 13:37
1
answer

Is there a parameter passing in a trigger?

I have two tables, one with the sessions and another with the activities. Within the activities table I have two fields, available and salable and within session I have vacancies. I would like to get the id of the session to be able to do the...
asked by 23.07.2015 / 20:33
1
answer

Allow access to a PHP page only 1 user at a time

I am creating a call answering system, and to avoid confusion when answering a request, I need to restrict the PHP page containing the call data to 1 access at a time for each caller user, so when someone another user on the same team can not ac...
asked by 29.05.2015 / 16:54
3
answers

Recover MySql table

I reinstalled WAMP and did not export the database (.sql), but I have the ".ibd" and ".frm" files. After installation, I created a blank database and copied all the ".ibd" and ".frm" files to the folder, but when trying to open the table via...
asked by 24.06.2014 / 14:04