Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select * from fixed_ips where updated_at != 'NULL';
- +---------------------+---------------------+------------+---------+-----+----------------+------------+-------------+-----------+--------+----------+----------------------+-----------------------------------+
- | created_at | updated_at | deleted_at | deleted | id | address | network_id | instance_id | allocated | leased | reserved | virtual_interface_id | host |
- +---------------------+---------------------+------------+---------+-----+----------------+------------+-------------+-----------+--------+----------+----------------------+-----------------------------------+
- | 2012-05-24 11:42:01 | 2012-05-24 11:53:55 | NULL | 0 | 3 | 192.168.97.2 | 1 | 1 | 0 | 0 | 0 | NULL | NULL |
- | 2012-05-24 11:42:01 | 2012-05-24 11:46:22 | NULL | 0 | 4 | 192.168.97.3 | 1 | NULL | 0 | 0 | 0 | NULL | addevcloud1b00.be.jamconsultg.com |
- | 2012-05-24 11:42:01 | 2012-05-24 11:49:31 | NULL | 0 | 5 | 192.168.97.4 | 1 | 2 | 1 | 0 | 0 | 2 | NULL |
- | 2012-05-24 11:42:01 | 2012-05-24 11:49:31 | NULL | 0 | 6 | 192.168.97.5 | 1 | NULL | 0 | 0 | 0 | NULL | addevcloud1b01.be.jamconsultg.com |
- | 2012-05-24 11:42:01 | 2012-05-24 11:42:02 | NULL | 0 | 255 | 192.168.97.254 | 1 | NULL | 0 | 0 | 1 | NULL | NULL |
- +---------------------+---------------------+------------+---------+-----+----------------+------------+-------------+-----------+--------+----------+----------------------+-----------------------------------+
- 5 rows in set, 1 warning (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment