diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-08-28 10:57:13 +0200 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2016-08-28 10:57:13 +0200 |
| commit | 957f66d407c7cd6ebc418f63df08d055218d8d92 (patch) | |
| tree | 17e67ef57474ecc64e87db5a3f2adc506229dd1e /schema/ip_import.sh | |
| parent | 6c4d69c480714a402d6c7cf0cce35abb106f6312 (diff) | |
| download | chd_gestion-957f66d407c7cd6ebc418f63df08d055218d8d92.zip chd_gestion-957f66d407c7cd6ebc418f63df08d055218d8d92.tar.gz chd_gestion-957f66d407c7cd6ebc418f63df08d055218d8d92.tar.bz2 | |
Handy script/sql to mass import some data in ippubliques table
Diffstat (limited to 'schema/ip_import.sh')
| -rwxr-xr-x | schema/ip_import.sh | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/schema/ip_import.sh b/schema/ip_import.sh new file mode 100755 index 0000000..31e960c --- /dev/null +++ b/schema/ip_import.sh @@ -0,0 +1,9 @@ +#!/bin/bash +cat <<"EOF" +INSERT INTO `gestion_demo`.`ippubliques` (`ip4`, `ip6`, `secteur_id`) VALUES +EOF + +for i in $(seq 1 254) +do + printf "('203.0.113.%i', '2001:db8:71:%x::', '1'),\n" $i $i +done |