All pastes #784311 Raw Edit

Someone

public text v1 · immutable
·published 2007-11-19 17:19 UTC
rendered paste body
$sql_find = "select distinct entries.router,INET_NTOA(entries.route),entries.mask,entries.route_type,INET_NTOA(entries.dstip),entries.metric,names.name,names.netid,entries.time from entries INNER JOIN names ON names.dstip = entries.dstip where entries.route <= INET_ATON('$rt') and entries.route_end >= INET_ATON('$rt') and route_type like '%ospf%'";

mysql> desc entries;
+------------+-------------------+------+-----+---------+-------+
| Field      | Type              | Null | Key | Default | Extra |
+------------+-------------------+------+-----+---------+-------+
| router     | varchar(100)      | YES  |     | NULL    |       | 
| route_type | varchar(10)       | YES  |     | NULL    |       | 
| route      | int(100) unsigned | YES  |     | NULL    |       | 
| route_end  | int(100) unsigned | YES  |     | NULL    |       | 
| mask       | int(11)           | YES  |     | NULL    |       | 
| ad         | int(11)           | YES  |     | NULL    |       | 
| metric     | int(11)           | YES  |     | NULL    |       | 
| dstip      | int(100) unsigned | YES  |     | NULL    |       | 
| time       | varchar(50)       | YES  |     | NULL    |       | 
| interface  | varchar(75)       | YES  |     | NULL    |       | 
+------------+-------------------+------+-----+---------+-------+
10 rows in set (0.00 sec)

mysql> desc names;
+-------+-------------------+------+-----+---------+-------+
| Field | Type              | Null | Key | Default | Extra |
+-------+-------------------+------+-----+---------+-------+
| name  | varchar(75)       | YES  |     | NULL    |       | 
| dstip | int(100) unsigned | YES  |     | NULL    |       | 
| netid | int(100) unsigned | YES  |     | NULL    |       | 
+-------+-------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)