write data from labview to mysql

[urikorulzs2]

we need some help with our project.

we are using labview to communicate with mysql. in mysql we have 2 tables, a cats and dogs tables, in the tablle for each animal, it has a field for name, breed, age, picture, and info.

we want to be able to enter all the information into a labview gui which is already created, but just not sure how to send the data over to mysql. 

also the mysql and labview are both local. please any help would be great.

[Dennis_Knutson]

What are you using to connect to the database? NI's toolkit or LabSQL? Both come with examples that should help you get started. You will be doing SQL INSERT commands but the NI toolkit hides some of the SQL language stuff. If you use LabSQL, I suggest finding a SQL tutorial on the web.

[NitzZ]

Hi,

I think the easiest way to do this is by using the LabSQL tool kit. Going through the Test.vi from the attachement would give you an idea of how to do it. If this solves your problems, mark it as the solution

Regards,

Nitz

(Kudos are always Welcome)

[Ljubo]

I'm trying to solve another problem but this link might be useful for you too (see appended VI). You can see how LabSQL and DB Connectivity Toolkit are used.

Best regards.

http://forums.ni.com/t5/LabVIEW/mysql-database-counting-records/td-p/1504946

[urikorulzs2]

we are actually using the db toolkit to connect both of them, is there anyways someone can get an examples of a code to enter a row of data into a mysql table with 8 columns. from labview. 

the table is called dogs and the coloumns are name, breed, sex, age, weight, tag #, info, and picture.

[Dennis_Knutson]

Help>Find Examples. There's 'Database Insert' and 'Sixtypes Insert'. You are not going to find an example specifically using your data. Modify as needed.