Why is this SQL statement not executing?

Question

I have an SQL statement without a where clause because I want it to affect all rows. I have a column with the name url. Now I want to change the current column url to something else. I want to concatenate something to the current url.

My statement is:

 UPDATE tablename SET url = 'http' || url;

This is in a sql file, which executes and throws no errors but the database is not changing.

Can anyone help?

RDBMS is MySQL

tsql uses ( + ) for concat... are you using oracle... or some other sql language? in tsql the || is a bitwise operator — RThomas
– RThomas, Commented Sep 19, 2011 at 18:35
Certainly that code will not work with all SQL databases. It would fail in SQL Server for instance that uses a + for concatentation. — HLGEM
– HLGEM, Commented Sep 19, 2011 at 19:05

gbn · Accepted Answer · 2011-09-19 18:34:35Z

3

Depending on your engine (in case it isn't Oracle and you have some bizarre MySQL bitwise operator)

UPDATE tablename SET url = CONCAT('http', url);

or

UPDATE tablename SET url = 'http' + url;

answered Sep 19, 2011 at 18:34

gbn

435k85 gold badges602 silver badges690 bronze badges

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

1 Comment

gbn Over a year ago

@user953278: Thanks What RDBMS though please?

Chandu · Accepted Answer · 2011-09-19 18:34:14Z

3

(Assuming its an Oracle DB)
I guess you are not commiting the changes and checking for the changes in other session.

Change your script file to:

UPDATE tablename SET url = 'http' || url; 
COMMIT;

answered Sep 19, 2011 at 18:34

Chandu

83.2k19 gold badges137 silver badges136 bronze badges

Comments

vc 74 · Accepted Answer · 2011-09-19 18:35:14Z

2

You may need to commit the transaction if commit is not implicit. Try

COMMIT;

answered Sep 19, 2011 at 18:35

vc 74

38.3k7 gold badges80 silver badges96 bronze badges

Collectives™ on Stack Overflow

Why is this SQL statement not executing?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related