Searching for a technique on refreshing the return value on an insert...
ie two commands back to back like so, works great on local environment, no so great when deploying to a godaddy.com env. If you can't find this, then I'm looking for the most efficient method... lightning fast. Needs to be in .net, c# and preferable visual studio 2010 using mysql connector.
insert into `TableName` (`column1`, `column2`) values (@aVarible, @bVariable);
Unfortunately this technique is not working when deploying, and I may have to just do two separate queries if this doesn't work. I'm thinking creating a serializable transaction scope around the two separate methods above. However I don't have the ability to test the efficieny of this technique versus pushing all relevent matches into a set of parameters.