Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <andipersti@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.003
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'column': 0.07; 'received:192.168.178': 0.07; 'string': 0.09; 'filename': 0.09; 'subject:into': 0.09; 'subject:string': 0.09; 'subject:How': 0.10; '(filename,': 0.16; 'andreas': 0.16; 'bye,': 0.16; 'nick': 0.16; 'received:192.168.178.20': 0.16; 'specific,': 0.16; 'subject:already': 0.16; 'wrote:': 0.18; 'trying': 0.19; 'python?': 0.22; 'header:User-Agent:1': 0.23; 'header:In-Reply- To:1': 0.27; 'record': 0.27; 'host': 0.29; 'array': 0.29; 'subject:list': 0.30; 'quotes': 0.31; 'problem': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'add': 0.35; 'list': 0.37; 'message-id:@gmail.com': 0.38; 'problems': 0.38; 'to:addr:python- list': 0.38; 'to:addr:python.org': 0.39; 'numbers': 0.61; 'here': 0.66; 'column.': 0.84; 'subject:add': 0.91
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=GiHG10VcPnUsWcYJmZPEFaKTegyyHe2JZE291tgPhv4=; b=hYRIDwXN+EVbe1kegNRWvU5LPbsrNJFmh30pAWz8h1sRBrqvrPJwvlvLD7+agMoho9 63TJyoVfzziUGMTWtBYJeGM6KYi+9PmR5e5F3t71/2hGL6urB63H8jDNtpoyidk4emTz JqM8R8jdRfS4ruWsvuGYKNwgEDaejKPZ2vDVRiLFAY3BCEoKFr4eEr9MO+pfog2MUA+r WJO2aYa4P74CPpM9Z1xqgHDVRu05UE9UtvDExQfulmGLkWejjzT+tTqib7G1wIF9nKTZ /kpXYcb8YFAa3MxCabtpQ8M8JLiQup8RbWTERM/D9GeA9xTHtrp1b0Lttx7EiRAJXyYq SFKg==
X-Received: by 10.14.103.133 with SMTP id f5mr7525909eeg.48.1383397394375; Sat, 02 Nov 2013 06:03:14 -0700 (PDT)
Date: Sat, 02 Nov 2013 14:03:11 +0100
From: Andreas Perstinger <andipersti@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:24.0) Gecko/20100101 Thunderbird/24.0
MIME-Version: 1.0
To: python-list@python.org
Subject: Re: How to add a current string into an already existing list
References: <l52pdo$k0f$1@dont-email.me>
In-Reply-To: <l52pdo$k0f$1@dont-email.me>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.1951.1383398828.18130.python-list@python.org>
Lines: 23
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1383398828 news.xs4all.nl 15888 [2001:888:2000:d::a6]:42932
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:58326

On 02.11.2013 12:58, Nick the Gr33k wrote:
> Trying to add the current filename into the existent 'downloads' column
> Somehow i don't think i just use the plus sign into an existing column.
> We don't try to add numbers here but add an extra string to an already
> existing array of strings(list).

[SNIP]

> # update specific visitor's download record
> cur.execute('''UPDATE visitors SET downloads = downloads + %s WHERE host
> = %s''', (filename, host) )
> ======================================================

Well, when do you understand that your MySQL problems have nothing to do 
with Python?

Everything inside the triple quotes is MySQL specific, so it's a MySQL 
problem whether you can use + to "add an extra string to an already 
existing array of strings(list)".

This list is not a MySQL support forum.

Bye, Andreas