mysql_c_api.c written by Mike Massingill - MikeM@OuSob.ComQuery in q.sql
select * from ref_zip_codes where state_code='TX' and city_name='Pasadena'
| mysql_c_api.c written by Mike Massingill - MikeM@OuSob.Com |
|||||||||
Query in q.sql |
|||||||||
| Row(s): 8 | |||||||||
| Date: 2010-09-06 | |||||||||
| Time: 0:44:49 | |||||||||
| zip_code_id | zip_code | zip_type | city_name | city_type | state_name | state_code | area_code | latitude | longitude |
| 64621 | 77501 | P | Pasadena | D | Texas | TX | 713 | 29.684464 | -95.169800 |
| 64622 | 77502 | S | Pasadena | D | Texas | TX | 713 | 29.679942 | -95.198440 |
| 64624 | 77503 | S | Pasadena | D | Texas | TX | 713 | 29.691128 | -95.162613 |
| 64625 | 77504 | S | Pasadena | D | Texas | TX | 713 | 29.649003 | -95.182296 |
| 64626 | 77505 | S | Pasadena | D | Texas | TX | 713 | 29.654184 | -95.149733 |
| 64627 | 77506 | S | Pasadena | D | Texas | TX | 713 | 29.705414 | -95.201839 |
| 64628 | 77507 | S | Pasadena | D | Texas | TX | 713 | 29.625223 | -95.057353 |
| 64629 | 77508 | P | Pasadena | D | Texas | TX | 713 | 29.663810 | -95.148185 |