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@py.cz http://www.py.cz/mailman/listinfo/python
