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

[Jxwong2203]

i nid to insert values from concatenate string into mysql with using LabSQL, but the result come out from conatenate string is like " 2015-07-08 00:00:00 38.933235E-3" , a logged data of "Date Time Wind Speed(m/s). i nid to put these 3 values into 3 different column in mysql which is Date Time and Wind Speed. How can i pick Date to put inside Date's column, Time into Time's column and Wind Speed into Wind Speed's column in mysql ?

What i do is
INSERT INTO wind_speed_data (Date, Time, Wind_Speed) The space in Wind Speed can i put a _ in between Wind Speed? without _ and just put Wind Speed it shows errors.

VALUES( i have no idea wat to key in at this part ) <--- nid help !

The Mysql table. Date Time Wind Speed

The result from concatenate string. Have to insert into mysql.

My labview program.

The error i facing.

[Dennis_Knutson]

Why are you still using the wrong syntax with value1, value2, etc. when you were answered at http://forums.ni.com/t5/LabVIEW/Someone-can-help-me-please/td-p/3145791/page/2 with the correct way to use the format string.

[mikeporter]

Well, most of this problem is a question about SQL syntax. In the VALUES clause you put a comma delimited list of the values to go into the new record. You insert one record at a time. How are the columns defined? Have you done any study on basic SQL?

Mike...

[Jxwong2203]

Hi dear dennis, I did try what dkfire taught me. i try my program as below pic.

and i got this error...

[mikeporter]

First off, the syntax is wrong. You need to use a single quote (') not the character you used (`). Second, how are the columns defined?

Mike...

[Jxwong2203]

hi mike, thanks for ur reply. appreciate it !. The columns defines do u means the 3 columns created in mysql ? the datetype of the columns ?

Date format Datetime, Time format timestamp, Wind Speed format decimal(10,10). all 3 are not nullable.

[jcarmody]

---

@Jxwong2203 wrote:

hi mike, thanks for ur reply. appreciate it !. The columns defines do u means the 3 columns created in mysql ? the datetype of the columns ?

Date format Datetime, Time format timestamp, Wind Speed format decimal(10,10). all 3 are not nullable.

---

Just a random, drive-by, comment here...  I've had trouble with column names before and "Date" and "Time" look like they might be reserved words in a DBMS.  Also, in Access anyway, if a column name has spaces you need to enclose it in brackets, so "[Wind Speed]", not "Wind_Speed".

[Jxwong2203]

Hi jim, thanks for your advise !!

[dkfire]

Jim is correct, Date and Time needs [] around them. 

Then why (the f..) are are you giving the same data to ALL you controls? 

[Jxwong2203]

hi dkfire , i did 4lo your advise to connect up. 

Connected as below. One question, do i nid to connect the output of concatenate string to the initial string of format into string ? Because i get my data from concatenate string.

I have no idea how to put the data from concatenate string into my control of Date, Time, Wind Speed. because my these 3 values get it from concatenate string.

i got no values in my control of Date, Time, Wind Speed. =.=