RE: MySQL

[Puneet_K]

Hiii,

Can anybody provide me the general procedure for connectivity MySQL with LabVIEW via LabSQL.

Regards

Puneet Kapoor

[Wiebe@CARYA]

Make a new ODBC source to your MySQL database (in the windows control
panel). You need to install MySQY ODBC driver first (download it from the
internet).

Then, open a connection to the data base, and execute your queries.

Regards,

Wiebe.

[Puneet_K]

Thanks for ur response..

I already created ODBC database using MySQL and create DSN connection using ODBC connector...Afterwards i do not much knowledge how to create queries n all..

Pls do the needful.

[Dennis_Knutson]

Try googling 'SQL tutorial'. I've never looked to see what is included with MySQL. The only database that I have experience with is SQL Server and that came with an extensive help file. See what MySQL provides. Since I'm not convinced that the LabVIEW board is an appropriate place for extensive discussions of the SQL language, you might want to find a dedicated SQL forum that can point you to the best locations. One other possibility is to use MS Access as a learning tool. You can create queries with the wizard and graphical tool it has and then select to view the SQL code.

The use of LabSQL presumes some basic knowledge of the SQL language. The NI Database Connectivity Toolkit hides a lot of that and might be a better choice if you need to get something working quickly.

Message Edited by Dennis Knutson on 01-23-2008 09:44 PM

[Wiebe@CARYA]

MySQL has a comlete set of standard SQL queries. Procedures and that kind of
stuff isn't inclused in the SQL standard, so they are handled differently.
Even though SQL is a standard, there might be minor differences between e.g.
naming conventions (even between SQL Server and Access). Don't worry about
that, that only applies when you want to do advanced stuff.

There are some things like nested queries that Access (and perhaps SQL
Server) do support, but MySQL doesn't. So if your SQL tutorial is aimed at
Access, keep that in mind.

Regards,

Wiebe.

[Britoa]

actually, mysql 5 (I believe) supports subqueries. I have used them a few times.

[Wiebe@CARYA]

That's nice to know. It could save a lot of work!

Regards,

Wiebe.