Styjun

Correlation of independent random processes

Are there any intersection of Theory A and Theory B?

Optimising Table wrapping over a Select

Supporting developers who insist on using their pet language

What is this welding tool I found in my attic?

Why is dry soil hydrophobic? Bad gardener paradox

Why isn't pressure filtration popular compared to vacuum filtration?

Can I use "candidate" as a verb?

What's a moment that's more impactful on a reread called?

Machine learning and operations research projects

Why do players in the past play much longer tournaments than today's top players?

As the Dungeon Master, how do I handle a player that insists on a specific class when I already know that choice will cause issues?

Can I play a first turn Simic Growth Chamber to have 3 mana available in the second turn?

What explains 9 speed cassettes price differences?

Is an acid a salt or not?

Why isn't there research to build a standard lunar, or Martian mobility platform?

Who Can Help Retag This?

What does the standard say about char arrays as template arguments?

I have a ruthless DM and I'm considering leaving the party. What are my options to minimize the negative impact to the rest of the group?

Why can't supermassive black holes merge? (or can they?)

How do Windows version numbers work?

Is Trump personally blocking people on Twitter?

Extract an attribute value from XML

As a DM, how to avoid unconscious metagaming when dealing with a high AC character?

Update table query having a composite key as primary key

How do I (or can I) SELECT DISTINCT on multiple columns?SQL update from one Table to another based on a ID matchMySQL - UPDATE query based on SELECT QueryUpdate a table using JOIN in SQL Server?SQL UPDATE with composite primary keyHow to set auto increment primary key in PostgreSQL?MySQL error code: 1175 during UPDATE in MySQL WorkbenchComposite primary key in djangoPostgresql add existing column to composite primary keyunion table, change serial primary key, postgresql

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have a table with 3 columns:

1. id


2. string1


3. string2

id and string1 together form a composite primary key

I need to update value of string2

update tablename 
 set string2="abc" 
where id=1 
 and string1="xyz"

postgresql sql-update

share|improve this question

edited Mar 26 at 8:38

a_horse_with_no_name

322k5151 gold badges496496 silver badges599599 bronze badges

asked Mar 26 at 4:36

purvaBpurvaB

4944 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  String constants need to be supplied using single quotes in SQL. "xyz" refers to a column, 'xyz' would be a constant postgresql.org/docs/current/…
  
  – a_horse_with_no_name
  Mar 26 at 8:38
  
  

  
  
  
  

add a comment | 

0

I have a table with 3 columns:

1. id


2. string1


3. string2

id and string1 together form a composite primary key

I need to update value of string2

update tablename 
 set string2="abc" 
where id=1 
 and string1="xyz"

postgresql sql-update

share|improve this question

edited Mar 26 at 8:38

a_horse_with_no_name

322k5151 gold badges496496 silver badges599599 bronze badges

asked Mar 26 at 4:36

purvaBpurvaB

4944 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  String constants need to be supplied using single quotes in SQL. "xyz" refers to a column, 'xyz' would be a constant postgresql.org/docs/current/…
  
  – a_horse_with_no_name
  Mar 26 at 8:38
  
  

  
  
  
  

add a comment | 

I have a table with 3 columns:

1. id


2. string1


3. string2

id and string1 together form a composite primary key

I need to update value of string2

update tablename 
 set string2="abc" 
where id=1 
 and string1="xyz"

postgresql sql-update

share|improve this question

edited Mar 26 at 8:38

a_horse_with_no_name

322k5151 gold badges496496 silver badges599599 bronze badges

asked Mar 26 at 4:36

purvaBpurvaB

4944 bronze badges

update tablename 
 set string2="abc" 
where id=1 
 and string1="xyz"

share|improve this question

edited Mar 26 at 8:38

a_horse_with_no_name

322k5151 gold badges496496 silver badges599599 bronze badges

asked Mar 26 at 4:36

purvaBpurvaB

4944 bronze badges

share|improve this question

edited Mar 26 at 8:38

a_horse_with_no_name

322k5151 gold badges496496 silver badges599599 bronze badges

asked Mar 26 at 4:36

purvaBpurvaB

4944 bronze badges

edited Mar 26 at 8:38

a_horse_with_no_name

322k5151 gold badges496496 silver badges599599 bronze badges

edited Mar 26 at 8:38

a_horse_with_no_name

322k5151 gold badges496496 silver badges599599 bronze badges

asked Mar 26 at 4:36

purvaBpurvaB

4944 bronze badges

asked Mar 26 at 4:36

purvaBpurvaB

4944 bronze badges

1 Answer
1

active

oldest

votes

0

Try using single quotes around the string literal values:

UPDATE tablename
SET string2 = 'abc'
WHERE id = 1 AND string1 = 'xyz';

In most flavors of SQL, double quotes is a means of escaping an identifier (such as a column or table name).

share|improve this answer

answered Mar 26 at 4:37

Tim BiegeleisenTim Biegeleisen

259k1313 gold badges110110 silver badges170170 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I cannot assist you beyond the above answer. If you have another problem, then consider opening a new question.
  
  – Tim Biegeleisen
  Mar 26 at 8:05
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55349928%2fupdate-table-query-having-a-composite-key-as-primary-key%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Try using single quotes around the string literal values:

UPDATE tablename
SET string2 = 'abc'
WHERE id = 1 AND string1 = 'xyz';

In most flavors of SQL, double quotes is a means of escaping an identifier (such as a column or table name).

share|improve this answer

answered Mar 26 at 4:37

Tim BiegeleisenTim Biegeleisen

259k1313 gold badges110110 silver badges170170 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I cannot assist you beyond the above answer. If you have another problem, then consider opening a new question.
  
  – Tim Biegeleisen
  Mar 26 at 8:05
  

  
  
  
  

add a comment | 

0

Try using single quotes around the string literal values:

UPDATE tablename
SET string2 = 'abc'
WHERE id = 1 AND string1 = 'xyz';

In most flavors of SQL, double quotes is a means of escaping an identifier (such as a column or table name).

share|improve this answer

answered Mar 26 at 4:37

Tim BiegeleisenTim Biegeleisen

259k1313 gold badges110110 silver badges170170 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I cannot assist you beyond the above answer. If you have another problem, then consider opening a new question.
  
  – Tim Biegeleisen
  Mar 26 at 8:05
  

  
  
  
  

add a comment | 

Try using single quotes around the string literal values:

UPDATE tablename
SET string2 = 'abc'
WHERE id = 1 AND string1 = 'xyz';

In most flavors of SQL, double quotes is a means of escaping an identifier (such as a column or table name).

share|improve this answer

answered Mar 26 at 4:37

Tim BiegeleisenTim Biegeleisen

259k1313 gold badges110110 silver badges170170 bronze badges

UPDATE tablename
SET string2 = 'abc'
WHERE id = 1 AND string1 = 'xyz';

share|improve this answer

answered Mar 26 at 4:37

Tim BiegeleisenTim Biegeleisen

259k1313 gold badges110110 silver badges170170 bronze badges

answered Mar 26 at 4:37

Tim BiegeleisenTim Biegeleisen

259k1313 gold badges110110 silver badges170170 bronze badges

answered Mar 26 at 4:37

Tim BiegeleisenTim Biegeleisen

259k1313 gold badges110110 silver badges170170 bronze badges