Hi, I have a MySQL database with PhP interface. I'm trying to modify specific data from my db but unsuccesfully.
I just tryied queries based in Replace and Update. My table have these 4 columns : SNP_id, Allele_1, Allele_2, CGF_Sample_id And I must change the alleles (Allele_1 and/or Allele_2) for specific values of SNP_id. There are around 2kk of rows in this table for aprox. 1500 SNP_ids. Allele_1 and _2 are ENUM (A, C, T, G) and i must change, for example, A => T in 100 SNPs_id of the group of 1500. Anyone knows a query that can replace only specific data without change all rows? Best Regards, Giordano (Sorry for poor english, i'm not english speaker) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "mysql" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/mysql -~----------~----~----~----~------~----~------~--~---
