Posts by Mr Poke • 15 points
5 posts
-
0
votes0
answers31
viewsQ: How to convert DATETIME to DATE using NOW function?
Can you give me a hint of how I can get around the problem below ? The goal of the Query below is to return the number of times I have received ABANDON, CONGESTION and MACHINE service status during…
-
-1
votes1
answer70
viewsQ: Double quotes when exporting files
Can you ask me a question regarding the export of files in Mysql? , I have already given a search on but found no answer... Next, I have a table that stores the NAME of some clients, I need to put…
-
0
votes2
answers49
viewsA: HOW TO TREAT EMPTY VALUES IN SEVERAL COLUMNS?
I’ll put here how I solved this problem, maybe it helps someone in the future. Remembering that what I did here is not recommended but it was the way I managed to solve this problem until the…
-
-2
votes2
answers49
viewsQ: HOW TO TREAT EMPTY VALUES IN SEVERAL COLUMNS?
I have a TB that has 15 telephone columns, where several rows are empty. I need to turn these 15 columns into only one. Using UNION ALL and putting a condition in WHERE to get rid of the empty…
-
0
votes1
answer46
viewsQ: How to filter information when loading a local file?
Is there any way to ignore a certain information when loading a local file into Mysql? Example: I have a 2 column file: "PHONE" and "VALIDATED". The "VALIDATED" column has the values 'YES' and…