MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: UPDATE a field SEVERAL times in 1 UPDATE
Posted by: Peter Brawley
Date: August 19, 2010 12:04PM

"Bigcrime Crimebig"

1. The data you show ...

id......users......trans.....Relationed.....fills
1.......David......5.........Carl................0
... etc...

... is not in the form of INSERT statements, and does not match the table described in your CREATE TABLE statement.

2. As Chad says, the table you show is incorrectly designed for the task you outline. On what you have said so far, you appear to need need two tables at least. Follow http://www.artfulsoftware.com/dbdesignbasics.html or a similar database design algorithm to find the correct table structures for your problem.

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.