Reading last row data from Mysql database using LabVIEW

 

I have used LabVIEW 2011, database connectivity toolkit to develop the database program. In LabVIEW database connectivity toolkit there is not straight vi to access the last record from the database.

to get the last record,

1. Add one extra column named ID with the parameter of int & auto increment.

2. Like I shown in the above diagram code your program. you will get the maximum value of your ColumnID.

3. then you can add another select.vi with where ID=column ID that you got from the previous select.vi

4. You will get the last record.