- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
Hi I would like to know how to create a MySQL statement with Count(*) and natural join. I have a table named iphead and another table named even. iphead has a number of IP addresses and I would like to count the total number using count(*). Next, the even table … | |
Hi, I have a thousands of IP addresses, repeating randomly in my database and I wish to print each IP address along with the number of times they are repeated. For example, 162.10.2.1 162.10.2.1 162.10.2.1 192.34.1.10 172.11.2.9 192.34.1.10 192.34.1.10 Output: 162.10.2.1 - 3 192.34.1.10 - 3 172.11.2.9 - 1 I … | |
Re:
Hello, I've this lise: [CODE]lst = ['10:User1', '80:User2', '100:User3', '00:User4', '75:User4', '45:User5'][/CODE] I want to print it as: [CODE]100 User3 80 User2 75 User4 45 User5 10 User1 00 User4[/CODE] So, I want to organize them by the number. |