Search This Blog

Labels

adobe (1) android (3) apache (3) aviation (1) bash (2) chrome (2) composer (1) cookery (3) dev (2) dodanperks (1) extensions (1) facebook (2) firefox (1) git (2) grafana (1) guzzle (1) headaches (11) htaccess (1) html5 (2) jquery (2) lamp (1) life hacks (10) linux (28) mysqli (2) native (1) opera (2) php (10) railfanning (1) reactjs (3) reactnative (1) servers (11) sinhala (1) smartphones (2) snap (1) sound (1) tech (22) troubleshoots (4) ubuntu (29) unicode (4) virtualbox (1) wamp (2) web (11) windows (4) wordpress (3) youtube (2) කෑම (3)

Tuesday, 13 June 2017

mysqli CONCAT strings into column


This method can be used to concat strings into the same column.
UPDATE `tbl_name` SET `column_1` =CONCAT( 'string',`column_1`)

If you want to update another column with concat another column, use this
UPDATE `tbl_name` SET `column_1` =CONCAT( 'string',`column_2`)

No comments:

Post a Comment