Advertisement
Guest User

Untitled

a guest
Feb 27th, 2020
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.88 KB | None | 0 0
  1. mysql> create table phones (phone int);
  2. Query OK, 0 rows affected (0,05 sec)
  3.  
  4. mysql> create table phone_reanges(range_start int, range_end int, city varchar(32) );
  5. Query OK, 0 rows affected (0,04 sec)
  6.  
  7. mysql> insert into phones values (569078);
  8. Query OK, 1 row affected (0,01 sec)
  9.  
  10. mysql> insert into phone_ranges values(569000,570000, 'Test');
  11. ERROR 1146 (42S02): Table 'regru.phone_ranges' doesn't exist
  12. mysql> insert into phone_reanges values(569000,570000, 'Test');
  13. Query OK, 1 row affected (0,04 sec)
  14.  
  15. mysql> select * from phones inner join phone_reanges on phones.phone between phone_reanges.range_start and phone_reanges.range_end;
  16. +--------+-------------+-----------+------+
  17. | phone  | range_start | range_end | city |
  18. +--------+-------------+-----------+------+
  19. | 569078 |      569000 |    570000 | Test |
  20. +--------+-------------+-----------+------+
  21. 1 row in set (0,01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement