Skip to content

Instantly share code, notes, and snippets.

@jdorfman

jdorfman/forloop-inet_ntoa

Created February 18, 2012 02:01
Show Gist options
  • Save jdorfman/1856871 to your computer and use it in GitHub Desktop.
Save jdorfman/1856871 to your computer and use it in GitHub Desktop.
Download ZIP
just in case you need to convert many IPs from numbers to addresses
Raw
forloop-inet_ntoa
for i in `cat ip-addresses`; do echo "SELECT INET_NTOA(${i});" |mysql -uanonymous |awk "NR==2" >> /tmp/ntoa; done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment