"Mark Lawrence" wrote in message
news:mailman.2752.1384654581.18130.python-l...@python.org...
> All the references regarding the subject that I can find, e.g.
> http://stackoverflow.com/questions/1829872/read-datetime-back-from-sqlite-as-a-datetime-in-python,
>
> talk about creating a table in
"Nick the Gr33k" wrote in message
news:l50oo5$k05$1...@dont-email.me...
> 1/11/2013 7:07 ??, ?/? Paul Simon ??:
>
>> If you have a list of values of the same type, but different values,
>> you need a new table with a foreign key to the table it relates
ger(5) not null default 1,
> visits datetime not null,
> downloads set('None Yet'),
>
> foreign key (counterID) references counters(ID),
> unique index (visits)
> )ENGINE = MYISAM;
>
>
> Is the SET column type the way to do it?
> i tried it but the error i'm receiving is:
>
>
> pymysql.err.InternalError: (1241, 'Operand should contain 1 column(s)')
>
> Please help pick the necessary column type that will be able to store a a
> list of values.
> --
> https://mail.python.org/mailman/listinfo/python-list
If you have a list of values of the same type, but different values,
you need a new table with a foreign key to the table it relates to.
This is a relational database question. You can read more here:
http://en.wikipedia.org/wiki/Database_normalization#Normal_forms
--
Joel Goldstick
http://joelgoldstick.com
He doesn't a many to many table, although that would put the schema
into a classic normal form. Yes, there will be duplicated data. Sometimes
de-normalizing a schema may make things simpler and easier to use for
someone not used to database work. I would also use a many to many table
being familiar with normal forms but it is not a neccessity.
Paul Simon
--
https://mail.python.org/mailman/listinfo/python-list
"rusi" wrote in message
news:92551c63-1347-4f1a-9dca-d1bbd5e4d...@ys5g2000pbc.googlegroups.com...
Its hard to distinguish what you are saying from what I said because
you've lost the quotes.
On Apr 15, 9:01 pm, "Paul Simon" wrote:
> "rusi" wrote in me
browne.com/ser-48.html ?
If there are indices and especially linked primary and foreign keys its
much more complicated than that. One has to delve into Access container
structures etc. As far as I know it has to be done from Access.
Paul Simon
--
http://mail.python.org/mailman/listinfo/python-list
"Steven D'Aprano" wrote in message
news:50ea28e7$0$30003$c3e8da3$54964...@news.astraweb.com...
> On Sun, 06 Jan 2013 19:44:08 +, Joseph L. Casale wrote:
>
>> I have a dataset that consists of a dict with text descriptions and
>> values that are integers. If required, I collect the values int
(serial.py?) with good results.
Paul Simon
"Ron Eggler" wrote in message
news:jp6gcj$1rij$1...@adenine.netfront.net...
> Hoi,
>
> I'm trying to connect to a serial port and always get the error
> "serial.serialutil.SerialException: Port is already open." w
After receiving the data, check the
received data for correct format, correct first and last characters, and if
possible, check sum. I've worked through this problem with rs-485 data
collection systems where there is no hand shaking and would not be surprised
to expect the same even with rs-232.
Paul Simon
--
http://mail.python.org/mailman/listinfo/python-list
"David Smith" wrote in message
news:h35f78$pt...@ruby.cit.cornell.edu...
> Paul Simon wrote:
>> "Peter Otten" <__pete...@web.de> wrote in message
>> news:h3481q$d95$0...@news.t-online.com...
>>> Paul Simon wrote:
>>>
>>>>
"Peter Otten" <__pete...@web.de> wrote in message
news:h3481q$d95$0...@news.t-online.com...
> Paul Simon wrote:
>
>> "Chris Rebert" wrote in message
>> news:mailman.2863.1247095339.8015.python-l...@python.org...
>> On Wed, Jul 8, 2009 at
"Chris Rebert" wrote in message
news:mailman.2863.1247095339.8015.python-l...@python.org...
On Wed, Jul 8, 2009 at 4:18 PM, Paul Simon wrote:
> I have the "tkinter" problem and need some assistance to straighten it
> out.
> >From the web page "http://wiki.
only to the
point of confusion. I'm not an expert. How do I modify my python
configuration? Is there a file that needs to be edited? Which setup.py file
do I use? Make? or python setup.py build and python setup.py install?
Thanks. I appreciate your help.
Paul Simon
--
http://mail.python.org/mailman/listinfo/python-list
subdirectories like
"build", "Demo", "Doc", "Include", "Lib", etc. There are many files under
/usr/bin/local/ which appear to be duplicates.
This looks like a mess to me and would like some help to sort this out.
Paul Simon
--
http://mail.python.org/mailman/listinfo/python-list
I suggest you look at matplotlib. It's a bit of a learning curve but will
do whatever you need. I have a similar requirement and found that gnuplot
did not work for me. The plots are impressive.
Paul Simon
wrote in message
news:h1nv4q$5k...@news.dialog.net.pl...
> Hello,
&g
14 matches
Mail list logo
