MYSQL load data: Stripping out zulu time and converting ip addresses to unsigned ints.

Snip for me: Storing IP addresses compactly in MySQL

	-- Loads IPs as an unsgined int (create table :: ip int(10) unsigned NOT NULL)
	-- Trims out the zulu time timezone indicator 'Z' e.g. (2013-07-31T18:41:38Z,).
	-- See http://en.wikipedia.org/wiki/Coordinated_Universal_Time
	load data local infile 'xxxxx'
	into table blah
	fields terminated by ','
	ignore 1 lines
	(a, @ip, b, @ts1, @ts2)
	set ip=inet_aton(@ip),
	ts1=replace(@ts1, 'Z', ''),
	ts2=replace(@ts2, 'Z', '');

view raw load_data.sql hosted with ❤ by GitHub