I know that you can insert multiple rows at once, is there a way to update multiple rows at once (as in, in one query) in MySQL? Edit: For example I have the following Name id Col1 Col2Row1 1 6 1Row2 2 2 3Row3 3 9 5Row4 4 16 8 I want to combine all the following Updates into one query UPDATE tab...
I have a table defined (see code snippet below). How can I add a constraint or whatever so that the LastUpdate column is automatically updated anytime the row is changed? CREATE TABLE dbo.Profiles ( UserName varchar(100) NOT NULL, LastUpdate datetime ...
I have a three-tier application which is installed in corporate environments. With every server version update, all clients have to be updated, too. Currently, I provide an MSI package which is automatically deployed via Active Directory, however my customers (mostly with 20-300 users each) seem to hate the MSI solution because it is C...
all the docs for sql alchemy give INSERT and UPDATE examples using the local table instance (i.e. tablename.update()... ) doing this seems difficult with the declarative syntax, I need to reference Base.metadata.tables["tablename"] for get the table reference. Am I sposed to do this another way? Is there a different syntax for INSERT...
We're currently running a server on Compatability mode 8 and I want to update it. What are the implications of just going in and changing it? What is likely to break? Is there anything that checks the data will survive before I perform it? Can I rollback to mode 8 without performing a restore and without loss of data? ...
I've been tasked with maintaining an application originally written in VB6. It has since been imported into VB .Net and to say the least the code is anything but Object Oriented. The code is riddled with classes which contain nothing more than Public Shared attributes(variables) and methods(functions), the result of which restricts the a...
Is there a framework that can be used to enable a C# Windows Service to automatically check for a newer version and upgrade itself? I can certainly write code to accomplish this, but I am looking for a framework that has already been implemented and (most importantly) tested. ...
With which tool / library it is possible to update an existing database structure. On the update of the software it is also needed to change the database. Because there can be different versions of the software it should compare the current status with the target status of the database. It should: add table columns, fill it with defaul...
I have a very large database table in PostgresQL and a column like "copied". Every new row starts uncopied and will later be replicated to another thing by a background programm. There is an partial index on that table "btree(ID) WHERE replicated=0". The background programm does a select for at most 2000 entries (LIMIT 2000), works on th...
At work I'm using Perl 5.8.0 on Windows. When I first put Perl on, I went to CPAN, downloaded all the sources, made a few changes (in the .MAK file? to support threads, or things like that), and did nmake / nmake test / nmake install. Then, bit by bit, I've downloaded individual modules from CPAN and done the nmake dance. So, I'd like ...
We've got a Java server application that runs on a number of computers, all connected to the Internet, some behind firewalls. We need to remotely update the JAR files and startup scripts from a central site, with no noticeable interruption to the app itself. The process has to be unattended and foolproof (i.e. we can't afford to break t...
Eclipse 3.4[.x] - also known as Ganymede - comes with this new mechanism of provisioning called p2. "Provisioning" is the process allowing to discover and update on demand some parts of an application, as explained in general in this article on the Sun Web site. Eclipse has an extended wiki section in which p2 details are presented. ...
Hi, 2 tables: Employees - EmployeeID - LeadCount Leads - leadID - employeeID I want to update the Employees.LeadCount column by counting the # of leads in the Leads table that have the same EmployeeID. Note: There may be more than 1 lead with the same employeeID, so I have to do a Distinct(SUM(employeeID)). ...
I am looking for all addresses related to: 3.x eclipse itself (milestones and/or integration builds) 3.x other components (GEF, GMF, EMF, ...) In the spirit of answering my own question, I do have an answer for: 3.5 eclipse itself, with some details and caveats, 3.6 Helios, with the steps involved to follow the updates. However, ...
I need to install some .NET software on several PC's. This software needs to check each time it is restarted to see if a newer version exists on the server. The end users will have basic user rights and therefore cannot copy files to the 'Program Files' directory. If a newer version exists, the application closes, an updater program c...
When you run something similar to: UPDATE table SET datetime = NOW(); on a table with 1 000 000 000 records and the query takes 10 seconds to run, will all the rows have the exact same time (minutes and seconds) or will they have different times? In other words, will the time be when the query started or when each row is updated? I'm...
I have a server written in Java that runs as a Windows service (thanks to Install4J). I want this service to be able to download the latest version of the JAR file it runs from, and start running the new code. The stitch is that I don't want the Windows service to fully exit. Ideally, I would accomplish this by a unix-style exec() cal...
How do you stay up-to-date when it comes to new software versions? Above all, I mean minor updates (new version for your Joomla-Installation, forum-software, FTP-Client, ...). Versiontracker, RSS-Feeds, Newsletter... what else? Anyone wrote a script crawling websites for new versions or something similar? ...
Hi, I got some problems with finding a bug in php/mysql application, and I wonder if I can do something like this: UPDATE table SET userid='2' WHERE userid='1' - > Can I update something I state in WHERE? ...
Hi All I realy hope someone can help me with this. I have a databse with Account Numbers and card Numbers that I match to a file to update any card numbers to account number so I only work with account numbers. I created a view linking the Table to the Account/Card db to return the Table ID and the related Account number. Now I need to ...