pred tym vsetky je samozrejme nutne urobit import modulu: import _mysql, _mysql_exceptions
azur >-----Pôvodná správa----- >Od: azurIt [mailto:[EMAIL PROTECTED] >Komu: [email protected] >Predmet: Re: [python] (no subject > > >ahoj, > >MySQL modul stiahnes tu: >http://mysql-python.sourceforge.net/ > >mala ukazka ako to potom stade vytiahnes: > >db_conn = _mysql.connect(host="localhost", user="login", passwd="heslo", >db="databaza") >db_conn.query("SELECT name FROM users") >mysql_result = db_conn.store_result().fetch_row(maxrows=0) >db_conn.close() >print mysql_result > >azur > > >>-----Pôvodná správa----- >>Od: xxxyyyxxx [mailto:[EMAIL PROTECTED] >>Komu: [email protected] >>Predmet: [python] (no subject >> >> >>Ahoj, mam nasledujici databazi: >>-------------------------------------------------------------------- >>CREATE TABLE `users` ( >>`uid` int(10) unsigned NOT NULL default '0', >>`name` varchar(60) NOT NULL default '', >>`pass` varchar(32) NOT NULL default '', >>`mail` varchar(64) default '', >>`mode` tinyint(4) NOT NULL default '0', >>`sort` tinyint(4) default '0', >>`threshold` tinyint(4) default '0', >>`theme` varchar(255) NOT NULL default '', >>`signature` varchar(255) NOT NULL default '', >>`created` int(11) NOT NULL default '0', >>`access` int(11) NOT NULL default '0', >>`login` int(11) NOT NULL default '0', >>`status` tinyint(4) NOT NULL default '0', >>`timezone` varchar(8) default NULL, >>`language` varchar(12) NOT NULL default '', >>`picture` varchar(255) NOT NULL default '', >>`init` varchar(64) default '', >>`data` longtext, >>PRIMARY KEY (`uid`), >>UNIQUE KEY `name` (`name`), >>KEY `access` (`access`) >>) ENGINE=MyISAM DEFAULT CHARSET=latin1; >> >>INSERT INTO `users` (`uid`, `name`, `pass`, `mail`, `mode`, `sort`, >>`threshold`, `theme`, `signature`, `created`, `access`, `login`, `status`, >>`timezone`, `language`, `picture`, `init`, `data`) VALUES (0, '', '', '', 0, >>0, 0, '', '', 0, 0, 0, 0, NULL, '', '', '', NULL), >>(1, 'aaa', 'bbb', 'ccc', 0, 0, 0, '', '', 1171668726, 1174774597, 1174774596, >>1, '3600', 'cs', '', 'ddd', ''), >>(2, 'abc', 'def', 'ghi', 0, 0, 0, '', '', 1172416606, 1174761843, 1174760211, >>1, NULL, '', '', 'jkl', ''); >> >>-------------------------------------------------------------------- >>Pouzivam python 2.4.3 a MySQL 5.0.22. Potrebuju napsat v pythonu skript, >>ktery me ulozi do promene (asi jako seznam) obsah slupce name (aaa, abc). Z >>propejenim mysql a pythonu nemam zadne zkusenosti - prosim poradte. >> >>_______________________________________________ >>Python mailing list >>[email protected] >>http://www.py.cz/mailman/listinfo/python > >_______________________________________________ >Python mailing list >[email protected] >http://www.py.cz/mailman/listinfo/python _______________________________________________ Python mailing list [email protected] http://www.py.cz/mailman/listinfo/python
