TIPS: Mysql command line

Ho trovato qui un intressante tip : usate \G alla fine delle vostre query e otterrete :


mysql> select * from locations where location_code = 'SIN' limit 1G
*************************** 1. row ***************************
location_code: SIN
location_name: Singapore Changi Apt
multi_airport_city_code: SIN
location_type: A
location_sub_type: A
country_code: SG
state_code:
active: 1
latitude: 01.22.00N
longitude: 103.59.00E
1 row in set (0.10 sec)

Comments are closed.