update column in all rows in mysql

Question

I have a table called tbl_portfolio described as below and i want to modify all imagePath columns by adding projectId at start, i.e abc.jpg will change to <project_id>/abc.jpg.I am not very skilled with Mysql.. :(

| portfolioId | int(11)      | NO   | PRI | NULL    | auto_increment |
| projectId   | int(11)      | YES  |     | NULL    |                |
| customerId  | int(11)      | YES  |     | NULL    |                |
| imagePath   | varchar(500) | YES  |     | NULL    |                |
| description | text         | YES  |     | NULL    |                |
| addDate     | date         | YES  |     | NULL    |                |
| lastUpdated | date         | YES  |     | NULL    |                |
| coverPhoto  | int(1)       | YES  |     | 0       |                |

Saharsh Shah · Accepted Answer · 2013-12-19 06:52:58Z

4

Try this:

Use CONCAT function to merge the string

UPDATE tbl_portfolio 
SET imagePath = CONCAT(CAST(projectId AS CHAR(20)), '/', imagePath);

edited Dec 19, 2013 at 6:52

answered Dec 19, 2013 at 6:44

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

naveen goyal · Accepted Answer · 2013-12-19 06:45:41Z

0

Try this without where clause its update all rows. read this for more http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat

UPDATE tablename 
set imagePath = CONCAT(CAST(projectId AS CHAR(20)),"/",imagePath)

answered Dec 19, 2013 at 6:45

naveen goyal

4,6272 gold badges18 silver badges26 bronze badges

Comments

arturataide · Accepted Answer · 2013-12-19 06:46:31Z

0

I think this will help

UPDATE tbl_portfolio SET imagePath = CONCAT('/', projectId);

answered Dec 19, 2013 at 6:46

arturataide

3742 silver badges11 bronze badges

Comments

aksu · Accepted Answer · 2013-12-19 06:50:06Z

0

You can include column values to another columns value. See simple example:

UPDATE tbl_portfolio SET imagePath = tbl_portfolio.projectId + '/' + tbl_portfolio.imagePath;

answered Dec 19, 2013 at 6:50

aksu

5,2365 gold badges26 silver badges39 bronze badges

Comments

Maulik patel · Accepted Answer · 2013-12-19 07:04:26Z

0

Please You are use Update Query.

<?php
  $Query= UPDATE tbl_portfolio SET imagePath='/abc.jpg' WHERE portfolioId=1;
  mysql_query ($Query);

?>

answered Dec 19, 2013 at 7:04

Maulik patel

2,4502 gold badges21 silver badges28 bronze badges

Comments

Tin Tran · Accepted Answer · 2013-12-19 07:39:24Z

0

UPDATE tbl_portfolio
SET imagePath = CONCAT(projectId,"/",imagePath);

edited Dec 19, 2013 at 7:39

answered Dec 19, 2013 at 6:45

Tin Tran

6,1763 gold badges25 silver badges34 bronze badges

Comments

Fr0g · Accepted Answer · 2013-12-19 06:45:51Z

-2

you can use udate table command, the exact syntax will be like -

UPDATE tbl_portfolio SET imagePath='/abc.jpg';

more infoe here - http://dev.mysql.com/doc/refman/5.0/en/update.html

answered Dec 19, 2013 at 6:45

Fr0g

2521 silver badge9 bronze badges

Collectives™ on Stack Overflow

update column in all rows in mysql

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related