Anyone can help me? TY
On 23 set, 17:52, Jwojwo <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
