Questions tagged as 'mysql'

Tagged questions
3
answers

Problem with records (Column count does not match value count at row 1)

I'm having the error "Column count does not count value at row 1" when I try to register. I have already checked my DB and everything seems to be in order but nothing to solve this error. My registration code. public void action...
asked by 18.11.2014 / 00:31
4
answers

Access website in local network through my Android phone

I made a site in PHP and MySQL responsive and would like to access it on my Android phone by localhost, I know I have to put my IP in the browser of the mobile phone but when I access it it appears the following error:    Forbidden You do n...
asked by 10.12.2014 / 23:41
3
answers

Convert string to MYSQL integer

What command can I use to convert string to integer in mysql? for example: I'm doing the following list of tables: SELECT mov . * , prod.produto, prod.unidade, prod.icms, prod.ipi, prod.codigo FROM movimentacao AS mov, produtos AS prod WHER...
asked by 25.04.2014 / 17:35
3
answers

Working with ID boundaries in large volumes

I have in mind some questions about large volumes of data in MYSQL , referring to the ID limit. I'll give an ID type tinyint as an example to simplify the explanation. In the example the field tinyint accepts 127 records....
asked by 06.08.2015 / 19:05
3
answers

Is there a way to do a + or - operation in a MySQL query?

Example: select quantidade from tabela where quantidade é mais ou menos = '5'; Does anyone know of any way to do this in MySQL? I have an approximate value of 5 and would like to bring it from the database in a query, but I do not know any...
asked by 06.05.2016 / 14:47
5
answers

How to reduce the search time in a table with more than 200 thousand records?

I'm having problems with listing and searching table data with more than 200,000 records. I read in searches, that for the search system, the ideal would be to do indexes of the type "fulltext" in the fields where it will be will have a searc...
asked by 31.08.2017 / 08:59
1
answer

Check for data in column [closed]

How can I check if there is data inside a column in a table? I want to do a check and if there is data in the column it displays a div . I know mysql_num_rows to add up the data that was fetched, but I wanted to know if it has...
asked by 24.10.2015 / 03:51
1
answer

Best way to model the database of a chat [closed]

I have an application that works with webServices and the mysql database, I'm putting a chat on it, the part about how to get messages, view notifications and search for users I already have, my question is: How should I store my messages in...
asked by 15.08.2014 / 19:58
2
answers

Skip seconds in the MySQL time field

I have a field in my table of type time , where I save my time. The problem is that it is saving like this: 10:30:01 , how do I save it just the hour and minutes. That is without the seconds? The field is thus in BD hora time D...
asked by 29.07.2016 / 15:27
3
answers

Is it possible to have more than one Primary key in a table?

I have a gym and I'm using Pk so all gym members have their own ID. Can I use other PK in the same table? For example: to prevent Número da Matricula or even CPF/RG are repeated, can you add PK to them?...
asked by 20.06.2017 / 20:00