Devam Ediyor

MySQL Stored Procedure

We need a MySQL Stored Procedure to process the results of a query, and for each result, add records to 2 other tables.

We have a table of accounts, and a set of new accounts returned by a query. For each new account, there are one or more existing accounts that are related to it, that have information that we'd like to copy in as we add the new accounts to the table of accounts.

Here are the designs of the tables involved:

accounts table

• id

• name

• account_num

• provider_id

new accounts (returned by a query)

• name

• account_num

• provider_id

accounts_nodes table

• id

• account_id

• node_id

So we'd like a stored procedure that can do the following:

1. Start with a query that returns a set of new accounts

2. For each new account, there should be at least 1 existing account record. Find one record of an existing account

3. create a new record in the accounts table, using the information for the new account in some fields, and information from the existing account record in other fields. The id of this record should be set by auto_increment.

4. the existing account will have 0 or more records in the accounts_nodes table. For each, create a new record in the accounts_nodes table, with the account_id of the new account record, and the node_id from the accounts_nodes record.

The stored procedure should be developed for MySQL 5, and be clearly documented and commented.

Please respond with a sample of a MySQL Stored Procedure that you have developed to show a your coding ability and clear documentation ability.

Beceriler: MySQL

Daha fazlasını görün: mysql procedure, mysql documentation, procedure mysql sample, mysql procedure sample, mysql 5.1, stored, mysql copy, mysql add fields, mysql add record, coding mysql, mysql create table fields, copy tables, mysql record, mysql show, mysql create table, PROCESS DOCUMENTATION, account record, 2010 procedure, create mysql table, create mysql, procedure mysql, mysql stored procedure, create table mysql, mysql account, sample documentation

İşveren Hakkında:
( 4 değerlendirme ) Boston, United States

Proje NO: #764397

Seçilen:

amsak

Pls see PM

5 gün içinde 50$ USD
(3 Değerlendirme)
2.8

15 freelancer bu iş için ortalamada 141$ teklif veriyor

arnab0143

--Hello Sir, Please check your pm. Thanks.--

in 2 gün içinde75$ USD
(24 Değerlendirme)
5.9
VALUEONWEB

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have experti Daha fazlası

in 3 gün içinde150$ USD
(14 Değerlendirme)
5.7
albariconsulting

please check PMB FOR DETAILS

in 2 gün içinde90$ USD
(1 Değerlendirme)
4.2
kommandant

Expert !!! Check your PM

in 3 gün içinde150$ USD
(8 Değerlendirme)
3.8
icubelab

Dear Sir, Hello! We have gone through your requirements, all ready we have done such type of work. If you have any questions feel fee to get in touch us for more clarifications. Please visit PMB for more inform Daha fazlası

in 3 gün içinde150$ USD
(1 Değerlendirme)
2.0
sweetcoder

Please check your inbox... Thanks.

in 2 gün içinde100$ USD
(1 Değerlendirme)
1.4
gabrielhenrique

Hi, please check your PMB.

in 3 gün içinde250$ USD
(0 Değerlendirme)
0.9
WithYouSoft

Dear, I have good experience of Stored Procedure. I can do some work freely for test. Regards, Mark.

in 3 gün içinde250$ USD
(0 Değerlendirme)
0.0
anupbhatti

Time is money & we value it.....

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
DISoln

Hi, Please see Proposal Details in PM Regards DI Solution

in 3 gün içinde125$ USD
(0 Değerlendirme)
2.4
James1986

Hi, I can do this, please kindly check the pmb. Thanks, Aking

in 2 gün içinde150$ USD
(0 Değerlendirme)
0.0
capminds

I am from CapMinds Technologies located in DC Metro with delivery center in India.I would like to work on this project. Our dedicated team is available for 24/7 round the clock support.

1 gün içinde 142$ USD
(0 Değerlendirme)
0.0
charmako

hi sir. i want to create this stored procedure.

in 3 gün içinde150$ USD
(0 Değerlendirme)
0.0
kashifbaig

i can do it.

in 30 gün içinde250$ USD
(0 Değerlendirme)
0.0
manishbhaumik

Please check your inbox. Profile and reviews also.

in 5 gün içinde30$ USD
(0 Değerlendirme)
0.0