Posts by Humberto Costa • 21 points
5 posts
-
1
votes0
answers353
viewsQ: how to validate a number of columns of a csv file in php?
I’m making upload with a load data infile in php. Nesse upload would need to validate the amount of columns that have the file .csv. If the amount is different from the amount coming from the bank…
-
0
votes2
answers418
viewsQ: how to get a correct sequence in order by mysql?
has a sequence of numbers 1 to 20 I would like to know if you have the correct number sequence for example: 1,2,3,4,5,6,7,8,9,10,11... like this query select * from table order by numero asc; he…
mysqlasked Humberto Costa 21 -
1
votes1
answer86
viewsQ: How do I make a case when no load data infile?
I need to make a replace from the same column of several distinct strings, make a load data infile. Except that there is a syntax error on line 12 where the first case is, someone knows what I’m…
mysqlasked Humberto Costa 21 -
0
votes1
answer499
viewsQ: How do sum and Count in Mysql?
I have a query which brings the number of lines of a certain fault. select falhas, count(falhas) from tabela where semana = 'semana-5' group by falhas order by count(falhas) desc; The result brings…
mysqlasked Humberto Costa 21 -
0
votes0
answers116
viewsQ: How to add a value in an empty field in Mysql?
I’m spinning a query who needs to pick up the 5 first lines with limit 5. However, there are times when they will return less than 5 lines. The value comes empty, nor NULL, nor 0. I try to make a…
mysqlasked Humberto Costa 21