Uses the ipython-sql library.
Install using pip install ipython-sql
For documentation, visit https://github.com/catherinedevlin/ipython-sql/blob/master/README.rst
%load_ext sql
%sql mysql+pymysql://readonlyguest:readonlypassword@mysql.guaminsects.net/oryctes
u'Connected: readonlyguest@oryctes'
%sql SHOW TABLES
51 rows affected.
| Tables_in_oryctes |
|---|
| GMF_added_from_obs_table |
| GMF_added_to_sinks |
| Sheet1 |
| Sheet2 |
| YigoBarrelObs |
| crb_obs |
| fumigation |
| ground_treatment |
| mark_release_recapture |
| matt |
| person |
| rearing |
| rearing_curr |
| rearing_obs |
| rearing_old |
| safety |
| search |
| search_track |
| search_tracker_2 |
| sink2 |
| sink_visit2 |
| tempAdultsPerTrapDay |
| tempAdultsTrapped |
| tempDaily |
| tempFinalResults |
| tempMinStartDate |
| tempNearbyTraps |
| tempTrap |
| tempTrapCatch |
| tempTrapCatchResults |
| tempTrapCatchSummary |
| tempTrapsInBoundingBox |
| test |
| trap |
| trapSpatial |
| trap_extras |
| trap_safety |
| trap_visit |
| tree |
| tree_treatment |
| tweets |
| xmark_mark |
| xmark_recapture |
| xmark_release |
| xtrap catch by trapType |
| xtrap release rates |
| xtrap release rates2 |
| xtrap_cycles |
| xtrap_location |
| xtrap_visit |
| yigocopy |
%sql SELECT * FROM YigoBarrelObs LIMIT 5
5 rows affected.
| id | barrelID | trapType | lure | uvled | funnel | substrate | startDate | endDate | males | females | notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | P | y | y | n | n | 2014-05-12 | 2014-05-19 | 1 | 2 | lure not hung |
| 2 | 2 | B | y | y | n | n | 2014-05-12 | 2014-05-19 | 0 | 0 | lure not hung |
| 3 | 3 | P | y | y | n | n | 2014-05-12 | 2014-05-19 | 2 | 0 | lure not hung |
| 4 | 4 | B | y | y | n | n | 2014-05-12 | 2014-05-19 | 1 | 0 | lure not hung |
| 5 | 5 | P | y | y | n | n | 2014-05-12 | 2014-05-19 | 0 | 0 | lure not hung |