SQL reconfigure tables

I can modify table and code to store ID instead of name to avoid confusion on same names. I will complete this work in a day. Relevant Skills and Experience PHP, MySQL, HTML Proposed Milestones $34 AUD - after completion of making mysql and code to support id in relationship table

Hi, The Mysql job is very easy. I can link tables using ID instead of name. Relevant Skills and Experience MYSQL Expert Proposed Milestones $30 AUD - final

A proposal has not yet been provided

`we have expertise in SQL,MySQL,php, DBA, Data processing. Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience SQL,MySQL,php, DBA, Data processing Proposed Milestones $25 AUD - whole

Hi , I can help you with making the one to many relationship based on IDs . I have previous experience of working with PHP/MySQL . Relevant Skills and Experience I have previous experience of working with PHP/MySQL . Proposed Milestones $30 AUD - Initial Milestone

just will recode it to use the id it is a so simple task, ill finish it in 2 hours only Relevant Skills and Experience sql Proposed Milestones $60 AUD - all

Hello, I can do this now for you, I would create autonumber key, and replace the relationship with it, but if there are any files related in php it will have to be changed accordingly. Relevant Skills and Experience mysql Proposed Milestones $35 AUD - After fix

hi, the name in database table referenced to be replaced with id relation. Relevant Skills and Experience php mysql - 4 years on freelancer.com i am on it since july 2013 Proposed Milestones $30 AUD - task is for changing reference of name in database table to id

Hi, I am an experienced java proffessional expert in core java j2ee spring mvc hibernate orm webservices. I can do this. Pls contact for further progress. Relevant Skills and Experience expert in core java j2ee spring mvc hibernate orm webservices , sql, graph db Proposed Milestones $35 AUD - Initial

I have been working in web development for 3 years and gained considerable experience in various skills. Relevant Skills and Experience PHP MYSQL JQUERY AJAX CODEIGNITER Woocommerce Proposed Milestones $15 AUD - After Completation

Greetings, I am experienced database designer and SQL specialist. I can help you with resolving this problem i one day. From you I need schemes of these two tables or better dump of DB, after I will give small script that will add need and perform filling. Please invite me to chat to discuss further details of the job. Regards, Konstantin

Hi,can i help you?I am a web designer and web program .. i have been doing web projects for several times, entrust your project to me, i will finish it in quick time and accordingly ... please see my reviews there to see if i can be reliable for your project .. .thank you...

A proposal has not yet been provided

Create link on 2 tables. Relevant Skills and Experience I'm a software engineer, and I worked during 10 years on databases (MySQL, SQL Server, Access, PostGreSQL, H2, Ingres, Oracle). Proposed Milestones $25 AUD - Complete the project Can you provide me the phpmyadmin link ?

This bid is for the whole project. Relevant Skills and Experience Example: CREATE TABLE Orders (OrderID int NOT NULL, OrderNumber int NOT NULL, PersonID int, PRIMARY KEY (OrderID), FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)); Proposed Milestones $14 AUD - complete the project

We could go with many approaches here like backing up table and restoring a new table with ID column . Relevant Skills and Experience Database Administrator, Mysql,Database Developer Proposed Milestones $25 AUD - Conversion Could you please allow to see the structure of the table/data and allow me to work on it?

Here is my code in PostgreSQL, show me your phpMyAdmin ALTER TABLE {yourtable} ADD COLUMN id integer; ALTER TABLE {yourtable} ALTER COLUMN id SET DEFAULT nextval('item_id_seq'::regclass); Relevant Skills and Experience ALTER TABLE {anothertable} ADD CONSTRAINT "FK_name" FOREIGN KEY (another_id) REFERENCES {yourtable}(id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE; Proposed Milestones $25 AUD - Finish

I will add the foreign key throuh a new column en the table who have the problem key

1) Verify data integrity, no duplicated ids, not nulls and no orphans 2) Define ids as not null and primary key (if they are not) 3) Replace name with id 4) Generate FK constraints 5) data Validation Relevant Skills and Experience This issue is very common, I had fixed several issues like this in the past, if the data is complete, the fix should be quick and reliable. One of my hobbies is to fix sql issues, especially mysql Stay tuned, I'm is still working on this proposal.

Hi, I have 2 years of experience in data management.