RE: Connector/Python, MySQL Workbench Issue

Check to see if the path was updated. Footnote: Ultrasound Technician Asks Pregnant Woman If She'd Like To Know Baby's Name -Original Message- From: Python-list On Behalf Of Scott Sorgent Sent: Monday, February 25, 2019 8:16 PM To: python-list@python.org Subject: Connec

Re: Connector/Python, MySQL Workbench Issue

il *Sent:* Monday, February 25, 2019 5:50 PM *To:* 'Python' *Subject:* Re: Connector/Python, MySQL Workbench Issue Scott, On 26/02/19 2:15 PM, Scott Sorgent wrote: I was trying to install MySQL Workbench and it asked me to install the Connector/Python 3.7.  I installed Python 3.7.2, restar

Re: Connector/Python, MySQL Workbench Issue

Scott, On 26/02/19 2:15 PM, Scott Sorgent wrote: I was trying to install MySQL Workbench and it asked me to install the Connector/Python 3.7. I installed Python 3.7.2, restarted the computer and tried to install MySQL workbench again and it told me again that I needed to install Connector/P

Connector/Python, MySQL Workbench Issue

I was trying to install MySQL Workbench and it asked me to install the Connector/Python 3.7. I installed Python 3.7.2, restarted the computer and tried to install MySQL workbench again and it told me again that I needed to install Connector/Python 3.7. I found the download for MySQL Connecto

Re: Python MySQL Guide

g for. Might you consider > breaking it up into a number of smaller pages and giving an index as the > main page? > > On Aug 9, 2018 5:18 PM, wrote: > >> Refer this complete guide on working with Python and MySQL >> >> https://pynative.com/python-mysql-tutorial/

Re: Python MySQL Guide

lete guide on working with Python and MySQL > > https://pynative.com/python-mysql-tutorial/ > -- > https://mail.python.org/mailman/listinfo/python-list > -- https://mail.python.org/mailman/listinfo/python-list

Python MySQL Guide

Refer this complete guide on working with Python and MySQL https://pynative.com/python-mysql-tutorial/ -- https://mail.python.org/mailman/listinfo/python-list

Re: Python, mySQL and password

Hello Peter, On Mon, Dec 16, 2013 at 12:38:33PM +0100, Peter Otten wrote: > Ervin Hegedüs wrote: > > > dsn['passwd'] = raw_input("Enter password for %s: " % (dsn['user'])) > > [...] > > but at this way the password what you type will showing! > > To avoid that use getpass.getpass() instead of

Re: Python, mySQL and password

Ervin Hegedüs wrote: > Hello, > > On Mon, Dec 16, 2013 at 02:55:29AM -0800, Igor Korot wrote: >> Hi, ALL, >> Is there a way to make python script that connects to mySQL DB ask for >> a password on the: >> >> conn = mdb.connect(host, user) >> >> line. >> The host variable is "localhost" and the

Re: Python, mySQL and password

Hello, On Mon, Dec 16, 2013 at 02:55:29AM -0800, Igor Korot wrote: > Hi, ALL, > Is there a way to make python script that connects to mySQL DB ask for > a password on the: > > conn = mdb.connect(host, user) > > line. > The host variable is "localhost" and the user variable is "root" (for > devel

Python, mySQL and password

Hi, ALL, Is there a way to make python script that connects to mySQL DB ask for a password on the: conn = mdb.connect(host, user) line. The host variable is "localhost" and the user variable is "root" (for developmental purposes). Thank you. -- https://mail.python.org/mailman/listinfo/python-li

Re: Python - MySQL fetching values

On Thu, May 6, 2010 at 2:42 PM, Chris Rebert wrote: > On Thu, May 6, 2010 at 1:47 AM, Kurian Thayil > wrote: > > > the expected output is 05:35:05. > > > > Now, here is code snippet, > > > > cursor1=getconnect1.cursor() > > getrows=cursor1.execute("""SELECT > > T

Re: Python - MySQL fetching values

On Thu, May 6, 2010 at 1:47 AM, Kurian Thayil wrote: > the expected output is 05:35:05. > > Now, here is code snippet, > >     cursor1=getconnect1.cursor() >     getrows=cursor1.execute("""SELECT > TIME(DATE_ADD(info_last_calltime, INTERVAL %s MINUTE)) FROM rem_call_info >

Python - MySQL fetching values

Hi All, I am pretty new to python, and I have an issue with fetching values in python using MySQLdb module. The query executed is *SELECT TIME(DATE_ADD(info_last_calltime, INTERVAL %s MINUTE)) FROM rem_call_info WHERE info_ctrlid=%s""", (retryinterval,controlid1,)* where retryinterval=30 and cont

Python MySQL: clean multiple foreign keys table

Hi Everybody, I am working with Python MySQL, and need to clean a table in my database that has 13328 rows. I can not make a simple drop table, because this table is child and also father of other child foreign-keys linked on it. If I try drop table, the system forbidden me. The table is defined

Re: Python/MySQL Frustration

Dennis Lee Bieber wrote: On Sun, 20 Sep 2009 14:25:53 -0400, Victor Subervi declaimed the following in gmane.comp.python.general: Hi; I have the following code: while i < num: cat = 'cat' + str(i) cat = form.getfirst(cat, '') item = 'item' + str(i) item = form.get

Re: Python/MySQL Frustration

Yeah, that was the problem..."num" was a string ;) Just caught it myself, too. Thanks, V On Sun, Sep 20, 2009 at 2:37 PM, Philip Semanchuk wrote: > > On Sep 20, 2009, at 2:25 PM, Victor Subervi wrote: > > Hi; >> I have the following code: >> >>while i < num: >> cat = 'cat' + str(i) >>

Re: Python/MySQL Frustration

On Sep 20, 2009, at 2:25 PM, Victor Subervi wrote: Hi; I have the following code: while i < num: cat = 'cat' + str(i) cat = form.getfirst(cat, '') item = 'item' + str(i) item = form.getfirst(item, '') descr = 'descr' + str(i) descr = form.getfirst(descr, '')

Python/MySQL Frustration

Hi; I have the following code: while i < num: cat = 'cat' + str(i) cat = form.getfirst(cat, '') item = 'item' + str(i) item = form.getfirst(item, '') descr = 'descr' + str(i) descr = form.getfirst(descr, '') uom = 'uom' + str(i) uom = form.getfi

python mysql hash generator

sorry for my english, but i'm speak spanish) Hi list.. this is my first post... and obviously if for help.. I try to implement the password function of mysql in a python script. I read that the password function of mysql was implemented with a double sha1() I python i try this: example1: if __n

Re: Little direction please Python MySQL

On Nov 17, 5:52 am, Tim Chase <[EMAIL PROTECTED]> wrote: > >> Files are fixed format no field delimiters, fields are position and > >> length records are terminated by newline. > > > Assuming no COMPUTATIONAL fields, it should be easy enough to split each > > line up into fixed-length pieces, e.g.

Re: Little direction please Python MySQL

On Nov 17, 3:24 am, Lawrence D'Oliveiro <[EMAIL PROTECTED] central.gen.new_zealand> wrote: > len wrote: > > Files are fixed format no field delimiters, fields are position and > > length records are terminated by newline. > > Assuming no COMPUTATIONAL fields, it should be easy enough to split each

Re: Little direction please Python MySQL

On Nov 17, 3:24 am, Lawrence D'Oliveiro <[EMAIL PROTECTED] central.gen.new_zealand> wrote: > len wrote: > > Files are fixed format no field delimiters, fields are position and > > length records are terminated by newline. > > Assuming no COMPUTATIONAL fields, it should be easy enough to split each

Re: Little direction please Python MySQL

Files are fixed format no field delimiters, fields are position and length records are terminated by newline. Assuming no COMPUTATIONAL fields, it should be easy enough to split each line up into fixed-length pieces, e.g. assuming a simple example 01 Sample-Record. 02 Field-1 pic XXX

Re: Little direction please Python MySQL

len wrote: > Files are fixed format no field delimiters, fields are position and > length records are terminated by newline. Assuming no COMPUTATIONAL fields, it should be easy enough to split each line up into fixed-length pieces, e.g. assuming a simple example 01 Sample-Record. 02 F

Re: Little direction please Python MySQL

On Nov 15, 4:41 pm, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote: > On Sat, 15 Nov 2008 11:41:17 -0800, Ethan Furman <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: > > > > > len wrote: >         > > > > Files are fixed format no field delimiters, fields are position and > > > le

Re: Little direction please Python MySQL

Bruno Desthuilliers wrote: len a écrit : Hi all; I am looking for a little direction in moving from novice python MySQL to real world processing. I can connect to MySQL databases and have performed most of the various select, create, update, insert, etc given the examples in the various books

Re: Little direction please Python MySQL

len wrote: On Nov 13, 7:32 pm, Ethan Furman <[EMAIL PROTECTED]> wrote: len wrote: Hi all; [snip] Here is my problem. I need to start doing this in the really world at my company converting some older cobol system and data to python programs and MySQL. I have gotten past packed decimal

Re: Little direction please Python MySQL

On Nov 14, 4:19 am, Bruno Desthuilliers wrote: > len a écrit : > > > > > > > Hi all; > > > I am looking for a little direction in moving from novice python MySQL > > to real world processing. > > > I can connect to MySQL databases and have performe

Re: Little direction please Python MySQL

On Nov 13, 7:32 pm, Ethan Furman <[EMAIL PROTECTED]> wrote: > len wrote: > > Hi all; > > [snip] > > > Here is my problem.  I need to start doing this in the really world at > > my company converting some older cobol system and data to python > > programs and MySQL.  I have gotten past packed decima

Re: Little direction please Python MySQL

len a écrit : Hi all; I am looking for a little direction in moving from novice python MySQL to real world processing. I can connect to MySQL databases and have performed most of the various select, create, update, insert, etc given the examples in the various books and internet tutorials not

Re: Little direction please Python MySQL

len wrote: Hi all; [snip] Here is my problem. I need to start doing this in the really world at my company converting some older cobol system and data to python programs and MySQL. I have gotten past packed decimal fields and various other little tidbits. My problem is the data files aren'

Re: Little direction please Python MySQL

len wrote: > Hi all; > > I am looking for a little direction in moving from novice python MySQL > to real world processing. > > I can connect to MySQL databases and have performed most of the > various select, create, update, insert, etc given the examples in the > va

Little direction please Python MySQL

Hi all; I am looking for a little direction in moving from novice python MySQL to real world processing. I can connect to MySQL databases and have performed most of the various select, create, update, insert, etc given the examples in the various books and internet tutorials not to many problems

Re: Looking for a pure python Mysql module

On Tue, Oct 28, 2008 at 9:41 AM, Carl <[EMAIL PROTECTED]> wrote: > Does anyone know of a package that can connect and query a mysql server that > is platform independent and does not need to compile any extra c modules (IE > a pure python module)? There was a recent discussion on this mailing list

Looking for a pure python Mysql module

Does anyone know of a package that can connect and query a mysql server that is platform independent and does not need to compile any extra c modules (IE a pure python module)? -- http://mail.python.org/mailman/listinfo/python-list

Re: Install Python MySQL db module?

search, search, it is a recurrent question for example http://groups.google.be/group/comp.lang.python/browse_thread/thread/7bef767753fe40f1/a3fd7c2dd7a50bef?hl=fr&lnk=gst&q=mysqldb+mac#a3fd7c2dd7a50bef -- http://mail.python.org/mailman/listinfo/python-list

Re: Install Python MySQL db module?

On May 14, 10:58 am, Rick Dooling <[EMAIL PROTECTED]> wrote: > On May 13, 7:29 pm, Con <[EMAIL PROTECTED]> wrote: > > > Hi, how does properly install the Python MySQL db module for Mac OS > > X?  I was only able to locate the Win32 modules. > > > Thanks in ad

Re: Install Python MySQL db module?

On May 13, 7:29 pm, Con <[EMAIL PROTECTED]> wrote: > Hi, how does properly install the Python MySQL db module for Mac OS > X? I was only able to locate the Win32 modules. > > Thanks in advance, > > -Conrad I tried this a couple of weeks ago using macports and had pro

Re: Install Python MySQL db module?

On May 13, 7:29 pm, Con <[EMAIL PROTECTED]> wrote: > Hi, how does properly install the Python MySQL db module for Mac OS > X?  I was only able to locate the Win32 modules. > > Thanks in advance, > > -Conrad I think the easiest way to would be to use macports. -- http:/

Install Python MySQL db module?

Hi, how does properly install the Python MySQL db module for Mac OS X? I was only able to locate the Win32 modules. Thanks in advance, -Conrad -- http://mail.python.org/mailman/listinfo/python-list

Re: Looking for Conferences/Events on Django, Python, MySQL, etc in Europe 2008?

On Apr 8, 12:36 pm, "Simon Brunning" <[EMAIL PROTECTED]> wrote: > On Tue, Apr 8, 2008 at 10:10 AM, Simone Brunozzi > > <[EMAIL PROTECTED]> wrote: > > Greetings! > > > I'm looking for conferences or events about Python, Django, Dabatases, > > Mysql, > > PHP, Ruby in Europe (or nearby locations li

Re: Looking for Conferences/Events on Django, Python, MySQL, etc in Europe 2008?

On Tue, Apr 8, 2008 at 10:10 AM, Simone Brunozzi <[EMAIL PROTECTED]> wrote: > Greetings! > > I'm looking for conferences or events about Python, Django, Dabatases, > Mysql, > PHP, Ruby in Europe (or nearby locations like north africa and middle > east) in 2008. > Do you have any suggestions?

Re: Looking for Conferences/Events on Django, Python, MySQL, etc in Europe 2008?

> Greetings! > > I'm looking for conferences or events about Python, Django, Dabatases, > Mysql, > PHP, Ruby in Europe (or nearby locations like north africa and middle > east) in 2008. > Do you have any suggestions? > > Thanks a lot! Hello, Every year starting from 2007 in April there's a RuPy

Looking for Conferences/Events on Django, Python, MySQL, etc in Europe 2008?

Greetings! I'm looking for conferences or events about Python, Django, Dabatases, Mysql, PHP, Ruby in Europe (or nearby locations like north africa and middle east) in 2008. Do you have any suggestions? Thanks a lot! -- http://mail.python.org/mailman/listinfo/python-list

Python, Mysql, insert NULL

Hello there, I was going through the thread of conversation happening around inserting null using python into mysql. I am facing a similar problem here. I have to insert say 8 values into a table using a stored procedure. Of the 8 values 2 are not null and the remaining can be null, most

Multithreaded Python Mysql MAC Problems

Hi All, I wrote a multithreaded crawler program in Python 2.4 using Mysql 5.045 and MySqldb version as MySql-Python 1.2.2 on MAC OS 10.4.10 . The program strangely segfaults while it is running perfectly in Ubuntu and Windows as well. The gdb stack trace of program is below: LuLu:~/tempd

Multithreaded Python Mysql MAC Problems

Hi All, I wrote a multithreaded crawler program in Python 2.4 using Mysql 5.045 and MySqldb version as MySql-Python 1.2.2 on MAC OS 10.4.10 . The program strangely segfaults while it is running perfectly in Ubuntu and Windows as well. The gdb stack trace of program is below: LuLu:~/tempd

Re: ActiveRecord for Python/MySQL

On Aug 26, 5:52 am, Devraj <[EMAIL PROTECTED]> wrote: > Thanks > > On Aug 26, 5:26 pm, EuGeNe Van den Bulke > > <[EMAIL PROTECTED]> wrote: > > Devraj wrote: > > > My application uses MySQL as a backend and am using the MySQL/Python > > > bindings. Are there any libraries that provide a database abs

Re: ActiveRecord for Python/MySQL

Thanks On Aug 26, 5:26 pm, EuGeNe Van den Bulke <[EMAIL PROTECTED]> wrote: > Devraj wrote: > > My application uses MySQL as a backend and am using the MySQL/Python > > bindings. Are there any libraries that provide a database abstraction > > layer like Activerecords for Python?' > > SQLObject > SQ

Re: ActiveRecord for Python/MySQL

Devraj wrote: > My application uses MySQL as a backend and am using the MySQL/Python > bindings. Are there any libraries that provide a database abstraction > layer like Activerecords for Python?' SQLObject SQLAclhemy DejaVu Storm Google for Python ORM you may find more! EuGeNe -- http://www.3kw

ActiveRecord for Python/MySQL

Hi everyone, My application uses MySQL as a backend and am using the MySQL/Python bindings. Are there any libraries that provide a database abstraction layer like Activerecords for Python?' Any resources/links will be appreciated. Thanks for your time. -- http://mail.python.org/mailman/listinf

Re: Python & MySQL problem with input to table..!

Thanks It is working! -- http://mail.python.org/mailman/listinfo/python-list

Re: Python & MySQL problem with input to table..!

On Jun 29, 4:26 pm, hiroc13 <[EMAIL PROTECTED]> wrote: > >>> import MySQLdb > >>> db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", > >>> db = "base1") > >>> c = db.cursor () > >>> c.execute(""" INSERT INTO table1 (prvo, drugo) VALUES ('test', '1') """) > >>> c.execute("SEL

Python & MySQL problem with input to table..!

>>> import MySQLdb >>> db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", >>> db = "base1") >>> c = db.cursor () >>> c.execute(""" INSERT INTO table1 (prvo, drugo) VALUES ('test', '1') """) >>> c.execute("SELECT * FROM table1") >>> res = c.fetchall () >>> print res When I s

Re: How to get started as a xhtml python mysql freelancer ?

On May 26, 5:55 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > On May 25, 7:55 pm, gert <[EMAIL PROTECTED]> wrote: > > > > > > > On May 26, 2:09 am, Paul McNett <[EMAIL PROTECTED]> wrote: > > > > gert wrote: > > > > I made something that i was hoping it could make people happy enough > > > >

Re: How to get started as a xhtml python mysql freelancer ?

On May 25, 7:55 pm, gert <[EMAIL PROTECTED]> wrote: > On May 26, 2:09 am, Paul McNett <[EMAIL PROTECTED]> wrote: > > > > > > > gert wrote: > > > I made something that i was hoping it could make people happy enough > > > so i could make a living by providing support for commercial use of > > >http:/

Re: How to get started as a xhtml python mysql freelancer ?

On May 26, 2:09 am, Paul McNett <[EMAIL PROTECTED]> wrote: > gert wrote: > > I made something that i was hoping it could make people happy enough > > so i could make a living by providing support for commercial use of > >http://sourceforge.net/projects/dfo/ > > > But in reality i am a lousy sales m

Re: How to get started as a xhtml python mysql freelancer ?

On May 25, 6:48 pm, gert <[EMAIL PROTECTED]> wrote: > I made something that i was hoping it could make people happy enough > so i could make a living by providing support for commercial use > ofhttp://sourceforge.net/projects/dfo/ > > But in reality i am a lousy sales men and was wondering how you

Re: How to get started as a xhtml python mysql freelancer ?

gert wrote: > I made something that i was hoping it could make people happy enough > so i could make a living by providing support for commercial use of > http://sourceforge.net/projects/dfo/ > > But in reality i am a lousy sales men and was wondering how you people > sell stuff as a developer ?

How to get started as a xhtml python mysql freelancer ?

I made something that i was hoping it could make people happy enough so i could make a living by providing support for commercial use of http://sourceforge.net/projects/dfo/ But in reality i am a lousy sales men and was wondering how you people sell stuff as a developer ? -- http://mail.python.o

Re: Mod python - mysql lock

If you use MySQL 5, you get atomic transactions. The old "LOCK" thing is becoming obsolete. Suggest getting a newer MySQL and a newer MySQL book. John Nagle Jan Danielsson wrote: > Roopesh wrote: > >>In my mod_python project I am using mysql as the database.

Re: Mod python - mysql lock

Roopesh wrote: > In my mod_python project I am using mysql as the database. There is > table card in which unique cards are stored. When a user request comes > he has to get a unique card. In this situation I want to use LOCK with > which I can prevent other users accessing the table. I tried excut

Mod python - mysql lock

Hi, In my mod_python project I am using mysql as the database. There is table card in which unique cards are stored. When a user request comes he has to get a unique card. In this situation I want to use LOCK with which I can prevent other users accessing the table. I tried excuting "LOCK" command

Help with install python-mysql lib on OS X

How do you install MySQL-python on a PPC OS X 10.4 machine with MySQL 4.1? And I know about the precompiled binary at macpython.org... I'm just sick of getting this warning Python 2.5 (r25:51918, Sep 19 2006, 08:49:13) [GCC 4.0.1 (Apple Computer, Inc. build 5341)] on darwin Type "help", "cop

Re: Python/MySQL problem on Windows

In message <[EMAIL PROTECTED]>, Eric Smith wrote: > I could have sworn that I got the use of connection() from published > sample code, but I must be mistaken. If all else fails, read the documentation , -- http://mail.python.org/mailman/listinfo/python-

Re: Python/MySQL problem on Windows

Carsten Haese <[EMAIL PROTECTED]> writes: > What happens if you use connect(...) instead of connection(...)? Then it works! :-) I could have sworn that I got the use of connection() from published sample code, but I must be mistaken. Thanks! Eric -- http://mail.python.org/mailman/listinfo/

Re: Python/MySQL problem on Windows

On Wed, 2006-09-20 at 16:37, Eric Smith wrote: > I'm trying to use Python 2.4.3 and pywin32-209 to access a MySQL > database on Windows Server 2003 Standard Edition, and not having much > luck. It seems like parts of the MySQLdb module are not getting loaded > correctly, but no error message is giv

Python/MySQL problem on Windows

I'm trying to use Python 2.4.3 and pywin32-209 to access a MySQL database on Windows Server 2003 Standard Edition, and not having much luck. It seems like parts of the MySQLdb module are not getting loaded correctly, but no error message is given during the import, even if I give a "-vv" on the com

Re: python/mysql/list question...

bruce wrote: > hi. > > i have the following sample code. i'm trying to figure out if there's a way > to use a 'list of lists' in a mysql execute... > > i've tried a variety of combinations but i get an error: > Error 1241: Operand should contain 1 column(s) > > the test code is: > > insertSQL = "

RE: python/mysql/list question...

never mind... doh!!! executemany as opposed to execute!!! thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of bruce Sent: Thursday, August 10, 2006 6:37 PM To: python-list@python.org Subject: python/mysql/list question... hi. i have the following

python/mysql/list question...

hi. i have the following sample code. i'm trying to figure out if there's a way to use a 'list of lists' in a mysql execute... i've tried a variety of combinations but i get an error: Error 1241: Operand should contain 1 column(s) the test code is: insertSQL = """insert into appTBL

Re: Python, Mysql, insert NULL

I figured this out. Because I am using InnoDB, I need to add the commit statement. Phew. Yaron Butterfield wrote: > Hi, > > I've been having problems using Python to insert data into a MySQL > database. I've donw web searches and pulled my hairs out getting it > to work but cannot. I have

Python, Mysql, insert NULL

Hi, I've been having problems using Python to insert data into a MySQL database. I've donw web searches and pulled my hairs out getting it to work but cannot. I have no trouble doing select queries, but when I use Python to insert, though I do not receive any errors from python, the table doe

Re: python-mysql on Windows -- How to?

Oh, good. Do report back. It comes up often, and I've used only mxODBC. rd -- http://mail.python.org/mailman/listinfo/python-list

Re: python-mysql on Windows -- How to?

HI Rick, I did some searching on SourceForge and found a Windows installer for the mysql-python 1.2.0. (MySQL-python.exe-1.2.0.win32-py2.4.zip). I unzipped and ran this installer and seem to be all set. I will keep testing. Thanks. Chris -- http://mail.python.org/mailman/listinfo/python-list

Re: python-mysql on Windows -- How to?

Chris, I'm no expert, but this keeps coming up and the last several people have had better luck with mxODBC. http://tinyurl.com/fmp3y But if you're set on MySql-Python someone will jump in to help. rick -- http://mail.python.org/mailman/listinfo/python-list

python-mysql on Windows -- How to?

Can anybody provide any guidance on what I will need to do get mysql-python setup on my win xp workstation? I have Mysql 4.1 installed and activepython 2.4.3 installed. What do I need to do to install/setup mysql-python? Thanks. Chris -- http://mail.python.org/mailman/listinfo/python-list

Re: Python, Mysql, insert NULL

"Steve Holden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > If you don't understand parameterized SQL queries you would do well to > refrain from offering database advice :-) Did the poster ask a question about parameterized queries or server security? > Presumably you always

Re: Python, Mysql, insert NULL

Thanks for the many replies! The problem was that is use '%s', i have to use %s and then my problem is solved. -- http://mail.python.org/mailman/listinfo/python-list

Re: Python, Mysql, insert NULL

Thomas Bartkus wrote: [...] > > Others here have pointed out that the Python keyword "None" is converted to > "Null" when passed to MySQL. I don't quite understand this and don't really > care. If I have a Python variable that has a value None, and I want to > transmit this to MySQL as Null - I w

Re: Python, Mysql, insert NULL

"Python_it" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I know how to insert values in a database. > That's not my problem! > My problem is how i insert NULL values in de mysql-database. > None is een object in Python and NULL not. > None is not converted to NULL? > Table shows No

Re: Python, Mysql, insert NULL

Python_it wrote: > I know how to insert values in a database. > That's not my problem! > My problem is how i insert NULL values in de mysql-database. > None is een object in Python and NULL not. > None is not converted to NULL? > Table shows None and not NULL! None is converted to mysql's NULL and

Re: Python, Mysql, insert NULL

Python_it wrote: > I know how to insert values in a database. > That's not my problem! > My problem is how i insert NULL values in de mysql-database. So you *don't* know how to insert values in a database: as Laszlo wrote, you might be best using parameterized queries. > None is een object in Py

Re: Python, Mysql, insert NULL

Python_it wrote: > I know how to insert values in a database. > That's not my problem! > My problem is how i insert NULL values in de mysql-database. > None is een object in Python and NULL not. > None is not converted to NULL? > Table shows None and not NULL! As Laszlo wrote, "None will be conver

Re: Python, Mysql, insert NULL

I know how to insert values in a database. That's not my problem! My problem is how i insert NULL values in de mysql-database. None is een object in Python and NULL not. None is not converted to NULL? Table shows None and not NULL! -- http://mail.python.org/mailman/listinfo/python-list

Re: Python, Mysql, insert NULL

> > BTW, you did not write which driver are you using. Oh, you did. Sorry. :-( Import your DB module 'yourmodule' and then print yourmodule.paramstyle Description of paramstyle is also in PEP249: paramstyle String constant stating the type of parameter marker

Python, Mysql, insert NULL

Python 2.4 MySQL-python.exe-1.2.0.win32-py2.4.zip How can I insert a NULL value in a table (MySQL-database). I can't set a var to NULL? Or is there a other possibility? My var must be variable string or NULL. Becaus i have a if statement: if cursor.execute(".insert NULL

Re: Python, Mysql, insert NULL

Python_it wrote: >Python 2.4 >MySQL-python.exe-1.2.0.win32-py2.4.zip > >How can I insert a NULL value in a table (MySQL-database). >I can't set a var to NULL? Or is there a other possibility? >My var must be variable string or NULL. >Becaus i have a if statement: >if > cursor.execute("..

Re: Python, mysql, floating point values question

Use DECIMAL columns with MySQLdb-1.2.0 and Python-2.4 and you should get values back using Python's new decimal type. http://docs.python.org/whatsnew/node9.html This avoids floating point inaccuracies. -- http://mail.python.org/mailman/listinfo/python-list

Re: Python, mysql, floating point values question

Dennis Lee Bieber wrote: > Considering how often this has come up, I've sort of lost faith > in CS programs at colleges. Now, this might be an unfair statement as I > don't know if any of those bringing up the question ever had college CS > courses... But the fluff of floating point data was

Re: Python, mysql, floating point values question

On Saturday 02 July 2005 10:50 pm, Peter Hansen wrote: > Terry Hancock wrote: > > On Saturday 02 July 2005 08:53 pm, Dennis Lee Bieber wrote: > > And for that matter, some of the posters here have *been* 14. > > Terry, almost every single one of the posters here have been 14. > At some time. :-) U

Re: Python, mysql, floating point values question

Terry Hancock wrote: > On Saturday 02 July 2005 08:53 pm, Dennis Lee Bieber wrote: > And for that matter, some of the posters here have *been* 14. Terry, almost every single one of the posters here have been 14. At some time. :-) -Peter -- http://mail.python.org/mailman/listinfo/python-list

Re: Python, mysql, floating point values question

On Saturday 02 July 2005 08:53 pm, Dennis Lee Bieber wrote: > On Sat, 2 Jul 2005 18:49:20 -0400, Christopher Kang > <[EMAIL PROTECTED]> declaimed the following in comp.lang.python: > > I've been doing the epsilon comparisons, i had just hoped that to be a > > temporary solution. > > > Consid

Re: Python, mysql, floating point values question

Thanx all for responding. I've been doing the epsilon comparisons, i had just hoped that to be a temporary solution. anyway, thanx for the responses -- http://mail.python.org/mailman/listinfo/python-list

Re: Python, mysql, floating point values question

On Friday 01 July 2005 11:13 pm, John Machin wrote: > x BETWEEN y AND z Ah, even better, thank you. >The python equivalent would be to write it out as: > > > > if a > b-epsilon and a < b+epsilon: > > print "a~=b" > > Try this: > > if b-epsilon < a < b+epsilon: This I knew, but I

Re: Python, mysql, floating point values question

Hi Christopher, if you have to make calculations or comparing operations, the only "safe" method is to save and use only integer values. Of course there must be a preventive agreement on the precision you want to have (2, 3 4 ... decimals). The sw part is straigthforward: - to save in the database

Re: Python, mysql, floating point values question

Terry Hancock wrote: > On Friday 01 July 2005 05:40 pm, Christopher Kang wrote: > >>Anyway, I have a problem where I am pulling floating point values out >>of mysql and into python using the MYSQLdb module. >> >>However, the values seem to be altered a little when I store them in python. > > > I

Re: Python, mysql, floating point values question

On Friday 01 July 2005 05:40 pm, Christopher Kang wrote: > Anyway, I have a problem where I am pulling floating point values out > of mysql and into python using the MYSQLdb module. > > However, the values seem to be altered a little when I store them in python. I'm not even going to start to exp

Re: Python, mysql, floating point values question

Christopher Kang wrote: > I had a question about python and mysql, but I want to first thank > those who taught me about the factory method, it was exactly what I > needed. > > Anyway, I have a problem where I am pulling floating point values out > of mysql and into python using the MYSQLdb modul

  1   2   >