y. You need to
report about it, at least:
* How did you installed C mysql client library.
* The output of the `mysql_config`
* The output of the `ldd
/usr/local/lib64/python3.6/site-packages/mysqlclient-1.4.4-py3.6-linux-x86_64.egg/MySQLdb/_mysql.cpython-36m-x86_64-linux-gnu.so`
Regards,
--
Inada Naoki
--
https://mail.python.org/mailman/listinfo/python-list
On Wed, Aug 14, 2019 at 9:27 AM DL Neil wrote:
>
> On 14/08/19 6:14 AM, Chris Angelico wrote:
> > That seems very odd. The mysqlclient binary might be just under a
> > different name? I'm not familiar with RHEL, but on my Debian, there
> > are packages like "mysql-server-5.7" and corresponding
> >
On 14/08/19 6:14 AM, Chris Angelico wrote:
On Wed, Aug 14, 2019 at 1:48 AM Larry Martell wrote:
On Tue, Aug 13, 2019 at 9:59 AM Chris Angelico wrote:
On Tue, Aug 13, 2019 at 11:33 PM Larry Martell wrote:
I am trying to install MySQLdb (https://pypi.org/project/mysqlclient/)
for
On Tue, Aug 13, 2019 at 2:16 PM Chris Angelico wrote:
>
> On Wed, Aug 14, 2019 at 1:48 AM Larry Martell wrote:
> >
> > On Tue, Aug 13, 2019 at 9:59 AM Chris Angelico wrote:
> > >
> > > On Tue, Aug 13, 2019 at 11:33 PM Larry Martell
> > > wrote:
&
On Wed, Aug 14, 2019 at 1:48 AM Larry Martell wrote:
>
> On Tue, Aug 13, 2019 at 9:59 AM Chris Angelico wrote:
> >
> > On Tue, Aug 13, 2019 at 11:33 PM Larry Martell
> > wrote:
> > >
> > > I am trying to install MySQLdb (https://pypi.org/project/
On Tue, Aug 13, 2019 at 9:59 AM Chris Angelico wrote:
>
> On Tue, Aug 13, 2019 at 11:33 PM Larry Martell
> wrote:
> >
> > I am trying to install MySQLdb (https://pypi.org/project/mysqlclient/)
> > for python3.6 on RHEL7.
> >
> > When I import it, it fail
On Tue, Aug 13, 2019 at 11:33 PM Larry Martell wrote:
>
> I am trying to install MySQLdb (https://pypi.org/project/mysqlclient/)
> for python3.6 on RHEL7.
>
> When I import it, it fails:
>
> # python3.6
> Python 3.6.8 (default, Jun 11 2019, 15:15:01)
> [GCC 4.8.5 2015
rtell :
>>
>> I am trying to install MySQLdb (https://pypi.org/project/mysqlclient/)
>> for python3.6 on RHEL7.
>>
>> When I import it, it fails:
>>
>> # python3.6
>> Python 3.6.8 (default, Jun 11 2019, 15:15:01)
>> [GCC 4.8.5 20150623 (Red Hat 4.8
Why do you use RHEL?
I believe people use RHEL to get support from Red Hat, instead of community
support.
2019年8月13日(火) 22:32 Larry Martell :
> I am trying to install MySQLdb (https://pypi.org/project/mysqlclient/)
> for python3.6 on RHEL7.
>
> When I import it, it fails:
>
I am trying to install MySQLdb (https://pypi.org/project/mysqlclient/)
for python3.6 on RHEL7.
When I import it, it fails:
# python3.6
Python 3.6.8 (default, Jun 11 2019, 15:15:01)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)] on linux
Type "help", "copyright", "credi
On Thursday, November 16, 2017 at 5:32:23 AM UTC+13, Tobiah wrote:
> AttributeError: 'Connection' object has no attribute 'select_db'
You could always execute a “use «db_name»” MySQL command.
--
https://mail.python.org/mailman/listinfo/python-list
yet my new machine is supporting it from
the MySQLdb library. Are the docs lagging? Can I download
the 'better' MySQLdb package and install it on the 8.04
machine?
Thanks,
Tobiah
--
https://mail.python.org/mailman/listinfo/python-list
On Friday, June 24, 2016 at 5:48:27 AM UTC+12, Joaquin Alzola wrote:
> This email is confidential and may be subject to privilege. If you are not
> the intended recipient, please do not copy or disclose its content but
> contact the sender immediately upon receipt.
Sender, please consider yoursel
On 24 June 2016 at 09:46, Arshpreet Singh wrote:
> On Thursday, 23 June 2016 23:18:27 UTC+5:30, Joaquin Alzola wrote:
>> >ImportError: No module named 'ConfigParser'
>> It is telling you the error
>> This email is confidential and may be subject to privilege. If you are not
>> the intended
On Thursday, 23 June 2016 23:18:27 UTC+5:30, Joaquin Alzola wrote:
> >ImportError: No module named 'ConfigParser'
> It is telling you the error
> This email is confidential and may be subject to privilege. If you are not
> the intended recipient, please do not copy or disclose its content bu
>ImportError: No module named 'ConfigParser'
It is telling you the error
This email is confidential and may be subject to privilege. If you are not the
intended recipient, please do not copy or disclose its content but contact the
sender immediately upon receipt.
--
https://mail.python.org/
Try this
https://pypi.python.org/pypi/mysqlclient
On Thu, Jun 23, 2016 at 9:11 PM, Arshpreet Singh wrote:
> I am trying to run django project in virtual environment. it needs mysql
> database library but when I try to install that it returns the error that
> configparser is not installed but I
I am trying to run django project in virtual environment. it needs mysql
database library but when I try to install that it returns the error that
configparser is not installed but I have installed configparser still the error
remains same, is this ubuntu bug?
(env) ubuntu@ip-:~/clearapp$ pip
Another option is PyMySQL [1]. It's developed in the open at GitHub [2].
It's pure Python, compatible with both Python 2 and Python 3. It's DB-API 2
compliant. It also implements some non-standard bits that are present in
MySQLdb, in order to be compatible with legacy code,
On Saturday, February 8, 2014 1:42:30 PM UTC+2, Chris Angelico wrote:
> On Sat, Feb 8, 2014 at 10:32 PM, Asaf Las wrote:
>
> > Hi Chris
> > The doc says
> > https://pypi.python.org/pypi/mysql-connector-python/1.1.5
> > MySQL driver written in Python which does not depend on MySQL C
> > client lib
On Sat, Feb 8, 2014 at 10:32 PM, Asaf Las wrote:
> Hi Chris
> The doc says
> https://pypi.python.org/pypi/mysql-connector-python/1.1.5
>
> MySQL driver written in Python which does not depend on MySQL C
> client libraries and implements the DB API v2.0 specification (PEP-249).
Ah. And that links
On Saturday, February 8, 2014 1:25:15 PM UTC+2, Chris Angelico wrote:
> On Sat, Feb 8, 2014 at 10:09 PM, Asaf Las wrote:
>
> > I used this one from Oracle and it was OK for simple test case and
> > supports from 2.6 till 3.3:
> > http://dev.mysql.com/doc/connector-python/en/index.html
> > https:/
On Sat, Feb 8, 2014 at 10:09 PM, Asaf Las wrote:
> I used this one from Oracle and it was OK for simple test case and
> supports from 2.6 till 3.3:
> http://dev.mysql.com/doc/connector-python/en/index.html
> https://pypi.python.org/pypi/mysql-connector-python/1.1.5
>
>
> yet there is page to bunch
On Saturday, February 8, 2014 10:52:36 AM UTC+2, Sam wrote:
> I am writing my first python script to access MySQL database.
> With reference to
> http://mysql-python.sourceforge.net/MySQLdb.html#connection-objects
> Why is it advisable to use _mysql and not MySQLdb module directly?
On Sat, Feb 8, 2014 at 7:52 PM, Sam wrote:
> I am writing my first python script to access MySQL database. With reference
> to http://mysql-python.sourceforge.net/MySQLdb.html#connection-objects
>
> Why is it advisable to use _mysql and not MySQLdb module directly?
Other way
I am writing my first python script to access MySQL database. With reference to
http://mysql-python.sourceforge.net/MySQLdb.html#connection-objects
Why is it advisable to use _mysql and not MySQLdb module directly?
--
https://mail.python.org/mailman/listinfo/python-list
On 05/10/2013 09:39, F.R. wrote:
On 10/05/2013 12:55 AM, Dennis Lee Bieber wrote:
On Fri, 04 Oct 2013 09:38:41 +0200, "F.R."
declaimed the following:
MySQLdb, as with all DB-API compliant adapters, does NOT do
"auto-commit" -- you MUST execute a con.commit() after
On 10/05/2013 12:55 AM, Dennis Lee Bieber wrote:
On Fri, 04 Oct 2013 09:38:41 +0200, "F.R."
declaimed the following:
MySQLdb, as with all DB-API compliant adapters, does NOT do
"auto-commit" -- you MUST execute a con.commit() after any query (sequence)
that modif
On 10/04/2013 12:11 PM, Chris Angelico wrote:
On Fri, Oct 4, 2013 at 8:05 PM, F.R. wrote:
Off list? MySQL is. MySQLdb is not. Before I know which of the two is
the culprit, I don't know whether I'm off list or not and take the risk,
prepared to beg pardon if I am.
Just to cl
On Fri, Oct 4, 2013 at 8:05 PM, F.R. wrote:
> Off list? MySQL is. MySQLdb is not. Before I know which of the two is
> the culprit, I don't know whether I'm off list or not and take the risk,
> prepared to beg pardon if I am.
>
Just to clarify: Off-topic means discu
On 10/04/2013 09:38 AM, F.R. wrote:
Hi,
As of late clipboard pasting into a terminal sometimes fails (a
known bug, apparently), I use MySQLdb to access MySQL tables. In
general this works just fine. But now I fail filling a new table. The
table exists. "mysql>EXPLAIN new_table;&q
On Fri, 04 Oct 2013 09:38:41 +0200, F.R. wrote:
> Hi,
> As of late clipboard pasting into a terminal sometimes fails (a
> known bug, apparently), I use MySQLdb to access MySQL tables.
[...]
You appear to have posted to the wrong list. This is a Python list, not
MySQL. Nothin
Hi,
As of late clipboard pasting into a terminal sometimes fails (a
known bug, apparently), I use MySQLdb to access MySQL tables. In general
this works just fine. But now I fail filling a new table. The table
exists. "mysql>EXPLAIN new_table;" explains and "root@blackbox
Hello,
On Tue, Sep 17, 2013 at 07:22:50PM +1000, Ben Finney wrote:
> Ervin Hegedüs writes:
>
> > Hello,
> >
> > On Tue, Sep 17, 2013 at 05:35:30PM +1000, Ben Finney wrote:
> > > for row in cur.fetchall():
> >
> > and what if in body of iteration there is another fetchall()? :)
>
> Yes, what
Ervin Hegedüs writes:
> Hello,
>
> On Tue, Sep 17, 2013 at 05:35:30PM +1000, Ben Finney wrote:
> > for row in cur.fetchall():
>
> and what if in body of iteration there is another fetchall()? :)
Yes, what if? Each call to ‘fetchall’ returns a sequence of rows. I
don't see your point.
--
\
Hello,
On Tue, Sep 17, 2013 at 05:35:30PM +1000, Ben Finney wrote:
> Venkat Addala writes:
>
> > rows = cur.fetchall()
> > for row in rows:
>
> You never use ‘rows’ for anything else, so you may as well forget it and
> just iterate directly over the return value::
>
> for row in cur.fe
it back to mysql database. i was trying somthing, here is
> my code, can you please provide me solution for this..
>
> #!/usr/bin/python
> import MySQLdb as mdb
>
> con = mdb.connect('localhost', 'root', 'pass@123', 'workbench');
a tip: you
hey Ben,
Thanks for your solution, i am done with this before, now i'm having
problem after deleting \n and extra spaces, i want to update it back it
again to mysql db.
For this i tried using regular expression check this code;
# -*- coding: utf-8 -*-
import re
import MySQLdb
pa
xpecting it to be
different?
> #!/usr/bin/python
> import MySQLdb as mdb
>
> con = mdb.connect('localhost', 'root', 'pass@123', 'workbench');
There's no need to end Python statements with a semicolon; it's only
confusing to do it.
&
this..
#!/usr/bin/python
import MySQLdb as mdb
con = mdb.connect('localhost', 'root', 'pass@123', 'workbench');
with con:
cur = con.cursor()
cur.execute("SELECT descrip FROM table LIMIT 1")
rows = cur.fetchall()
for row in rows:
row
On Sat, 31/8/13, Chris Angelico wrote:
Subject: Re: MySQLdb Problem
To: python-list@python.org
Date: Saturday, 31 August, 2013, 4:18 PM
> Do your Python and your MySQLdb match? I haven't confirmed,
> but I'm
> pretty sure you&
On Sun, Sep 1, 2013 at 8:17 AM, John Smith wrote:
>
>
> On Sat, 31/8/13, Chris Angelico wrote:
>
> Subject: Re: MySQLdb Problem
> To: python-list@python.org
> Date: Saturday, 31 August, 2013, 4:18 PM
>
>> Do your Py
On Sat, Aug 31, 2013 at 6:38 PM, John Smith
wrote:
> Hi;
> Since there is no list for MySQLdb, I'm hoping you can help me. I have
> installed, de-installed and reinstalled this s/w and MySQL itself on my Win8
> box. However, when I go to use it from a script, I get the follow
Hi;
Since there is no list for MySQLdb, I'm hoping you can help me. I have
installed, de-installed and reinstalled this s/w and MySQL itself on my Win8
box. However, when I go to use it from a script, I get the following error:
"C:\Python27\lib\site-packages\MySQLdb\__init.py__&qu
In article ,
Roy Smith wrote:
> My unicode-fu is a bit weak. Are we looking at a Python problem, a
> MySQLdb problem, or a problem with the underlying MySQL server? We've
> certainly inserted utf-8 data before without any problems. It's
> possible this is the fir
quot;, line 21, in
cursor.execute("insert into songza_temp (s) values (%s)", [baloon])
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174,
in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py
Τη Παρασκευή, 29 Μαρτίου 2013 7:39:20 μ.μ. UTC+2, ο χρήστης Alan Meyer έγραψε:
> On 03/29/2013 01:32 PM, Alan Meyer wrote:
>
>
>
> > However, MySQLdb is a well established module and what you're asking it
>
> > to do is very simple and very standard.
>
On 03/29/2013 01:32 PM, Alan Meyer wrote:
However, MySQLdb is a well established module and what you're asking it
to do is very simple and very standard.
Oh, sorry, I see that you already said that mysqldb won't work with
python 3. My comments in the last message are irrelevan
On 03/29/2013 03:40 AM, Νίκος Γκρ33κ wrote:
...
So, just to make sure that MySQLdb isnt causeing the probkem can
someone, perhaps you that is familiar with linxu conenct to my jailed
shell account and install manually the 'pymysql' module because i
dont know how to do it and i cannot
> > cur.execute( '''SELECT hits FROM counters WHERE url = ?''', (page,) )
>
> > data = cur.fetchone()
>
> >
>
> > because as you can see by visiting my webpage at http://superhost.gr it
> > produces an error and i dont have
see by visiting my webpage at http://superhost.gr it
produces an error and i dont have aclue why.
Please help. i'am using MySQLdb
Nikos,
When I try to connect to that web page I see the following error message:
"ImportError: No module named pymysql "
If that's what you&#
;Please if you cna pout it even simper for me, thank you.
>
>
>
> For instance:
>
>
>
> >>> import MySQLdb
>
> >>> MySQLdb.paramstyle
>
> 'format'
>
>
ni...@superhost.gr [~]# /usr/bin/python3
Python 3.2.3 (default, May 23 2012, 18:
Νίκος Γκρ33κ :
>> What paramstyle are you using?
>
>Yes it is Chris, but i'am not sure what exactly are you asking me.
>Please if you cna pout it even simper for me, thank you.
For instance:
>>> import MySQLdb
>>> MySQLdb.paramstyle
'format
Can someone else esxcept Chris help me please?
I'm strugling with this and cannot see whats wrong.
--
http://mail.python.org/mailman/listinfo/python-list
Τη Πέμπτη, 28 Μαρτίου 2013 6:35:14 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε:
> No. I said to print out the paramstyle attribute. If it's that late
>
> and you haven't slept, get some sleep, then reread this thread. You
>
> may be able to respond more intelligently.
What is a paramstyle attri
On Thu, Mar 28, 2013 at 3:30 PM, Νίκος Γκρ33κ wrote:
> Τη Πέμπτη, 28 Μαρτίου 2013 6:26:48 π.μ. UTC+2, ο χρήστης Chris Angelico
> έγραψε:
>> On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ wrote:
>>
>> > Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico
>> > έγραψε:
>>
>> >
>
Τη Πέμπτη, 28 Μαρτίου 2013 6:26:48 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε:
> On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ wrote:
>
> > Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico
> > έγραψε:
>
> >
>
> >> As it says in that document, paramstyle is a top-level m
On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ wrote:
> Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico
> έγραψε:
>
>> As it says in that document, paramstyle is a top-level module
>> attribute. Try printing it out. See what it says. Then match your code
>
> sql = '''SELECT
Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε:
> As it says in that document, paramstyle is a top-level module
> attribute. Try printing it out. See what it says. Then match your code
sql = '''SELECT hits FROM counters WHERE url = %s''' % page
print( sql )
cur.ex
On Thu, Mar 28, 2013 at 3:08 PM, Νίκος Γκρ33κ wrote:
> If you mean if iam using '?' or this '%s' the latter used to work flawlessly
> with python 2.6 but it does not in pythin 3.2.3
Print out the value of that attribute.
ChrisA
--
http://mail.python.org/mailman/listinfo/python-list
If you mean if iam using '?' or this '%s' the latter used to work flawlessly
with python 2.6 but it does not in pythin 3.2.3
both this command fail in python 3.x
cur.execute( '''SELECT hits FROM counters WHERE url = ?''', (page,) )
cur.execute( '''SELECT hits FROM counters WHERE url = %s''', (
On Thu, Mar 28, 2013 at 3:03 PM, Νίκος Γκρ33κ wrote:
> Τη Πέμπτη, 28 Μαρτίου 2013 6:00:17 π.μ. UTC+2, ο χρήστης Chris Angelico
> έγραψε:
>
>> What paramstyle are you using?
>
> Yes it is Chris, but i'am not sure what exactly are you asking me.
> Please if you cna pout it even simper for me, thank
Τη Πέμπτη, 28 Μαρτίου 2013 6:00:17 π.μ. UTC+2, ο χρήστης Chris Angelico έγραψε:
> What paramstyle are you using?
Yes it is Chris, but i'am not sure what exactly are you asking me.
Please if you cna pout it even simper for me, thank you.
--
http://mail.python.org/mailman/listinfo/python-list
.fetchone()
>
> because as you can see by visiting my webpage at http://superhost.gr it
> produces an error and i dont have aclue why.
>
> Please help. i'am using MySQLdb
Is this the docs for the module you're using?
http://mysql-python.sourceforge.net/MySQLdb.html
produces an error and i dont have aclue why.
Please help. i'am using MySQLdb
--
http://mail.python.org/mailman/listinfo/python-list
Hi, I'm being forced to use "import MySQLdb" to access a serverand
am not getting all my data back.
I'm trying to send multiple queries all at once (for time reasons) and
then extract the rows in bulk.
The queries have different number of columns; For
On Saturday, February 2, 2013 12:01:40 PM UTC+2, Armin Karner wrote:
> Dear Sir or Madam,
>
>
>
>
>
>
>
> I am curious if there is an update of MySQLdb for python versions 3.3 or
> higher. Because I really need this for a diploma thesis.
> I've tried
Hi Armin,
Armin Karner wrote:
> I am curious if there is an update of MySQLdb for python versions 3.3 or
> higher. Because I really need this for a diploma thesis.
What feature do you need which is not provided?
> I really hope you have a solution for me, because it is quite u
Michael Torrie, 02.02.2013 19:29:
> On 02/02/2013 03:19 AM, Luuk wrote:
>> On 02-02-2013 11:01, Armin Karner wrote:
>>> MySQLdb for python versions 3.3 or higher
>>
>> http://lmgtfy.com/?q=MySQLdb+for+python+versions+3.3+or+higher
>
> Embarrassingly, most of th
On 02/02/2013 03:19 AM, Luuk wrote:
> On 02-02-2013 11:01, Armin Karner wrote:
>> MySQLdb for python versions 3.3 or higher
>
> http://lmgtfy.com/?q=MySQLdb+for+python+versions+3.3+or+higher
Embarrassingly, most of the links on the google search results page are
about people
On 02-02-2013 11:01, Armin Karner wrote:
MySQLdb for python versions 3.3 or higher
http://lmgtfy.com/?q=MySQLdb+for+python+versions+3.3+or+higher
--
http://mail.python.org/mailman/listinfo/python-list
Dear Sir or Madam,
I am curious if there is an update of MySQLdb for python versions 3.3 or
higher. Because I really need this for a diploma thesis.
I've tried several of them, including various 2.x versions, but it didn't work.
The system I use is a Microsoft Windows 7 64 bit.
On Sat, Dec 15, 2012 at 8:49 AM, Dennis Lee Bieber
wrote:
> On Fri, 14 Dec 2012 15:16:54 +1100, Chris Angelico
> declaimed the following in gmane.comp.python.general:
>
>> Yeah, it's one of the things that tripped me up when I did a
>> MySQL->PostgreSQL conversion earlier this year. The code was
On 14/12/2012 06:16, Chris Angelico wrote:
Yeah, it's one of the things that tripped me up when I did a
MySQL->PostgreSQL conversion earlier this year. The code was assuming
case insensitivity, and began failing on PG. Fortunately the simple
change of LIKE to ILIKE solved that.
I'd MUCH rather
On Fri, Dec 14, 2012 at 2:35 PM, Cameron Simpson wrote:
> On 13Dec2012 18:39, Dennis Lee Bieber wrote:
> | On Thu, 13 Dec 2012 18:00:48 +1100, Cameron Simpson
> | declaimed the following in gmane.comp.python.general:
> | > On 12Dec2012 02:03, Dennis Lee Bieber wrote:
> | > | According to the
On 13Dec2012 18:39, Dennis Lee Bieber wrote:
| On Thu, 13 Dec 2012 18:00:48 +1100, Cameron Simpson
| declaimed the following in gmane.comp.python.general:
| > On 12Dec2012 02:03, Dennis Lee Bieber wrote:
| > | According to the old "MySQL Language Reference"
| > | """
| > | By default, string
On 12Dec2012 02:03, Dennis Lee Bieber wrote:
| According to the old "MySQL Language Reference"
| """
| By default, string comparisons are not case sensitive and will use the
| current character set (ISO-8859-1 Latin1 by default, which also works
| excellently for English).
| """
I'm flabbe
On 11Dec2012 22:01, Anatoli Hristov wrote:
| Excuse me for the noob question, but is there a way to compare a field
| in mysql as lower() somehow?
|
| I have a situation where I compare the SKU in my DB and there are some
| SKU that are with lowercase and some with uppercase, how can I solve
| th
> I think this will work:
>
> sql = 'UPDATE product SET price=%s WHERE LOWER(sku)=%s'
> cursor.execute(sql, (price, sku.lower())
>
Thanks John, this works, I was about to make double check with lower
and upper, but this saves me :)
Thanks a lot.
--
http://mail.python.org/mailman/listinfo/
In Anatoli Hristov
writes:
> I have a situation where I compare the SKU in my DB and there are some
> SKU that are with lowercase and some with uppercase, how can I solve
> this in your opinion ?
> def Update_SQL(price, sku):
> db = MySQLdb.connect("localhost","getit","opencart",
> use_un
Hello guys,
Excuse me for the noob question, but is there a way to compare a field
in mysql as lower() somehow?
I have a situation where I compare the SKU in my DB and there are some
SKU that are with lowercase and some with uppercase, how can I solve
this in your opinion ?
def Update_SQL(price,
> SSCCE starts with "Short". The HTML you unloaded into that email
> hardly qualifies.
>
> When you're trying to figure out a problem that appears to happen only
> when you have X and not when you have Y, see what the smallest example
> data for X and Y are that continue to exhibit the difference.
On Tue, Dec 11, 2012 at 11:46 AM, Anatoli Hristov wrote:
>> Brilliant, I think your problem is in line 97 of the code that you *HAVEN'T
>> QUOTED*. Please go here, read and inwardly digest before you say anything
>> else http://www.sscce.org/
>
> :) I thought it was clear. the "spec" is the descr
>
>First thing -- DON'T put quotes around the %s place-holders... The
> whole purpose of using the parameterized .execute() is to let the
> database adapter properly escape the parameters before putting them into
> the SQL (since MySQL didn't have prepared statements before v5, it was
> produci
> You're using a parametrised query (which is good :-)), but you've included
> quotes around the placeholders. There's no need to do that. They'll be
> quoted automatically when necessary:
>
> sql = "INSERT INTO product_description (product_id, language_id, name,
> description) VALUES (%s,%s,%s,%s)
On 2012-12-11 00:04, Anatoli Hristov wrote:
Hi all,
I'm facing an issue inserting an html code into the DB, it comes out
with a syntax error but I face it only when I have html code. Could
help me escape the error somehow ?
Here is my code
def InsertSpecsDB(product_id, spec, lang, name):
On 11/12/2012 00:29, Anatoli Hristov wrote:
As much use as a chocolate teapot, all you've given is a function/method
definition. No indication of your OS, Python version, calling code, what
you expect to happen, what actually happened, apart from that your request
for assistance is perfect. Usu
On Tue, Dec 11, 2012 at 1:29 AM, Anatoli Hristov wrote:
>> As much use as a chocolate teapot, all you've given is a function/method
>> definition. No indication of your OS, Python version, calling code, what
>> you expect to happen, what actually happened, apart from that your request
>> for assi
> As much use as a chocolate teapot, all you've given is a function/method
> definition. No indication of your OS, Python version, calling code, what
> you expect to happen, what actually happened, apart from that your request
> for assistance is perfect. Usually I'd be able to help but sadly my
On 11/12/2012 00:04, Anatoli Hristov wrote:
Hi all,
I'm facing an issue inserting an html code into the DB, it comes out
with a syntax error but I face it only when I have html code. Could
help me escape the error somehow ?
Here is my code
def InsertSpecsDB(product_id, spec, lang, name):
Hi all,
I'm facing an issue inserting an html code into the DB, it comes out
with a syntax error but I face it only when I have html code. Could
help me escape the error somehow ?
Here is my code
def InsertSpecsDB(product_id, spec, lang, name):
db = MySQLdb.connect("localhost","getit","openc
* Tim Johnson [120609 07:30]:
> >
> > http://mysql-python.hg.sourceforge.net/hgweb/mysql-python/MySQLdb-2.0/file/566baac88764/src
> >
> > It definitely is. The C extension part is the '_mysql' module, here it
> > is /usr/lib64/python2.7/site-packages/_mys
* Corey Richardson [120608 11:39]:
> On Fri, 8 Jun 2012 09:55:23 -0800
> Tim Johnson wrote:
>
> > See the thread titled "Python libraries portable?" you will note
> > that Corey Richardson makes the statement that MySQLdb is a C
> > extension. I acce
On Fri, 8 Jun 2012 09:55:23 -0800
Tim Johnson wrote:
> See the thread titled "Python libraries portable?" you will note
> that Corey Richardson makes the statement that MySQLdb is a C
> extension. I accepted that statement, but upon looking at the
> directories
* Prasad, Ramit [120608 09:38]:
> > Is it possible to install MySQLdb via FTP?
> >
> > 1)I have a hostmonster account with SSH. I have been able to log in
> > and install MySQLdb from the shell. Works fine.
> >
> > 2)Now I have a client who wants to have a
> Is it possible to install MySQLdb via FTP?
>
> 1)I have a hostmonster account with SSH. I have been able to log in
> and install MySQLdb from the shell. Works fine.
>
> 2)Now I have a client who wants to have a hostmonster account and we
> will need MySQLdb. I *will not*
Is it possible to install MySQLdb via FTP?
1)I have a hostmonster account with SSH. I have been able to log in
and install MySQLdb from the shell. Works fine.
2)Now I have a client who wants to have a hostmonster account and we
will need MySQLdb. I *will not* have SSH access since (as I
On 2/5/2012 2:46 PM, Chris Rebert wrote:
On Sun, Feb 5, 2012 at 2:41 PM, Emeka wrote:
Hello All,
I noticed that MySQLdb not allowing hyphen may be way to prevent injection
attack.
I have something like below:
"insert into reviews(message, title)values('%s', '%s')&qu
Dennis , Chris
Thanks so much!
On Mon, Feb 6, 2012 at 1:23 AM, Dennis Lee Bieber wrote:
> On Mon, 6 Feb 2012 00:41:24 +0200, Emeka wrote:
>
> >Hello All,
> >
> >I noticed that MySQLdb not allowing hyphen may be way to prevent injection
> >attack.
>
&
On Sun, Feb 5, 2012 at 2:41 PM, Emeka wrote:
>
> Hello All,
>
> I noticed that MySQLdb not allowing hyphen may be way to prevent injection
> attack.
> I have something like below:
>
> "insert into reviews(message, title)values('%s', '%s')"
1 - 100 of 766 matches
Mail list logo
