How to create table using mysql in LabVIEW

[Karthikeyan_Mathiyalagan]

Hii

           I am using mysql database Toolkit for my project.  In that how to New create a table. Is there any possiblilites to create a table using query...can u send a sample prg ... and inform which toolkit Vi to use....  

[Dennis_Knutson]

The SQL syntax for creating a table is:

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

The toolkit has a funciton called DB Tools Create Table. That would be the obvious function to use if you don't want to execute a SQL query to create the table. The tooklit comes with examples. Have you looked at them? There's one called Create Database Table that  would seem to be exactly what you are looking for.

[jcarmody]

What Dennis said, or use DB Tools Execute Query.vi in the Advanced pallet.  I'm guessing that you want to add more information than the toolkit allows?