Changes between Version 24 and Version 25 of DespoinaLog/2010/12/08
- Timestamp:
- 2010-12-08T15:23:35+01:00 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DespoinaLog/2010/12/08
v24 v25 119 119 ALTER TABLE biobank ADD Materials varchar(255); 120 120 }}} 121 after import from old table , molgenis forms still not showing data . 121 after import from old table , molgenis forms still not showing data .Only record id=1 is shown . 122 122 123 123 mysql> select * from biobank where id=1; … … 125 125 +---------+----------+------+------+------------+-------------------------------------------------------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 126 126 127 | Acronym | Category | Type | Size | !LastUpdate | Description 127 | Acronym | Category | Type | Size | !LastUpdate | Description | id | name | Investigation | ontologyReference | Individuals | Species | !PanelType | !FounderPanels | Institutes | Publications | Contacts | Topics | Materials | 128 128 129 129 +---------+----------+------+------+------------+-------------------------------------------------------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 130 130 131 | Agnes | 34 | core | 800 | 2010-11-25 | see PLoS ONE 3(10): e3583. !doi:10.1371/journal.pone.0003583 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL|131 | Agnes | 34 | core | 800 | 2010-11-25 | see PLoS ONE 3(10): e3583. !doi:10.1371/journal.pone.0003583 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 132 132 133 133 +---------+----------+------+------+------------+-------------------------------------------------------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ … … 139 139 +---------+----------+------+-------+------------+-------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 140 140 141 | Acronym | Category | Type | Size 141 | Acronym | Category | Type | Size | !LastUpdate | Description | id | name | Investigation | ontologyReference | Individuals | Species | !PanelType | !FounderPanels | Institutes | Publications | Contacts | Topics | Materials | 142 142 143 143 +---------+----------+------+-------+------------+-------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 144 144 145 | AGORA | 126 | core | 5,000 | 2010-11-25 | 1600 trio's | 2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL|145 | AGORA | 126 | core | 5,000 | 2010-11-25 | 1600 trio's | 2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 146 146 147 147 +---------+----------+------+-------+------------+-------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ … … 149 149 1 row in set (0.00 sec) 150 150 151 mysql> update biobank set ="!OntologyTerm";152 153 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '="!OntologyTerm"' at line 1154 155 151 mysql> describe biobank; 156 152 157 153 +-------------------+--------------------------------+------+-----+---------+-------+ 158 154 159 | Field | Type| Null | Key | Default | Extra |155 | Field | Type | Null | Key | Default | Extra | 160 156 161 157 +-------------------+--------------------------------+------+-----+---------+-------+ 162 158 163 | Acronym | varchar(255) | YES | | NULL ||159 | Acronym | varchar(255) | YES | | NULL | | 164 160 165 | Category | int(11) | NO | MUL | NULL ||161 | Category | int(11) | NO | MUL | NULL | | 166 162 167 | Type | enum('core','support','other') | NO | | NULL ||163 | Type | enum('core','support','other') | NO | | NULL | | 168 164 169 | Size | varchar(255) | YES | | NULL ||165 | Size | varchar(255) | YES | | NULL | | 170 166 171 | !LastUpdate | date | NO | | NULL ||167 | !LastUpdate | date | NO | | NULL | | 172 168 173 | Description | text | YES | | NULL ||169 | Description | text | YES | | NULL | | 174 170 175 | id | int(11) | NO | PRI | NULL ||171 | id | int(11) | NO | PRI | NULL | | 176 172 177 | name | varchar(255) | YES | | NULL ||173 | name | varchar(255) | YES | | NULL | | 178 174 179 | Investigation | varchar(255) | YES | | NULL ||175 | Investigation | varchar(255) | YES | | NULL | | 180 176 181 | ontologyReference | varchar(255) | YES | | NULL ||177 | ontologyReference | varchar(255) | YES | | NULL | | 182 178 183 | Individuals | varchar(255) | YES | | NULL ||179 | Individuals | varchar(255) | YES | | NULL | | 184 180 185 | Species | varchar(255) | YES | | NULL ||181 | Species | varchar(255) | YES | | NULL | | 186 182 187 | !PanelType | varchar(255) | YES | | NULL ||183 | !PanelType | varchar(255) | YES | | NULL | | 188 184 189 | !FounderPanels | varchar(255) | YES | | NULL ||185 | !FounderPanels | varchar(255) | YES | | NULL | | 190 186 191 | Institutes | varchar(255) | YES | | NULL ||187 | Institutes | varchar(255) | YES | | NULL | | 192 188 193 | Publications | varchar(255) | YES | | NULL ||189 | Publications | varchar(255) | YES | | NULL | | 194 190 195 | Contacts | varchar(255) | YES | | NULL ||191 | Contacts | varchar(255) | YES | | NULL | | 196 192 197 | Topics | varchar(255) | YES | | NULL ||193 | Topics | varchar(255) | YES | | NULL | | 198 194 199 | Materials | varchar(255) | YES | | NULL ||195 | Materials | varchar(255) | YES | | NULL | | 200 196 201 197 +-------------------+--------------------------------+------+-----+---------+-------+
