poll.sql

来自「实现flash的饼图投票」· SQL 代码 · 共 19 行

CREATE TABLE `options` (
  `id` smallint(1) NOT NULL default '0',
  `opt` varchar(60) NOT NULL default '',
  `num` int(5) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `options` VALUES (0, 'ASP', 70);
INSERT INTO `options` VALUES (1, 'PHP', 75);
INSERT INTO `options` VALUES (2, 'ASP.NET', 39);
INSERT INTO `options` VALUES (3, 'CGI', 39);
INSERT INTO `options` VALUES (4, 'JAVA', 44);


CREATE TABLE `question` (
  `que` varchar(60) NOT NULL default ''
) TYPE=MyISAM;
INSERT INTO `question` VALUES ('您认为目前最有前途的语言是:');