MySQL :: Re: Paasing Table name to Query from another Table in stored procedure

New Topic

Re: Paasing Table name to Query from another Table in stored procedure

Posted by: Barry Galbraith
Date: January 27, 2013 06:10PM

>I have 3 companies and each company has different table.

That's your problem, right there.

You need 1 table for ALL companies, and the company id is used as a key into other tables that contain company data.

All the data of a particular type should be in one table.
This is Relational Database, not a spreadsheet.

If you want use Relational Database techniques, then you need for your data to be stored in relational database tables.

Good luck,
Barry.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 26, 2013 07:38AM

Re: Paasing Table name to Query from another Table in stored procedure

Barry Galbraith

January 27, 2013 06:10PM

Re: Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 27, 2013 11:50PM

Re: Paasing Table name to Query from another Table in stored procedure

Barry Galbraith

January 28, 2013 12:16AM

Re: Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 28, 2013 04:59AM

Re: Paasing Table name to Query from another Table in stored procedure

Barry Galbraith

January 28, 2013 02:45PM

Re: Paasing Table name to Query from another Table in stored procedure

Rick James

January 27, 2013 10:04PM

Re: Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 27, 2013 11:53PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.