Select statement display all ip-addresses of a subnet
Hi,
I'm not new in Mysql, but my knowledge is just some basics of SQL. I hope somebody could help, because first I'm not sure if it is possible what I'm looking for and further, what do I need to look for :S
Here my question:
I have a table called network_addr which consist of the fields:
- id_network, network_addr, mask
As network_addr is stored in decimal format and mask in number of bits, I can calulate how ip-addresses this network could contain.
Now the question is, is it possible by an sql statement to print a table with all possible ip-addresse?
Hope somebody could help me.
Thanks!
Subject
Views
Written By
Posted
Select statement display all ip-addresses of a subnet
3237
October 08, 2012 04:30PM
1598
October 09, 2012 11:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.