Truncated incorrect DOUBLE value: '-'

Question

I am new to mysql. I am trying to combine two columns with - in between however I am getting error. If anyone could give me advice I will really appreciate it. I am getting error in this part: ,x_end_year +"-" +x_start_month+"-01",

Error Code: 1292 Truncated incorrect DOUBLE value: '-'

INSERT INTO earning (id, dateCreated, dateModified, x_t_name, x_start_date, 
                     x_end_month, x_address, x_category, x_pic, x_promo_space, 
                     x_start_month, x_space_query, x_organizer, x_end_date, 
                     x_address_query, x_current_pic, x_start_year, x_end_year,
                     x_event_title, x_pix_name),

SELECT x_idx, dateCreated, dateModified, "" , x_end_year +"-" +x_start_month+"-01",
       x_end_month, "address1", "", x_current_pic, "", x_start_month, "''", "", 
       x_end_year +"-" +x_end_month+"-01", "'address1'", x_current_pic, x_end_year, 
       x_end_year, "", ""
FROM Sale
WHERE id = 'x1'

Use `CONCAT()` for concatenating strings. It's much more reliable and readable. — TrebledJ, Nov 28 '18 at 01:31
Possible duplicate of [String concatenation in MySQL](https://stackoverflow.com/questions/5975958/string-concatenation-in-mysql) — Nick, Nov 28 '18 at 01:58
MySQL does not support `+` for concatenating strings. You must use `CONCAT()` or the `||` operator (if that has been enabled) — Nick, Nov 28 '18 at 01:58

score 1 · Answer 1 · answered Nov 28 '18 at 08:07

1

You just need to use CONCAT. Here is a sample.

SELECT CONCAT (column1, column2, '-', column3, column4)

answered Nov 28 '18 at 08:07

Buchiman

320
5
18

Truncated incorrect DOUBLE value: '-'

1 Answers1