Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #100293
| From | Larry Martell <larry.martell@gmail.com> |
|---|---|
| Newsgroups | comp.lang.python |
| Subject | Re: How to connect the MYSQL database to Python program? |
| Date | 2015-12-11 13:51 -0500 |
| Message-ID | <mailman.155.1449859955.12405.python-list@python.org> (permalink) |
| References | <a1dc235b-b02e-40c6-adb7-9c280833372b@googlegroups.com> <mailman.98.1449683869.12405.python-list@python.org> <9261e7b4-48ad-45f2-ba65-066177d21f6b@googlegroups.com> |
On Fri, Dec 11, 2015 at 1:36 PM, ICT Ezy <ictezy@gmail.com> wrote:
> On Wednesday, December 9, 2015 at 9:58:02 AM UTC-8, Chris Angelico wrote:
>> On Thu, Dec 10, 2015 at 4:51 AM, ICT Ezy <ictezy@gmail.com> wrote:
>> > Pl explain me how to connect the MYSQL database to Python program?
>>
>> You start by looking for a module that lets you do that. You can use
>> your favourite web search engine, or go directly to PyPI.
>>
>> Then you learn how to use that module, including learning SQL if you
>> don't already know it.
>>
>> ChrisA
>
> Now, I installed MYSQLDB and following code was done correctly.
>
> #!/usr/bin/python
>
> import MySQLdb
>
> # Open database connection
> db = MySQLdb.connect("localhost","TESTDB")
The connect should look like this:
db= MySQLdb.connect(host, user, passwd, db)
Or to be clearer:
db= MySQLdb.connect(host="localhost", user="user", passwd="password",
db="TESTDB")
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-09 09:51 -0800
Re: How to connect the MYSQL database to Python program? Chris Angelico <rosuav@gmail.com> - 2015-12-10 04:57 +1100
Re: How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-11 10:36 -0800
Re: How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-11 10:39 -0800
Re: How to connect the MYSQL database to Python program? Larry Martell <larry.martell@gmail.com> - 2015-12-11 13:51 -0500
Re: How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-11 11:00 -0800
Re: How to connect the MYSQL database to Python program? Igor Korot <ikorot01@gmail.com> - 2015-12-11 14:11 -0500
Re: How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-11 11:13 -0800
Re: How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-11 11:11 -0800
Re: How to connect the MYSQL database to Python program? Mark Lawrence <breamoreboy@yahoo.co.uk> - 2015-12-09 21:42 +0000
Re: How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-11 10:35 -0800
Re: How to connect the MYSQL database to Python program? ICT Ezy <ictezy@gmail.com> - 2015-12-11 10:39 -0800
csiph-web