dear all
I need to make insert rows in this from
ID static full
1 A A1
2 A A2
the first column ID second one static value equal "A" third column static value+ID
so please how to make the third value
insert statment
Moderator: General Moderators
Re: insert statment
Code: Select all
UPDATE TABLE SET `full`=CONCAT(`static`, `ID`)Re: insert statment
does it mean I will make concat with every insertmikemike wrote:Code: Select all
UPDATE TABLE SET `full`=CONCAT(`static`, `ID`)
Re: insert statment
every entry in the table. If you don't want to do that then stick a WHERE clause in
Re: insert statment
I try to this but did not passmikemike wrote:Code: Select all
UPDATE TABLE SET `full`=CONCAT(`static`, `ID`)
UPDATE TABLE SET `full`=CONCAT(`static`, `ID`) where Id=Max(id)
It give me this error #1111 - Invalid use of group function
any suggestion please