horodchukanton/Fill_last_ip.sql

Created August 4, 2016 11:49

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/horodchukanton/8647a76e7c60eb939c4a9e14baa3d619.js"></script>
Save horodchukanton/8647a76e7c60eb939c4a9e14baa3d619 to your computer and use it in GitHub Desktop.

Download ZIP

Automatic fill of last range ip address

Raw

Fill_last_ip.sql

UPDATE dhcphosts_networks SET ip_range_last = INET_ATON(INET_NTOA(ip_range_first + (INET_ATON('255.255.255.255') - INET_ATON(INET_NTOA(mask))) - 2 ))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment