WITAM,
ogromny problem z MYSQL poniżej wyświetlam kod...
dlaczego gdy tbl_city.X - from_X przy odejmowaniu wychodzi wartość ogromna (nie realna) a przy dodawaniu wychodzi wartość mniejsza
skąd to się bierze?

[SQL] pobierz, plaintext 
mysql> DESCRIBE tbl_city;
+-------------+------------------+------+-----+---------+----------------+
| FIELD       | Type             | NULL | KEY | DEFAULT | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| cityID      | int(10) UNSIGNED | NO   | PRI | NULL    | AUTO_INCREMENT |
| name        | varchar(128)     | YES  |     | NULL    |                |
| X           | int(10) UNSIGNED | NO   |     | NULL    |                |
| Y           | int(10) UNSIGNED | NO   |     | NULL    |                |
| zalozenie   | int(10) UNSIGNED | NO   |     | NULL    |                |
| zalozyciele | int(10) UNSIGNED | NO   |     | NULL    |                |
| capitol     | tinyint(1)       | YES  |     | NULL    |                |
| STATUS      | tinyint(1)       | YES  |     | NULL    |                |
| colony      | tinyint(4)       | NO   |     | NULL    |                |
| development | tinyint(1)       | NO   |     | NULL    |                |
| type        | varchar(10)      | NO   |     | NULL    |                |
| provinceID  | int(10) UNSIGNED | NO   |     | NULL    |                |
| userID      | int(10) UNSIGNED | NO   |     | NULL    |                |
| level       | int(10) UNSIGNED | NO   |     | NULL    |                |
| mineType    | varchar(15)      | NO   |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+
15 rows IN SET (0.00 sec)
 
mysql> DESCRIBE tbl_trade_offer;
+---------------+------------------+------+-----+---------+----------------+
| FIELD         | Type             | NULL | KEY | DEFAULT | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| trade_offerID | int(10) UNSIGNED | NO   | PRI | NULL    | AUTO_INCREMENT |
| offer         | varchar(10)      | NO   |     | NULL    |                |
| search        | varchar(10)      | NO   |     | NULL    |                |
| offer_        | int(10) UNSIGNED | NO   |     | NULL    |                |
| search_       | int(10) UNSIGNED | NO   |     | NULL    |                |
| from_         | int(10) UNSIGNED | NO   |     | NULL    |                |
| from_X        | int(10) UNSIGNED | NO   |     | NULL    |                |
| from_Y        | int(10) UNSIGNED | NO   |     | NULL    |                |
| speed         | int(10) UNSIGNED | NO   |     | NULL    |                |
| times         | int(10) UNSIGNED | NO   |     | NULL    |                |
| merchants     | int(10) UNSIGNED | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
11 rows IN SET (0.00 sec)
 
mysql> SELECT offer, offer_, search, search_,tbl_city.X-from_X, tbl_city.Y-from_Y, speed, round((sqrt((tbl_city.X - from_X)^2 + (tbl_city.Y - from_Y)^2) /6)/ speed*3600/36) AS time FROM tbl_trade_offer, tbl_city WHERE cityID =40;
+-------+--------+--------+---------+----------------------+-------------------+-------+------------+
| offer | offer_ | search | search_ | tbl_city.X-from_X    | tbl_city.Y-from_Y | speed | time       |
+-------+--------+--------+---------+----------------------+-------------------+-------+------------+
| wood  |      9 | wood   |       9     | 18446744073709551314 |           103 |    10 | 7158278827 |
+-------+--------+--------+---------+----------------------+-------------------+-------+------------+
1 row IN SET (0.00 sec)
 
mysql> SELECT offer, offer_, search, search_,tbl_city.X+from_X, tbl_city.Y-from_Y, speed, round((sqrt((tbl_city.X - from_X)^2 + (tbl_city.Y - from_Y)^2) /6)/ speed*3600/36) AS time FROM tbl_trade_offer, tbl_city WHERE cityID =40;
+-------+--------+--------+---------+-------------------+-------------------+-------+------------+
| offer | offer_ | search | search_ | tbl_city.X+from_X | tbl_city.Y-from_Y | speed | time       |
+-------+--------+--------+---------+-------------------+-------------------+-------+------------+
| wood  |      9 | wood   |       9 |              5666 |               103 |    10 | 7158278827 |
+-------+--------+--------+---------+-------------------+-------------------+-------+------------+
1 row IN SET (0.00 sec)
 
mysql> SELECT offer, offer_, search, search_,x, y,from_x, from_y,tbl_city.X- from_X, tbl_city.Y-from_Y, speed, round((sqrt((tbl_city.X - from_X)^2 + (tbl_city.Y - from_Y)^2) /6)/ speed*3600/36) AS time FROM tbl_trade_offer, tbl_city WHERE cityID =40;
+-------+--------+--------+---------+------+------+--------+--------+----------------------+-------------------+-------+------------+
| offer | offer_ | search | search_ | x    | y    | from_x | from_y | tbl_city.X- from_X   | tbl_city.Y-from_Y | speed | time       |
+-------+--------+--------+---------+------+------+--------+--------+----------------------+-------------------+-------+------------+
| wood  |      9 | wood   |       9 | 2682 | 2827 |   2984 |   2724 | 18446744073709551314 |               103 |    10 | 7158278827 |
+-------+--------+--------+---------+------+------+--------+--------+----------------------+-------------------+-------+------------+
1 row IN SET (0.00 sec)
 
 
mysql>
[SQL] pobierz, plaintext 

Witam.

[SQL] pobierz, plaintext 
ALTER TABLE tbl_city CHANGE COLUMN `X` `X` INT(10) SIGNED NOT NULL, CHANGE COLUMN `Y` `Y` INT(10) SIGNED NOT NULL  ;
ALTER TABLE tbl_trade_offer CHANGE COLUMN `from_X` `from_X` INT(10) SIGNED NOT NULL, CHANGE COLUMN `from_Y` `from_Y` INT(10) SIGNED NOT NULL  ;
[SQL] pobierz, plaintext 

Poczytaj o --sql-mode=NO_UNSIGNED_SUBTRACTION.

dzięki rocktech.pl

Pozamieniałem, zmieniłem także mode i nadal to nic nie dało
czy coś jeszcze ?

Spróbuj użyć CAST jako SIGNED. Ewentualnie alter na FLOAT ...

[SQL] pobierz, plaintext 
mysql> SELECT -4^2;
+----------------------+
| -4^2                 |
+----------------------+
| 18446744073709551614 |
+----------------------+
1 row IN SET (0.00 sec)
 
mysql> SELECT CAST(-4 AS UNSIGNED)^2;
+------------------------+
| CAST(-4 AS UNSIGNED)^2 |
+------------------------+
|   18446744073709551614 |
+------------------------+
1 row IN SET (0.00 sec)
 
mysql> SELECT pow(-4,2);
+-----------+
| pow(-4,2) |
+-----------+
|        16 |
+-----------+
1 row IN SET (0.00 sec)
[SQL] pobierz, plaintext 

myślę że nie potrzeba komentarza
dzięki za mode...

http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
znaczek ^ to XOR a nie potęgowanie