Changes between Version 2 and Version 3 of DespoinaLog/2010/12/09


Ignore:
Timestamp:
2010-12-09T10:59:36+01:00 (14 years ago)
Author:
antonak
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DespoinaLog/2010/12/09

    v2 v3  
    44
    55== Solution ==
    6 create new table biobank from pheno project as follows:
     6 * create new table biobank from pheno project as follows:
    77
    8 mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate, Description, id from biobank ; 
    98
    10 (only fields that exist in biobank in gcc project)Dump and insert new table in gcc project.$ mysqldump5 -u root -p bbmri_old biobank_new > biobank_new.mysql mysql5 -u root -p bbmri < biobank_new.mysql
     9
     10        mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate, Description, id from biobank ;
     11
     12        (only fields that exist in biobank in gcc project)
     13
     14 * Dump and insert new table in gcc project.
     15   * $ mysqldump5 -u root -p bbmri_old biobank_new > biobank_new.mysql 
     16   * mysql5 -u root -p bbmri < biobank_new.mysql
     17 * Edit