Posts by FenixS2 • 39 points
5 posts
-
0
votes2
answers683
viewsQ: Is it possible to use Inner Join in several columns of the same table in a Select?
In the database there are 2 related tables. Collaborators: Events (here makes the input of training time by collaborator): I need to know the total training time of each sector. Select below works,…
-
2
votes2
answers301
viewsQ: Doubt to use Replace together with Inner Join
I’m using the Inner Join to combine two tables: SELECT eventos.colab_id, colaboradores.setor FROM colaboradores INNER JOIN eventos ON colaboradores.id = eventos.colab_id So far so good, however I…
-
0
votes1
answer141
viewsQ: Add comma-separated records - PHP + MYSQL
In mysql database I have the following table: Note that the column field is in json format. I have several records in a single field. I need a script to count each record separated by comma and add…
-
-2
votes1
answer190
viewsQ: PHP script for counting comma-separated records
In the databank I have a column that takes strings in this format: ["87","12","67"] What I need is to count each value separated by comma and assign to some variable, remembering that there are more…
-
-2
votes1
answer71
viewsQ: Doubt to count records in a Mysql database query
In a Mysql database, I have two varchar columns that bring me records in this format: ["165","184","192","209","242"] One more example: Each number in double quotes is a record, IE, is the ID of…