Member Avatar for Hakoo

Hello all,
I have three table name with same data structure. So, I want to insert my data through store procedure by passing table name as variable with my data. Is it possible?


Thanking You.
Hakoo Desai.

  • 3 Contributors
  • 9 Replies
  • 178 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Hakoo
Member Avatar for debasisdas

Yes you need to use Dynamic SQL.

Try this sample or this.

Edited by debasisdas because: n/a
Member Avatar for crishjeny

yes, you can pass field parameter as well as table name in stored procedure for inserting values

Member Avatar for Hakoo

Can you provide sample code?

Member Avatar for debasisdas

Have you gone through the previously provided link ?

Member Avatar for Hakoo

Yes, I went though those links, but those are ambiguous for me. So, thats why I asked for sample code.

Member Avatar for debasisdas

What the link contains is code only and that to exactly AS PER YOUR REQUIREMENT.

But if you do not understand the code all codes will be ambiguous for you.

Member Avatar for Hakoo

Yes, I don't have deep knowledge of MySql. I am learner and trying to understand the things.

Member Avatar for debasisdas

Then you need to read books and and try to understand the code.

Later you will be able to write your own code.

Member Avatar for Hakoo

Thanking you for your suggestions.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.