Database import Primary key duplicate issue

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:




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 [url removed, login to view]

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.

Compétences : MySQL, PHP, SQL

en voir plus : www key com, duplicate entry key primary mysql, duplicate entry key primary joomla, duplicate entry key primary, phpmyadmin 1062 duplicate entry key primary, 1062 duplicate entry key primary commerce, commerce 1062 duplicate entry key primary, oscommerce duplicate entry key primary, mysql error 1062 duplicate entry key primary, 1062 duplicate entry key primary oscommerce, 1062 duplicate entry key primary

Concernant l'employeur :
( 53 commentaires ) bangkok, Thailand

Nº du projet : #8473922

19 freelance font une offre moyenne de $19/heure pour ce travail


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 Plus

$20 USD / heure
(121 Commentaires)

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 Plus

$22 USD / heure
(144 Commentaires)

I will import it. i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good co Plus

$26 USD / heure
(29 Commentaires)

We have designed and developed many Custom PHP websites. Please check:- CUSTOM PHP WEBSITES ( Mobile compatible design ) ===================== [url removed, login to view] [url removed, login to view] [url removed, login to view] Plus

$15 USD / heure
(47 Commentaires)

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 Plus

$15 USD / heure
(16 Commentaires)

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, Plus

$15 USD / heure
(41 Commentaires)

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 !! Plus

$21 USD / heure
(85 Commentaires)

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

$16 USD / heure
(25 Commentaires)

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 Plus

$20 USD / heure
(21 Commentaires)

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 Plus

$22 USD / heure
(36 Commentaires)

Hi dear. My name is JiaoMing. I am an expert in web develop such as PHP, AngularJS, Restful API, HTML, CSS, Jquery. I already checked your job. Your job is very interest. I would be happy to accept your requirement Plus

$21 USD / heure
(12 Commentaires)

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 / heure
(7 Commentaires)

A proposal has not yet been provided

$21 USD / heure
(12 Commentaires)

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 / heure
(1 Évaluation)

Dear sir. thanks for your job posting. I saw your description very carefully. As I am excellent web developer, I understood your issues . Please show me your php source code. I will fix asap. I am ready now. T Plus

$22 USD / heure
(0 Commentaires)

Hello sir, Greeting of the day!! We have carefully read your job description and We have more than 4+ years of working experience in of your required skills. And I am strongest at all of your required qualities. Plus

$22 USD / heure
(0 Commentaires)

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 / heure
(0 Commentaires)

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 Plus

$22 USD / heure
(0 Commentaires)

Proposal belum diberikan

$15 USD / heure
(0 Commentaires)

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 / heure
(0 Commentaires)