Changes between Version 23 and Version 24 of DespoinaLog/2010/12/08
- Timestamp:
- 2010-12-08T15:22:49+01:00 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DespoinaLog/2010/12/08
v23 v24 94 94 * Description 95 95 96 97 96 {{{ 98 97 ALTER TABLE biobank ADD name varchar(255); … … 120 119 ALTER TABLE biobank ADD Materials varchar(255); 121 120 }}} 122 123 124 121 after import from old table , molgenis forms still not showing data . 125 122 126 127 123 mysql> select * from biobank where id=1; 124 128 125 +---------+----------+------+------+------------+-------------------------------------------------------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 129 | Acronym | Category | Type | Size | LastUpdate | Description | id | name | Investigation | ontologyReference | Individuals | Species | PanelType | FounderPanels | Institutes | Publications | Contacts | Topics | Materials | 126 127 | Acronym | Category | Type | Size | !LastUpdate | Description | id | name | Investigation | ontologyReference | Individuals | Species | !PanelType | !FounderPanels | Institutes | Publications | Contacts | Topics | Materials | 128 130 129 +---------+----------+------+------+------------+-------------------------------------------------------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 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 | 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 | 132 132 133 +---------+----------+------+------+------------+-------------------------------------------------------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 134 133 135 1 row in set (0.00 sec) 134 136 135 137 mysql> select * from biobank where id=2; 138 136 139 +---------+----------+------+-------+------------+-------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 137 | Acronym | Category | Type | Size | LastUpdate | Description | id | name | Investigation | ontologyReference | Individuals | Species | PanelType | FounderPanels | Institutes | Publications | Contacts | Topics | Materials | 140 141 | Acronym | Category | Type | Size | !LastUpdate | Description | id | name | Investigation | ontologyReference | Individuals | Species | !PanelType | !FounderPanels | Institutes | Publications | Contacts | Topics | Materials | 142 138 143 +---------+----------+------+-------+------------+-------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 139 | AGORA | 126 | core | 5,000 | 2010-11-25 | 1600 trio's | 2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 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 | 146 140 147 +---------+----------+------+-------+------------+-------------+----+------+---------------+-------------------+-------------+---------+-----------+---------------+------------+--------------+----------+--------+-----------+ 148 141 149 1 row in set (0.00 sec) 142 150 143 mysql> update biobank set ="OntologyTerm"; 144 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 1 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 1 154 145 155 mysql> describe biobank; 156 146 157 +-------------------+--------------------------------+------+-----+---------+-------+ 147 | Field | Type | Null | Key | Default | Extra | 158 159 | Field | Type | Null | Key | Default | Extra | 160 148 161 +-------------------+--------------------------------+------+-----+---------+-------+ 149 | Acronym | varchar(255) | YES | | NULL | | 150 | Category | int(11) | NO | MUL | NULL | | 151 | Type | enum('core','support','other') | NO | | NULL | | 152 | Size | varchar(255) | YES | | NULL | | 153 | LastUpdate | date | NO | | NULL | | 154 | Description | text | YES | | NULL | | 155 | id | int(11) | NO | PRI | NULL | | 156 | name | varchar(255) | YES | | NULL | | 157 | Investigation | varchar(255) | YES | | NULL | | 158 | ontologyReference | varchar(255) | YES | | NULL | | 159 | Individuals | varchar(255) | YES | | NULL | | 160 | Species | varchar(255) | YES | | NULL | | 161 | PanelType | varchar(255) | YES | | NULL | | 162 | FounderPanels | varchar(255) | YES | | NULL | | 163 | Institutes | varchar(255) | YES | | NULL | | 164 | Publications | varchar(255) | YES | | NULL | | 165 | Contacts | varchar(255) | YES | | NULL | | 166 | Topics | varchar(255) | YES | | NULL | | 167 | Materials | varchar(255) | YES | | NULL | | 162 163 | Acronym | varchar(255) | YES | | NULL | | 164 165 | Category | int(11) | NO | MUL | NULL | | 166 167 | Type | enum('core','support','other') | NO | | NULL | | 168 169 | Size | varchar(255) | YES | | NULL | | 170 171 | !LastUpdate | date | NO | | NULL | | 172 173 | Description | text | YES | | NULL | | 174 175 | id | int(11) | NO | PRI | NULL | | 176 177 | name | varchar(255) | YES | | NULL | | 178 179 | Investigation | varchar(255) | YES | | NULL | | 180 181 | ontologyReference | varchar(255) | YES | | NULL | | 182 183 | Individuals | varchar(255) | YES | | NULL | | 184 185 | Species | varchar(255) | YES | | NULL | | 186 187 | !PanelType | varchar(255) | YES | | NULL | | 188 189 | !FounderPanels | varchar(255) | YES | | NULL | | 190 191 | Institutes | varchar(255) | YES | | NULL | | 192 193 | Publications | varchar(255) | YES | | NULL | | 194 195 | Contacts | varchar(255) | YES | | NULL | | 196 197 | Topics | varchar(255) | YES | | NULL | | 198 199 | Materials | varchar(255) | YES | | NULL | | 200 168 201 +-------------------+--------------------------------+------+-----+---------+-------+ 202 169 203 19 rows in set (0.00 sec)
