[python] (no subject

[azurIt]

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:xyz007 na centrum.cz]
>Komu: python na py.cz
>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
>Python na py.cz
>http://www.py.cz/mailman/listinfo/python