https://codereview.appspot.com/324650043/diff/20001/Task1_3.sql File Task1_3.sql (right): https://codereview.appspot.com/324650043/diff/20001/Task1_3.sql#newcode3 Task1_3.sql:3: create table geoHops as select geoLocation.* ,GeoIp.startIpNum,GeoIp.endIpNum from geoLocation ...
6 years, 6 months ago
(2017-10-11 00:17:41 UTC)
#2
https://codereview.appspot.com/324650043/diff/20001/Task1_3.sql
File Task1_3.sql (right):
https://codereview.appspot.com/324650043/diff/20001/Task1_3.sql#newcode3
Task1_3.sql:3: create table geoHops as select geoLocation.*
,GeoIp.startIpNum,GeoIp.endIpNum from geoLocation inner join GeoIp on
geoLocation.locId = GeoIp.locId;
Using capital letters for SQL keywords could improve readability
https://codereview.appspot.com/324650043/diff/20001/Task1_3.sql#newcode9
Task1_3.sql:9: select Hops.idHop, Hops.ipSrc, geoHops.* from Hops, geoHops where
INET_ATON(ipSrc) Between startIpNum and endIpNum AND idHop between 1 and 53020
AND ipSrc != '*' order by idHop asc INTO OUTFIlE
'/var/lib/mysql-files/geoHopsFinal.csv';
Version with headers (would help for readability of the resulting file):
select 'idHop', 'ipSrc', 'locId', 'country', 'region', 'city', 'postalCode',
'latitude', 'longitude', 'startIpNum', 'endIpNum' union all (select Hops.idHop,
Hops.ipSrc, geoHops.locId, geoHops.country, geoHops.region, geoHops.city,
geoHops.postalCode, geoHops.latitude, geoHops.longitude, geoHops.startIpNum,
geoHops.endIpNum from Hops, geoHops where INET_ATON(ipSrc) Between startIpNum
and endIpNum AND idHop between 1 and 25 AND ipSrc != '*' order by idHop asc INTO
OUTFIlE '/var/lib/mysql-files/test-manu.csv');
https://codereview.appspot.com/324650043/diff/20001/task1.sql
File task1.sql (right):
https://codereview.appspot.com/324650043/diff/20001/task1.sql#newcode18
task1.sql:18: create procedure wk()
all this function block should be indented, I guess
(or the two preceding lines should be unindented, and in this case the line "end
$$" & the next one should be unindented as well)
Is it using the simple formula: rootSqr((y2-y1)^2 + (x2-x1)^2)? Or its calculation consider the curve-like ...
6 years, 5 months ago
(2017-11-20 07:34:28 UTC)
#4
Is it using the simple formula: rootSqr((y2-y1)^2 + (x2-x1)^2)?
Or its calculation consider the curve-like connection between source
and destination as a result of sphere shape of planet Earth?
--
Best regards,
Mr. Farzad Hajibagheri
P.S.: If you have found any mistakes in my English, if you want you
can answer me and correct me, please.
Om du har hittat några fel i min Svenska, om du vill kan du svara mig
och hämta mig med rätt, snälla.
P.S. 2.>> Help save natural resources – please think twice before
printing this e-mail or any attachments.
Sorry if you receive this email twice. If this occurs it was because
of technical problem.
Issue 324650043: Dijkstras algorithm
Created 6 years, 6 months ago by brahim Al-Qaysi
Modified 6 years, 5 months ago
Reviewers: dkostic, kirill.sc, manu_chaud, brahim Al-Qaysi
Base URL:
Comments: 10