Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> create table phones (phone int);
- Query OK, 0 rows affected (0,05 sec)
- mysql> create table phone_reanges(range_start int, range_end int, city varchar(32) );
- Query OK, 0 rows affected (0,04 sec)
- mysql> insert into phones values (569078);
- Query OK, 1 row affected (0,01 sec)
- mysql> insert into phone_ranges values(569000,570000, 'Test');
- ERROR 1146 (42S02): Table 'regru.phone_ranges' doesn't exist
- mysql> insert into phone_reanges values(569000,570000, 'Test');
- Query OK, 1 row affected (0,04 sec)
- mysql> select * from phones inner join phone_reanges on phones.phone between phone_reanges.range_start and phone_reanges.range_end;
- +--------+-------------+-----------+------+
- | phone | range_start | range_end | city |
- +--------+-------------+-----------+------+
- | 569078 | 569000 | 570000 | Test |
- +--------+-------------+-----------+------+
- 1 row in set (0,01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement