Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: value (reset)

Does Consona-Compiere mean community doesn’t matter?
+0 Vote Up -2Vote Down

There was another acquisition involving open source software recently when Consona bought Compiere, but what is perhaps most striking about the deal from an open source software perspective is how little it and the Compiere community mattered in the deal.

By most accounts, including that of fellow open source ERP player xTuple CEO Ned Lilly, who offers an interesting and accurate depiction of Compiere’s changes, acknowledge the movement away from community that occurred over the last few years at Compiere. As discussed in our own …

  [Read more...]
451 CAOS Links 2009.07.31
+0 Vote Up -0Vote Down

When open source goes bad. Is open source a success or failure? And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

When open source goes bad

The H reported on the apparent turmoil at the CentOS project, while Jay Lyman offered the CAOS …



  [Read more...]
Swapping Column Values in MySQL
+0 Vote Up -0Vote Down

Today I had to swap 2 columns in one of my MySQL tables. The task, which seems easily accomplishable by a temp variable, proved to be a bit harder to complete. But only just a bit.

Here are my findings:

  1. The

    UPDATE swap_test SET x=y, y=x;
    

    approach doesn't work, as it'll just set both values to y.

    PostgreSQL seems to handle this query differently, as it apparently uses the old values throughout the whole query. [Reference]
  2. Here's a method that uses a temporary …

  [Read more...]
Showing entries 1 to 3

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

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.