Re: MySQL with Python

2012-10-15 Thread Anurag Chourasia
Yes you can. There are libraries available in python to make this happen. Read this for a starter http://dev.mysql.com/usingmysql/python/ Regards, Anurag On Oct 15, 2012 10:53 AM, রুদ্র ব্যাণার্জী bnrj.ru...@gmail.com wrote: Dear friends, I am starting a project of creating a database using

Re: MySQL with Python

2012-10-15 Thread Chris Angelico
On Tue, Oct 16, 2012 at 12:45 AM, রুদ্র ব্যাণার্জী bnrj.ru...@gmail.com wrote: Dear friends, I am starting a project of creating a database using mySQL(my first project with database). I went to my institute library and find that, all books are managing mySQL with perl and php I am new to

Re: MySQL with Python

2012-10-15 Thread Demian Brecht
On 12-10-15 06:45 AM, রুদ্র ব্যাণার্জী wrote: if yes, can you kindly suggest a book/reference on this? There are a few different ways to connect to MySQL, two of which are: For reference on connecting and querying MySQL through mysql-python, take a read through

Re: MySQL with Python

2012-10-15 Thread রুদ্র ব্যাণার্জী
On Tue, 2012-10-16 at 01:01 +1100, Chris Angelico wrote: But you may wish to consider using PostgreSQL instead. Thanks, as I am very much new in database thing, I am not very aware of the options I have. But in my library, I did not found any thing on PostgreSQL. Though, I will google its

Re: MySQL with Python

2012-10-15 Thread Chris Angelico
On Tue, Oct 16, 2012 at 1:47 AM, রুদ্র ব্যাণার্জী bnrj.ru...@gmail.com wrote: On Tue, 2012-10-16 at 01:01 +1100, Chris Angelico wrote: But you may wish to consider using PostgreSQL instead. Thanks, as I am very much new in database thing, I am not very aware of the options I have. But in my

Re: MySQL with Python

2012-10-15 Thread Anurag Chourasia
Don't worry about what book you have (or don't have) in your Library..And let this not dictate your technology stack. PostgreSQL is one of the popular choice and you will never be short of documentation...Just Google and you will find lot of helpful tutorials... Regards, Anurag On Mon, Oct

Re: MySQL with Python

2012-10-15 Thread Roy Smith
In article mailman.2233.1350328857.27098.python-l...@python.org, Dennis Lee Bieber wlfr...@ix.netcom.com wrote: For routine database /access/ (that is, someone has created the database user account that will be used), MySQLdb is the Python adapter to connect to the server. For using THAT, you

Re: MySQL from python - dropping a database IF EXISTS

2006-12-04 Thread Ben
Ah well - I turned off warnings as a solution. Its a bit f a bodge, but it works :-) Ben wrote: Can someone explain why this might be happening: parser_beta.py:129: Warning: Can't drop database 'foobar'; database doesn't exist self.cursor.execute(DROP DATABASE IF EXISTS +name) But the

Re: MySQL from python - dropping a database IF EXISTS

2006-12-04 Thread Fredrik Lundh
Ben wrote: Ah well - I turned off warnings as a solution. Its a bit f a bodge, but it works :-) according to the documentation, the database does generate a note when you do this: http://dev.mysql.com/doc/refman/5.0/en/drop-table.html and notes can be turned off independently of