那个数据表,怎么添加啊? 谁可以告诉我啊?
表的结构 `cdb_images_album`
--
CREATE TABLE `cdb_images_album` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` mediumint(8) unsigned NOT NULL default '0',
`photoadd` varchar(200) NOT NULL default '',
`photoname` varchar(50) NOT NULL default '',
`photojianjie` text NOT NULL,
`havetime` int(10) unsigned NOT NULL default '0',
`havewith` mediumint(8) unsigned NOT NULL default '0',
`status` varchar(25) NOT NULL default '',
`pollnum` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- 导出表中的数据 `cdb_images_album`
--
-- --------------------------------------------------------
--
-- 表的结构 `cdb_images_data`
--
CREATE TABLE `cdb_images_data` (
`id` int(10) unsigned NOT NULL auto_increment,
`sort` varchar(5) NOT NULL default '',
`imagename` varchar(100) NOT NULL default '',
`cost` varchar(5) NOT NULL default '',
`description` varchar(200) NOT NULL default '',
`endurance` varchar(5) NOT NULL default '0',
`suitable` varchar(5) NOT NULL default '',
`graphic` varchar(100) NOT NULL default '',
`xgraphic` varchar(100) NOT NULL default '',
`suit` varchar(100) NOT NULL default '',
`suitgraphic` varchar(100) NOT NULL default '',
`stock` int(5) NOT NULL default '5',
`open` tinyint(1) NOT NULL default '1',
`addtime` int(10) NOT NULL default '0',
`sellnum` int(10) NOT NULL default '0',
`digest` tinyint(2) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1391 ;
--
-- 导出表中的数据 `cdb_images_data`
--
INSERT INTO `cdb_images_data` VALUES (1, '1', '湖边', '50', '湖边', '300', 't', 'BAP_00001_00.gif', 'BAD_00001_00.gif', '', '', 100, 1, 0, 0, 0);
INSERT INTO `cdb_images_data` VALUES (2, '1', '洗手间', '50', '洗手间', '300', 't', 'BAP_00002_00.gif', 'BAD_00002_00.gif', '', '', 10, 1, 0, 0, 0);
INSERT INTO `cdb_images_data` VALUES (3, '1', '下雪之夜', '50', '下雪之夜', '300', 't', 'BAP_00003_00.gif', 'BAD_00003_00.gif', '', '', 100, 1, 0, 0, 0);
INSERT INTO `cdb_images_data` VALUES (4, '1', '下雪的树林', '50', '下雪的树林', '300', 't', 'BAP_00004_00.gif', 'BAD_00004_00.gif', '', '', 100, 1, 0, 1, 0);
INSERT INTO `cdb_images_data` VALUES (5, '1', '电闪雷鸣', '50', '电闪雷鸣', '300', 't', 'BAP_00005_00.gif', 'BAD_00005_00.gif', '', '',
等等。。。以下的 这个,怎么添加阿
[ Last edited by 比翼鸟 on 2005-5-17 at 22:31 ] |