hello, i want update my row and concat my string but i have an error with this query
UPDATE FILE SET NOMFIC ='supp_'+D_NOMFIC WHERE IdFile = 2
views:
169answers:
3
A:
You can't concat with + in MySQL. Use CONCAT('supp_, D_NOMFIC), so it becomes UPDATE FILE SET NOMFIC = CONCAT('supp_, D_NOMFIC) WHERE IdFile = 2
For more info see: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat
You can concat quoted strings like this: SELECT 'a' 'b' 'c' FROM someTable though.
Snake
2010-05-06 13:23:47
i want to get my string and concat with 'supp' and do update
Mercer
2010-05-06 13:26:35
if D_NOMFIC is 'blah' than the result will be 'supp_blah'
Snake
2010-05-06 13:28:15
yes but not working with this method
Mercer
2010-05-06 13:29:02
D_NOMFIC doesn't exist? What's the column's name?
Snake
2010-05-06 13:31:32
A:
UPDATE FILE SET NOMFIC = CONCAT('supp_',NOMFIC) WHERE IdFile=2;
See the CONCAT() function within the MySQL documentation here
CONCAT() basically takes as its parameters a list of strings to be concatenated together.
Mailslut
2010-05-06 13:24:07
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET NOMFIC =CONCAT('supp_',D_NOMFIC)
Mercer
2010-05-06 13:25:48
@Mercer: that works for me fine. You should be doing something else wrong
Cristian
2010-05-06 13:28:32
@mercer, you have the field D_NOMFIC in your original question. I'm guessing you just meant NOMFIC. If so, this is what you want:UPDATE FILE SET NOMFIC = CONCAT('supp_',NOMFIC) WHERE IdFile=2;
Mailslut
2010-05-06 13:31:59