Database import Primary key duplicate issue

Encerrado Postado Sep 14, 2015 Pago na entrega
Encerrado

ok so, i need to change the frequency of the email user, currently its empty - as i have so many emails, i want to update these within SQL otherwise it will take a long time, - I’ve previous thought about updating these for the import method within PHPLIST but this hasn’t worked.

within the database there are two main tables:

phplist_user_user

&

phplist_user_user_attribute

in order for the RSS frequency to be updated to daily for each email address, an entry must be made into this last table, - the RSS frequency attribute id is 39 & 40 = the userid ( is the customer id which relates to their email address) and the Value needs to be set to 1 for the attribute id 39 & 40, please see the image [login to view URL]

if i manually update these details within SEQUEL PRO for this table, then it works, but I’m not able to import a .cv directly due to a Primary Key issue, i need this table (file will be given upon awarding the project) importing and i think it should then work ok, alternatively - if your able to select all user id in table phplist_user_user and create a record for then in phplist_user_user_attribute with attribute 39 and a value of 1 and repeat this for attribute 40 then that should also work ok.

MySQL PHP SQL

ID do Projeto: #8473922

Sobre o projeto

18 propostas Projeto remoto Ativo em Nov 3, 2015

18 freelancers estão ofertando em média $19/hora nesse trabalho

meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. see my recent Mais

$20 USD / hora
(171 Comentários)
9.3
madhavdutta

Hi Dear, Hope you are doing well !! I have gone through your project description. I can understand that you are looking for importing Primary key duplicate issue therefore I am looking forward to discuss and mo Mais

$22 USD / hora
(162 Comentários)
8.6
developerhunk

Hello sir,, i have read the project description and requirements carefully and i am confident that i am able to do it..I have checked the Dropbox link .. please talk to me once then we will discuss about the project, Mais

$15 USD / hora
(103 Comentários)
7.4
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Mais

$21 USD / hora
(165 Comentários)
6.7
phamtech211

Dear Sir/ Madam, My name is Henry - the owner of PHAMTECH Co. My team is really interested in this project as it is exactly within our scope of expertise: We are web/ app design & development company located in Mais

$15 USD / hora
(18 Comentários)
6.6
audelk

hi sir, im expert in php. i have read your problem. i can do this project without a glitch.. thank you odel

$16 USD / hora
(41 Comentários)
6.0
haovo

hi, I can build a small application which allow you load data from csv file to UI then you maybe take some changes if you want to and click on import button. the program will auto detect duplicated primary key and c Mais

$20 USD / hora
(29 Comentários)
5.9
vinaysinghh

I am sql expert certified by Oracle corporation and having more then 5 yrs of experience in sql Oracle and mysql as database administrator

$17 USD / hora
(59 Comentários)
5.3
acronymsolutions

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : MS Access,Oracle,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Config Mais

$22 USD / hora
(38 Comentários)
5.7
kirvish23

Hi Dear, I am having 7+ yrs of exp in PHP/MYSQL. I can help you in data import from CSV and help you sort out your issue

$15 USD / hora
(2 Comentários)
2.8
eko0809

Proposal belum diberikan

$15 USD / hora
(0 Comentários)
0.0
uqbar

I can use a loop function to go through the records in the first table and create one record of each user_id in the second one.

$22 USD / hora
(0 Comentários)
0.0
tryvinod

Hi, I am in Sydney and working for one of the biggest banks in Australia. I have many years of Database Development experience and I am quite good at writing SQL statements and solving database issues. I like to Mais

$22 USD / hora
(0 Comentários)
0.0
rewati086

I am bidding it to build my history. I will make sure that this is done within planned time. Please share the details to move forward.

$16 USD / hora
(0 Comentários)
0.0