Solved

MySQL Update

Posted on 2013-11-13
2
350 Views
Last Modified: 2013-11-13
I have wrote a statement to identify the columns I want to update

select female_names_males.cname, tbl.cname, tbl.genderid from female_names_males
inner join tbl on female_names_males.cname = tbl.cname 
where tbl.genderid = '2'

Open in new window


This runs fine and identifies the rows between both tables

I now want to update the rows and thought this would work

Update tbl
set tbl.genderid = '1'
inner join tbl on female_names_males.cname = tbl.cname 
where tbl.genderid = '2'

Open in new window


Any Ideas
0
Comment
Question by:Brogrim
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
warddhooghe earned 500 total points
ID: 39644591
update table inner join other_table
set ... etc
0
 

Author Closing Comment

by:Brogrim
ID: 39644687
as Homer would say DOH, thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question