mbroome

nova-mysql-before

May 24th, 2012
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. mysql> select * from fixed_ips where updated_at != 'NULL';
  2. +---------------------+---------------------+------------+---------+-----+----------------+------------+-------------+-----------+--------+----------+----------------------+-----------------------------------+
  3. | created_at | updated_at | deleted_at | deleted | id | address | network_id | instance_id | allocated | leased | reserved | virtual_interface_id | host |
  4. +---------------------+---------------------+------------+---------+-----+----------------+------------+-------------+-----------+--------+----------+----------------------+-----------------------------------+
  5. | 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 |
  6. | 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 |
  7. | 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 |
  8. | 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 |
  9. | 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 |
  10. +---------------------+---------------------+------------+---------+-----+----------------+------------+-------------+-----------+--------+----------+----------------------+-----------------------------------+
  11. 5 rows in set, 1 warning (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment