need help for "From concatenate string insert to mysql table"

[jcarmody]

I still think you can't use "Date" or "Time" as column names; try putting them in square brackets, too.  I'd rename the columns if it was my database.

[Jxwong2203]

 ic, thanks jim. i will change the columns' name to try it out. Jim i have a questions. My value data of Date, Time, and Wind Speed are logged and get the output from concatenate string. as pic below

The output of the concatenate string would be Date[Tab]Time[Tab]Wind Speed , can i also store the value of Date into 1 variable like a, data of Time into 1 variable like b, and data of  Wind speed into 1 variable like c. den i can just INSERT INTO wind_speed_data ( column1,column2,column3 ) VALUES ( a, b, c) . is tis can method works?

My program is log wind speed data every 1 minute, and write it into a text file. this part is done, but im requested to save the logged data into mysql database too instead of text file only. im stuck at tis part @.@... 

[Sam_Sharp]

You need to wire the values you put into your concatenate string to the inputs of the format into string. At the moment you have controls so it will insert the data from the controls on your front panel ('Date', 'Time', 'Wind Speed').

At the moment your controls are empty so you are writing empty data.

[jcarmody]

Like this.   By the way, why are you adding zero to your wind speed?

[Jxwong2203]

Thanks sam and jim. I will gv it a try ! Jim, its a formula given by my teacher. Have to 4lo. 😞

[Jxwong2203]

Now my connection is as below. 

And it shows tis thing out. DateTime Error.

I change my column in mysql to A B C first to try out... ( A - Date, B - Time, C - Wind Speed)

[Sam_Sharp]

You need to format the datetime into a valid string to insert into the database that it understands. Try something like YYYY/MM/DD HH:MM:SS (it might be '-' instead of '/').

The clue is in the error message.

[Jxwong2203]

ok noted.! thanks you sam 😄

[mikeporter]

A, B and C for column names? Are you kidding us? How about something descriptive like test_date or sample_time? Do you give names to your VIs like that?

Mike...

[PhillipBrooks]

---

@mikeporter wrote:

Do you give names to your VIs like that?

Mike...

---

Mine are named Untitled 1.vi, Untitled 2.vi ... Untitled 33.vi