search

SSARHERPS / SSAR-species-database

SSAR North American Common Names Database
http://ssarherps.org/cndb/
GNU General Public License v3.0
2 stars 0 forks source link

bulkload taxon credit and date for salamanders #62

Closed atrox10 closed 9 years ago

atrox10 commented 9 years ago

can michelle or philip do this? all salamanders need this taxon credit and date:

Stephen G. Tilley (Chair), Richard Highton, David B. Wake 2014-07-10

mkoo commented 9 years ago

I see that we posted this previously: 

UPDATE `north_american_species` SET `taxon_credit_date`="2014-07-10" WHERE (`taxon_credit_date`="" AND `taxon_credit`="Stephen G. Tilley (Chair), Richard Highton, David B. Wake" AND `linnean_order`="caudata" );

So need to adjust:

UPDATE `north_american_species` SET `taxon_credit_date`="2014-07-10" AND `taxon_credit`="Stephen G. Tilley (Chair), Richard Highton, David B. Wake"  WHERE (`taxon_credit_date`="" AND `linnean_order`="caudata" );
tigerhawkvok commented 9 years ago

Ran

UPDATE  `north_american_species` SET  `taxon_credit_date` =  "2014-07-10", `taxon_credit` =  "Stephen G. Tilley (Chair), Richard Highton, David B. Wake" WHERE (`taxon_credit_date` =  "" AND  `linnean_order` =  "caudata")

Updating 198 records