search

ihsn / nada

National Data Archive (NADA) is an open source data cataloging system that serves as a portal for researchers to browse, search, compare, apply for access, and download relevant census or survey information. It was originally developed to support the establishment of national survey data archives.
http://nada.ihsn.org
MIT License
38 stars 10 forks source link

mysql UPDATE TABLE `survey` #7

Closed Alhrath closed 5 years ago

Alhrath commented 5 years ago

Hi, During the mysql database upgrade from 4.4 to 5, the following line :

install/nada5-upgrade-mysql.sql:56

UPDATE TABLE `surveys` set type='survey';

produce an error. I corrected it this way : 

UPDATE `surveys` set `type`='survey';

Is this correct ?

mah0001 commented 5 years ago

Yes, looks right. 'type' is a mysql reserved word, so should be enclosed in backticks, will update the upgrade script.

thanks