SQL Insert Into

[warring 55]

Zdravím

 

potřeboval bych aby mi někdo udělal z tohoto sql

 

 

85.70.93.23

85.71.128.226

93.91.150.11

85.162.117.113

193.179.133.81

62.197.215.14

88.102.230.232

46.13.82.32

78.141.102.191

84.42.202.244

85.159.104.244

93.99.158.22

195.3.171.77

188.120.211.52

77.93.216.69

193.110.186.167

178.40.204.30

79.141.249.180

95.102.139.11

91.148.24.132

95.103.33.219

93.181.114.226

78.99.198.7

88.86.120.23

91.127.24.76

188.175.113.50

78.110.212.254

194.1.224.24

212.5.197.134

82.202.65.65

62.197.209.72

84.16.103.118

88.212.37.175

217.196.212.84

85.135.148.140

77.234.235.9

92.62.224.26

88.100.56.250

94.127.128.125

90.177.48.14

84.245.95.72

78.136.150.90

77.87.237.69

81.30.230.193

217.12.56.166

82.144.133.1

95.102.207.126

78.156.32.226

90.180.30.196

178.41.252.137

89.103.145.182

188.121.175.60

109.80.134.192

109.80.115.247

94.112.253.123

178.40.158.1

212.24.143.110

85.132.201.232

78.108.154.1

87.197.0.169

195.113.181.200

213.194.220.155

94.236.230.46

78.128.149.110

94.136.135.6

217.29.9.13

90.176.147.85

88.102.17.90

85.119.89.41

217.196.211.74

80.239.242.30

109.80.23.5

92.63.52.50

178.22.113.254

88.101.79.131

89.203.192.10

217.12.62.38

94.228.85.147

85.216.214.70

62.168.111.58

176.61.198.1

178.40.123.18

178.40.109.105

188.123.104.113

85.70.103.184

178.40.191.160

88.212.40.191

88.103.160.246

178.40.5.20

195.168.36.198

90.177.123.210

92.62.231.194

82.117.152.114

90.178.194.137

91.227.224.250

88.212.37.81

178.40.104.245

88.83.169.30

77.87.237.90

188.167.37.63

212.71.186.64

85.70.225.228

213.160.188.199

77.48.103.32

85.135.82.30

92.52.10.213

188.75.128.2

213.151.228.214

90.180.24.106

212.26.164.223

31.130.165.125

77.48.44.2

95.103.177.173

78.157.164.214

62.168.43.61

188.244.56.235

78.45.173.125

188.167.46.63

89.173.106.29

88.103.55.107

89.103.122.107

81.201.60.245

91.127.100.172

80.188.175.14

178.223.30.226

89.173.153.183

85.71.235.154

188.246.97.42

82.117.156.243

86.61.240.164

78.99.99.247

95.103.203.44

85.207.220.25

92.245.5.69

82.117.156.61

178.40.72.228

90.183.120.1

93.99.63.250

77.234.244.206

84.244.92.50

90.178.176.175

77.48.244.138

193.85.151.98

77.237.142.133

90.178.22.179

93.157.129.182

93.157.130.65

78.80.77.98

178.41.107.201

95.102.0.109

188.244.54.100

217.31.45.161

77.48.180.2

95.103.10.8

91.148.30.123

217.31.44.192

31.130.162.13

81.200.57.132

90.178.144.46

77.48.45.198

217.29.8.207

178.41.206.37

87.244.250.217

88.102.163.99

90.176.227.246

178.40.78.215

91.127.102.76

82.100.0.156

217.112.172.140

89.203.212.186

109.80.12.93

77.95.193.202

80.242.33.36

95.102.1.18

80.87.208.133

85.237.227.37

90.177.35.25

217.12.57.26

88.102.199.20

81.30.248.23

213.151.253.6

94.74.229.90

88.100.205.177

217.117.209.219

62.169.190.100

213.29.248.61

94.199.199.220

90.183.16.21

82.99.191.11

88.146.164.126

85.132.142.41

178.40.93.199

94.242.64.214

91.229.254.100

85.71.202.134

95.103.211.252

85.70.197.39

83.208.85.75

46.237.96.224

188.121.189.112

93.157.130.110

212.96.177.115

94.113.159.223

83.208.28.94

62.168.45.106

88.212.37.160

94.127.132.30

81.200.51.130

188.131.74.32

213.195.216.101

87.197.49.57

78.157.137.2

85.70.240.166

81.200.56.24

88.100.30.65

217.29.9.75

188.175.233.242

95.103.135.44

195.98.10.11

89.176.130.9

88.212.40.144

77.48.218.252

77.48.106.46

62.240.190.170

77.48.218.233

89.203.143.39

109.72.4.149

81.200.56.33

95.102.29.205

195.168.75.168

193.85.151.2

81.19.35.122

83.208.7.111

93.99.99.6

109.74.148.232

109.231.128.30

217.29.8.135

89.102.60.36

46.167.192.253

85.162.211.22

88.102.149.23

90.177.100.83

178.41.30.26

194.228.164.205

95.102.89.160

188.175.98.89

78.111.126.202

89.103.178.243

81.200.54.248

193.179.175.210

109.164.3.131

90.181.16.251

90.179.101.72

88.103.228.58

93.89.111.27

178.41.155.88

95.103.42.172

77.48.243.34

82.100.0.179

109.107.211.130

85.135.133.222

95.102.31.159

46.33.96.6

80.188.6.9

91.148.9.151

62.209.207.5

46.33.96.8

85.71.186.126

95.102.152.137

78.102.246.41

88.101.173.186

78.102.54.123

78.128.198.60

90.177.190.73

81.90.173.235

46.229.124.144

188.116.77.103

88.101.174.43

78.98.234.81

77.92.215.188

95.103.57.125

94.199.199.212

78.141.86.123

109.205.72.16

83.208.6.218

82.117.130.2

 

 

 

Typu

INSERT INTO tabulka (`ip`, `casvyprseni`) VALUES ('95.103.27.125', 'D');

 

tabulka je jmeno tabulky (jmenuje se tabulka)

[snv 29]

zadarmo ani kura nehrabe

 

to si taky lenivy ?

 

staci INSERT INTO tabulka (`ip`, `casvyprseni`) VALUES ('95.103.27.125', 'D'); ('85.70.93.23', 'D'); a takto davat ip zaradom

[Xmat 566]

Carka, ne strednik mezi jednotlivymi zavorkami hodnot.

[Pick 34]

 

 

INSERT INTO tabulka (`ip`, `casvyprseni`) VALUES

('85.70.93.23', 'D'),

('85.71.128.226', 'D'),

('93.91.150.11', 'D'),

('85.162.117.113', 'D'),

('193.179.133.81', 'D'),

('62.197.215.14', 'D'),

('88.102.230.232', 'D'),

('46.13.82.32', 'D'),

('78.141.102.191', 'D'),

('84.42.202.244', 'D'),

('85.159.104.244', 'D'),

('93.99.158.22', 'D'),

('195.3.171.77', 'D'),

('188.120.211.52', 'D'),

('77.93.216.69', 'D'),

('193.110.186.167', 'D'),

('178.40.204.30', 'D'),

('79.141.249.180', 'D'),

('95.102.139.11', 'D'),

('91.148.24.132', 'D'),

('95.103.33.219', 'D'),

('93.181.114.226', 'D'),

('78.99.198.7', 'D'),

('88.86.120.23', 'D'),

('91.127.24.76', 'D'),

('188.175.113.50', 'D'),

('78.110.212.254', 'D'),

('194.1.224.24', 'D'),

('212.5.197.134', 'D'),

('82.202.65.65', 'D'),

('62.197.209.72', 'D'),

('84.16.103.118', 'D'),

('88.212.37.175', 'D'),

('217.196.212.84', 'D'),

('85.135.148.140', 'D'),

('77.234.235.9', 'D'),

('92.62.224.26', 'D'),

('88.100.56.250', 'D'),

('94.127.128.125', 'D'),

('90.177.48.14', 'D'),

('84.245.95.72', 'D'),

('78.136.150.90', 'D'),

('77.87.237.69', 'D'),

('81.30.230.193', 'D'),

('217.12.56.166', 'D'),

('82.144.133.1', 'D'),

('95.102.207.126', 'D'),

('78.156.32.226', 'D'),

('90.180.30.196', 'D'),

('178.41.252.137', 'D'),

('89.103.145.182', 'D'),

('188.121.175.60', 'D'),

('109.80.134.192', 'D'),

('109.80.115.247', 'D'),

('94.112.253.123', 'D'),

('178.40.158.1', 'D'),

('212.24.143.110', 'D'),

('85.132.201.232', 'D'),

('78.108.154.1', 'D'),

('87.197.0.169', 'D'),

('195.113.181.200', 'D'),

('213.194.220.155', 'D'),

('94.236.230.46', 'D'),

('78.128.149.110', 'D'),

('94.136.135.6', 'D'),

('217.29.9.13', 'D'),

('90.176.147.85', 'D'),

('88.102.17.90', 'D'),

('85.119.89.41', 'D'),

('217.196.211.74', 'D'),

('80.239.242.30', 'D'),

('109.80.23.5', 'D'),

('92.63.52.50', 'D'),

('178.22.113.254', 'D'),

('88.101.79.131', 'D'),

('89.203.192.10', 'D'),

('217.12.62.38', 'D'),

('94.228.85.147', 'D'),

('85.216.214.70', 'D'),

('62.168.111.58', 'D'),

('176.61.198.1', 'D'),

('178.40.123.18', 'D'),

('178.40.109.105', 'D'),

('188.123.104.113', 'D'),

('85.70.103.184', 'D'),

('178.40.191.160', 'D'),

('88.212.40.191', 'D'),

('88.103.160.246', 'D'),

('178.40.5.20', 'D'),

('195.168.36.198', 'D'),

('90.177.123.210', 'D'),

('92.62.231.194', 'D'),

('82.117.152.114', 'D'),

('90.178.194.137', 'D'),

('91.227.224.250', 'D'),

('88.212.37.81', 'D'),

('178.40.104.245', 'D'),

('88.83.169.30', 'D'),

('77.87.237.90', 'D'),

('188.167.37.63', 'D'),

('212.71.186.64', 'D'),

('85.70.225.228', 'D'),

('213.160.188.199', 'D'),

('77.48.103.32', 'D'),

('85.135.82.30', 'D'),

('92.52.10.213', 'D'),

('188.75.128.2', 'D'),

('213.151.228.214', 'D'),

('90.180.24.106', 'D'),

('212.26.164.223', 'D'),

('31.130.165.125', 'D'),

('77.48.44.2', 'D'),

('95.103.177.173', 'D'),

('78.157.164.214', 'D'),

('62.168.43.61', 'D'),

('188.244.56.235', 'D'),

('78.45.173.125', 'D'),

('188.167.46.63', 'D'),

('89.173.106.29', 'D'),

('88.103.55.107', 'D'),

('89.103.122.107', 'D'),

('81.201.60.245', 'D'),

('91.127.100.172', 'D'),

('80.188.175.14', 'D'),

('178.223.30.226', 'D'),

('89.173.153.183', 'D'),

('85.71.235.154', 'D'),

('188.246.97.42', 'D'),

('82.117.156.243', 'D'),

('86.61.240.164', 'D'),

('78.99.99.247', 'D'),

('95.103.203.44', 'D'),

('85.207.220.25', 'D'),

('92.245.5.69', 'D'),

('82.117.156.61', 'D'),

('178.40.72.228', 'D'),

('90.183.120.1', 'D'),

('93.99.63.250', 'D'),

('77.234.244.206', 'D'),

('84.244.92.50', 'D'),

('90.178.176.175', 'D'),

('77.48.244.138', 'D'),

('193.85.151.98', 'D'),

('77.237.142.133', 'D'),

('90.178.22.179', 'D'),

('93.157.129.182', 'D'),

('93.157.130.65', 'D'),

('78.80.77.98', 'D'),

('178.41.107.201', 'D'),

('95.102.0.109', 'D'),

('188.244.54.100', 'D'),

('217.31.45.161', 'D'),

('77.48.180.2', 'D'),

('95.103.10.8', 'D'),

('91.148.30.123', 'D'),

('217.31.44.192

('31.130.162.13', 'D'),

('81.200.57.132', 'D'),

('90.178.144.46', 'D'),

('77.48.45.198', 'D'),

('217.29.8.207', 'D'),

('178.41.206.37', 'D'),

('87.244.250.217', 'D'),

('88.102.163.99', 'D'),

('90.176.227.246', 'D'),

('178.40.78.215', 'D'),

('91.127.102.76', 'D'),

('82.100.0.156', 'D'),

('217.112.172.140', 'D'),

('89.203.212.186', 'D'),

('109.80.12.93', 'D'),

('77.95.193.202', 'D'),

('80.242.33.36', 'D'),

('95.102.1.18', 'D'),

('80.87.208.133', 'D'),

('85.237.227.37', 'D'),

('90.177.35.25', 'D'),

('217.12.57.26', 'D'),

('88.102.199.20', 'D'),

('81.30.248.23', 'D'),

('213.151.253.6', 'D'),

('94.74.229.90', 'D'),

('88.100.205.177', 'D'),

('217.117.209.219', 'D'),

('62.169.190.100', 'D'),

('213.29.248.61', 'D'),

('94.199.199.220', 'D'),

('90.183.16.21', 'D'),

('82.99.191.11', 'D'),

('88.146.164.126', 'D'),

('85.132.142.41', 'D'),

('178.40.93.199', 'D'),

('94.242.64.214', 'D'),

('91.229.254.100', 'D'),

('85.71.202.134', 'D'),

('95.103.211.252', 'D'),

('85.70.197.39', 'D'),

('83.208.85.75', 'D'),

('46.237.96.224', 'D'),

('188.121.189.112', 'D'),

('93.157.130.110', 'D'),

('212.96.177.115', 'D'),

('94.113.159.223', 'D'),

('83.208.28.94', 'D'),

('62.168.45.106', 'D'),

('88.212.37.160', 'D'),

('94.127.132.30', 'D'),

('81.200.51.130', 'D'),

('188.131.74.32', 'D'),

('213.195.216.101', 'D'),

('87.197.49.57', 'D'),

('78.157.137.2', 'D'),

('85.70.240.166', 'D'),

('81.200.56.24', 'D'),

('88.100.30.65', 'D'),

('217.29.9.75', 'D'),

('188.175.233.242', 'D'),

('95.103.135.44', 'D'),

('195.98.10.11', 'D'),

('89.176.130.9', 'D'),

('88.212.40.144', 'D'),

('77.48.218.252', 'D'),

('77.48.106.46', 'D'),

('62.240.190.170', 'D'),

('77.48.218.233', 'D'),

('89.203.143.39', 'D'),

('109.72.4.149', 'D'),

('81.200.56.33', 'D'),

('95.102.29.205', 'D'),

('195.168.75.168', 'D'),

('193.85.151.2', 'D'),

('81.19.35.122', 'D'),

('83.208.7.111', 'D'),

('93.99.99.6', 'D'),

('109.74.148.232', 'D'),

('109.231.128.30', 'D'),

('217.29.8.135', 'D'),

('89.102.60.36', 'D'),

('46.167.192.253', 'D'),

('85.162.211.22', 'D'),

('88.102.149.23', 'D'),

('90.177.100.83', 'D'),

('178.41.30.26', 'D'),

('194.228.164.205', 'D'),

('95.102.89.160', 'D'),

('188.175.98.89', 'D'),

('78.111.126.202', 'D'),

('89.103.178.243', 'D'),

('81.200.54.248', 'D'),

('193.179.175.210', 'D'),

('109.164.3.131', 'D'),

('90.181.16.251', 'D'),

('90.179.101.72', 'D'),

('88.103.228.58', 'D'),

('93.89.111.27', 'D'),

('178.41.155.88', 'D'),

('95.103.42.172', 'D'),

('77.48.243.34', 'D'),

('82.100.0.179', 'D'),

('109.107.211.130', 'D'),

('85.135.133.222', 'D'),

('95.102.31.159', 'D'),

('46.33.96.6', 'D'),

('80.188.6.9', 'D'),

('91.148.9.151', 'D'),

('62.209.207.5', 'D'),

('46.33.96.8', 'D'),

('85.71.186.126', 'D'),

('95.102.152.137', 'D'),

('78.102.246.41', 'D'),

('88.101.173.186', 'D'),

('78.102.54.123', 'D'),

('78.128.198.60', 'D'),

('90.177.190.73', 'D'),

('81.90.173.235', 'D'),

('46.229.124.144', 'D'),

('188.116.77.103', 'D'),

('88.101.174.43', 'D'),

('78.98.234.81', 'D'),

('77.92.215.188', 'D'),

('95.103.57.125', 'D'),

('94.199.199.212', 'D'),

('78.141.86.123', 'D'),

('109.205.72.16', 'D'),

('83.208.6.218', 'D'),

('82.117.130.2', 'D');

 

 

Netestovano, prekvapive.

 

notepad++ a macra = minuta prace.

Edited November 27, 2011 by Pick

[snv 29]

v poslednom riadku ti chyba zatvorka na zaciatku

[warring 55]

uz hotovo díky moc za pomoc