Logging to MySQL with AutoIncrement

[paatricky]

Hi,

I am currently trying to swap from Logging Teststand results into an MS Access DBase, to MySQL 5.1. I use the "Recordset" approach to logging, with "SELECT" statements, and the "Autogenerated/Counter" type for primary keys, mainly to keep the database size reasonable, by avoiding the use of GUID's. Is it possible to use the same method but under MySQL? I have found some old posts, on previous versions of Teststand/MySQL where it looked pretty tough. Is there an example or a description of how to do it?

Cheers

[TaylorG]

Hi Paatricky,

I hope you are doing well today!  I have attached a link to an NI Developer Zone Tutorial and another Discussion Forum post regarding logging data from TestStand to a MySQL database.  These should help you migrate your TestStand setup to log results to a MySQL database.  Please let us know if you have any further questions.  I hope this helps, Paatricky.  Have a great day!

NI Developer Zone Tutorial: Logging TestStand Results to a MySQL Database

NI Discussion Forum: Update new record in database table