在php中如何导入导出视图和存储过程,在线等 在php中如何导入导出视图和存储过程 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 php 中是指什么?你从哪里导入?如果是有 *.sql 备份文件,其中的SQL语句你直接执行就可以了。你可以 mysql -uUserName -pPswd myDatabaseName < xxx.sql 如果是用mysql_query,这个方法?在导入时发现视图和存储过程都没有 你导出的时候有没有把存储过程一起导出来。默认是不导出存储过程的。 mysqldump 导出时需要加上 -R 参数。 数据库出错:MySQL Query ErrorMysql error description: Unknown column 'bannerdiy.da_classify.ParentID' in 'field list'Mysql error number: 1054Date: 2009-07-13 @ 01:26Script: http://localhost/test/install/install.php 提示是你的表'bannerdiy.da_classify 不找不到这个字段ParentID' , 建议你检查一下,你的create view 语句中是否有问题。可能的一种原因就是你的 create view 在它所基于的表或视图之前执行了。这种情况手工调整一下语句的执行顺序。 DROP VIEW IF EXISTS `bannerclassify`;CREATE TABLE IF NOT EXISTS `bannerclassify` (`ParentID` int(11),`Pcname` varchar(100),`ClassifyID` int(11),`Cname` char(100),`BID` int(11));DROP TABLE IF EXISTS `da_admins`;CREATE TABLE IF NOT EXISTS `da_admins` ( `uid` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `username` char(15) NOT NULL DEFAULT '', `password` char(32) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL, PRIMARY KEY (`uid`), UNIQUE KEY `username` (`username`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;INSERT INTO `da_admins` (`uid`, `username`, `password`, `description`) VALUES(1, 'tm', '098f6bcd4621d373cade4e832627b4f6', '');DROP TABLE IF EXISTS `da_admins_roles`;CREATE TABLE IF NOT EXISTS `da_admins_roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `role_id` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;INSERT INTO `da_admins_roles` (`id`, `uid`, `role_id`) VALUES(1, 1, 1);DROP TABLE IF EXISTS `da_banner`;CREATE TABLE IF NOT EXISTS `da_banner` ( `BannerID` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一ID', `Bname` char(100) NOT NULL COMMENT '广告或模板名称', `Btype` tinyint(4) NOT NULL DEFAULT '0' COMMENT '区別 ,0 模板 1 广告', `Bstatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '狀態 ,0 停用 1 有效', `ClassifyID` int(11) NOT NULL DEFAULT '0' COMMENT '分类ID', `Content` text NOT NULL COMMENT '內容数組', `Addtime` int(11) NOT NULL COMMENT '添加时间', `Modtime` int(11) NOT NULL COMMENT '修改时间', `Bsize` tinyint(4) NOT NULL DEFAULT '0' COMMENT '尺寸 (0 1 2 3 4 5 6 7 8)..', `UseTime` int(11) NOT NULL DEFAULT '0' COMMENT '使用次数', PRIMARY KEY (`BannerID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;DROP TABLE IF EXISTS `da_bannerclassify`;CREATE TABLE IF NOT EXISTS `da_bannerclassify` ( `BID` int(11) NOT NULL COMMENT '广告模板ID', `CID` int(11) NOT NULL COMMENT '类別ID', KEY `BID` (`BID`), KEY `CID` (`CID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `da_classify`;CREATE TABLE IF NOT EXISTS `da_classify` ( `ClassifyID` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID', `ParentID` int(11) NOT NULL DEFAULT '0' COMMENT '上級分类ID', `Clevel` tinyint(4) NOT NULL COMMENT '分类級', `Cname` char(100) NOT NULL COMMENT '分类名称', `Cdesc` text NOT NULL COMMENT '分类说明', `Csort` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分类排序', `Ctype` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分类区別 ,0 素材分类 1 模板分类', `Addtime` int(11) NOT NULL COMMENT '添加时间', PRIMARY KEY (`ClassifyID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;DROP TABLE IF EXISTS `da_controller_acts`;CREATE TABLE IF NOT EXISTS `da_controller_acts` ( `act_id` int(10) NOT NULL AUTO_INCREMENT, `role_id` int(10) NOT NULL DEFAULT '0', `controller_name` varchar(32) NOT NULL DEFAULT '', `action_name` varchar(32) NOT NULL DEFAULT '', `act` varchar(20) NOT NULL, PRIMARY KEY (`act_id`), KEY `key_rca` (`role_id`,`controller_name`,`action_name`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=104 ;DROP TABLE IF EXISTS `da_cploginlog`;CREATE TABLE IF NOT EXISTS `da_cploginlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `ip` char(15) NOT NULL, `dateline` int(10) unsigned NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;DROP TABLE IF EXISTS `da_cpoperlog`;CREATE TABLE IF NOT EXISTS `da_cpoperlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` smallint(6) unsigned NOT NULL, `controller` varchar(30) NOT NULL, `action` varchar(30) NOT NULL, `loginfo` text NOT NULL, `ip` char(15) NOT NULL, `dateline` int(10) unsigned NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=70 ;DROP TABLE IF EXISTS `da_cpsessions`;CREATE TABLE IF NOT EXISTS `da_cpsessions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` char(15) NOT NULL DEFAULT '', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `errorcount` tinyint(1) NOT NULL DEFAULT '0', KEY `key_ud` (`id`,`dateline`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;DROP TABLE IF EXISTS `da_cpwarnlog`;CREATE TABLE IF NOT EXISTS `da_cpwarnlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `logtype` varchar(20) NOT NULL, `loginfo` text NOT NULL, `dateline` int(10) unsigned NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;DROP TABLE IF EXISTS `da_mateclassify`;CREATE TABLE IF NOT EXISTS `da_mateclassify` ( `MID` int(11) NOT NULL COMMENT '素材ID', `CID` int(11) NOT NULL COMMENT '类別ID', KEY `MID` (`MID`), KEY `CID` (`CID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `da_material`;CREATE TABLE IF NOT EXISTS `da_material` ( `MateID` int(11) NOT NULL AUTO_INCREMENT COMMENT '素材ID', `MateName` char(250) NOT NULL COMMENT '素材名', `ImageUrl` char(250) NOT NULL COMMENT '源圖', `ThumbUrl` char(250) NOT NULL COMMENT '略縮圖', `AddTime` int(11) DEFAULT NULL COMMENT '添加时间', `UseTime` int(11) NOT NULL DEFAULT '0' COMMENT '使用次数', PRIMARY KEY (`MateID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=156 ;DROP TABLE IF EXISTS `da_materialdel`;CREATE TABLE IF NOT EXISTS `da_materialdel` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `MateName` char(250) NOT NULL, `ImageUrl` char(250) NOT NULL, `MateID` int(11) NOT NULL, PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;DROP TABLE IF EXISTS `da_roles`;CREATE TABLE IF NOT EXISTS `da_roles` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, `role_type` tinyint(4) NOT NULL DEFAULT '0', `rolename` varchar(32) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL, `num` int(10) NOT NULL DEFAULT '0', `isdef` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`role_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;DROP TABLE IF EXISTS `da_users_roles`;CREATE TABLE IF NOT EXISTS `da_users_roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` varchar(32) NOT NULL, `role_id` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;DROP VIEW IF EXISTS `mateclassify`;CREATE TABLE IF NOT EXISTS `mateclassify` (`ParentID` int(11),`Pcname` varchar(100),`ClassifyID` int(11),`Cname` char(100),`MID` int(11));CREATE ALGORITHM=UNDEFINED DEFINER=`test`@`%` SQL SECURITY DEFINER VIEW `bannerclassify` AS select `bannerdiy`.`da_classify`.`ParentID` AS `ParentID`,(select `bannerdiy`.`da_classify`.`Cname` AS `Cname` from `da_classify` where (`bannerdiy`.`da_classify`.`ClassifyID` = `bannerdiy`.`da_classify`.`ParentID`)) AS `Pcname`,`bannerdiy`.`da_classify`.`ClassifyID` AS `ClassifyID`,`bannerdiy`.`da_classify`.`Cname` AS `Cname`,`bannerdiy`.`da_bannerclassify`.`BID` AS `BID` from (`da_classify` join (`da_banner` join `da_bannerclassify` on((`bannerdiy`.`da_banner`.`BannerID` = `bannerdiy`.`da_bannerclassify`.`BID`))) on((`bannerdiy`.`da_classify`.`ClassifyID` = `bannerdiy`.`da_bannerclassify`.`CID`)));CREATE ALGORITHM=UNDEFINED DEFINER=`test`@`%` SQL SECURITY DEFINER VIEW `mateclassify` AS select `bannerdiy`.`da_classify`.`ParentID` AS `ParentID`,(select `bannerdiy`.`da_classify`.`Cname` AS `Cname` from `da_classify` where (`bannerdiy`.`da_classify`.`ClassifyID` = `bannerdiy`.`da_classify`.`ParentID`)) AS `Pcname`,`bannerdiy`.`da_classify`.`ClassifyID` AS `ClassifyID`,`bannerdiy`.`da_classify`.`Cname` AS `Cname`,`bannerdiy`.`da_mateclassify`.`MID` AS `MID` from ((`da_material` join `da_mateclassify` on((`bannerdiy`.`da_material`.`MateID` = `bannerdiy`.`da_mateclassify`.`MID`))) join `da_classify` on((`bannerdiy`.`da_mateclassify`.`CID` = `bannerdiy`.`da_classify`.`ClassifyID`))); 数据库出错:MySQL Query ErrorMysql error description: Unknown column 'bannerdiy.da_classify.ParentID' in 'field list'Mysql error number: 1054Date: 2009-07-13 @ 02:03Script: http://localhost/test/install/install.php 你导入的时候,有没有选择数据库先?检查一下你的表都导入到哪个数据库了 是不是导入到bannerdiy 这个数据库中了?(从错误提示上看,你的这些表没有导入到这个数据库中) navicat for mysql软件关于外键的一个小问题 求Mysql语句求和 自增字段怎么设值 mysql MySQL 5 如何查看一个表有多少个 session 在访问呢? my.ini的位置 问一个MYSQL连接的问题,急~!! mysql在2000机子上如何安装阿? 怎么使mysql从一个表复制到另一个表的尾部 如何取得linux服务器的系统时间,我用的是Mysql的数据库 大家知道哪些比较大的公司都使用MySql吗? mysql PROCEDURE 里面使用查询怎么会返回全表呢,某些项又不对.........
你可以 mysql -uUserName -pPswd myDatabaseName < xxx.sql
在导入时发现视图和存储过程都没有
Mysql error number: 1054
Date: 2009-07-13 @ 01:26
Script: http://localhost/test/install/install.php
CREATE TABLE IF NOT EXISTS `bannerclassify` (
`ParentID` int(11)
,`Pcname` varchar(100)
,`ClassifyID` int(11)
,`Cname` char(100)
,`BID` int(11)
);
DROP TABLE IF EXISTS `da_admins`;
CREATE TABLE IF NOT EXISTS `da_admins` (
`uid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`username` char(15) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `da_admins` (`uid`, `username`, `password`, `description`) VALUES
(1, 'tm', '098f6bcd4621d373cade4e832627b4f6', '');
DROP TABLE IF EXISTS `da_admins_roles`;
CREATE TABLE IF NOT EXISTS `da_admins_roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `da_admins_roles` (`id`, `uid`, `role_id`) VALUES
(1, 1, 1);
DROP TABLE IF EXISTS `da_banner`;
CREATE TABLE IF NOT EXISTS `da_banner` (
`BannerID` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
`Bname` char(100) NOT NULL COMMENT '广告或模板名称',
`Btype` tinyint(4) NOT NULL DEFAULT '0' COMMENT '区別 ,0 模板 1 广告',
`Bstatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '狀態 ,0 停用 1 有效',
`ClassifyID` int(11) NOT NULL DEFAULT '0' COMMENT '分类ID',
`Content` text NOT NULL COMMENT '內容数組',
`Addtime` int(11) NOT NULL COMMENT '添加时间',
`Modtime` int(11) NOT NULL COMMENT '修改时间',
`Bsize` tinyint(4) NOT NULL DEFAULT '0' COMMENT '尺寸 (0 1 2 3 4 5 6 7 8)..',
`UseTime` int(11) NOT NULL DEFAULT '0' COMMENT '使用次数',
PRIMARY KEY (`BannerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
DROP TABLE IF EXISTS `da_bannerclassify`;
CREATE TABLE IF NOT EXISTS `da_bannerclassify` (
`BID` int(11) NOT NULL COMMENT '广告模板ID',
`CID` int(11) NOT NULL COMMENT '类別ID',
KEY `BID` (`BID`),
KEY `CID` (`CID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `da_classify`;
CREATE TABLE IF NOT EXISTS `da_classify` (
`ClassifyID` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID',
`ParentID` int(11) NOT NULL DEFAULT '0' COMMENT '上級分类ID',
`Clevel` tinyint(4) NOT NULL COMMENT '分类級',
`Cname` char(100) NOT NULL COMMENT '分类名称',
`Cdesc` text NOT NULL COMMENT '分类说明',
`Csort` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分类排序',
`Ctype` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分类区別 ,0 素材分类 1 模板分类',
`Addtime` int(11) NOT NULL COMMENT '添加时间',
PRIMARY KEY (`ClassifyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
DROP TABLE IF EXISTS `da_controller_acts`;
CREATE TABLE IF NOT EXISTS `da_controller_acts` (
`act_id` int(10) NOT NULL AUTO_INCREMENT,
`role_id` int(10) NOT NULL DEFAULT '0',
`controller_name` varchar(32) NOT NULL DEFAULT '',
`action_name` varchar(32) NOT NULL DEFAULT '',
`act` varchar(20) NOT NULL,
PRIMARY KEY (`act_id`),
KEY `key_rca` (`role_id`,`controller_name`,`action_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=104 ;
DROP TABLE IF EXISTS `da_cploginlog`;
CREATE TABLE IF NOT EXISTS `da_cploginlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`ip` char(15) NOT NULL,
`dateline` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
DROP TABLE IF EXISTS `da_cpoperlog`;
CREATE TABLE IF NOT EXISTS `da_cpoperlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` smallint(6) unsigned NOT NULL,
`controller` varchar(30) NOT NULL,
`action` varchar(30) NOT NULL,
`loginfo` text NOT NULL,
`ip` char(15) NOT NULL,
`dateline` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=70 ;
DROP TABLE IF EXISTS `da_cpsessions`;
CREATE TABLE IF NOT EXISTS `da_cpsessions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` char(15) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`errorcount` tinyint(1) NOT NULL DEFAULT '0',
KEY `key_ud` (`id`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
DROP TABLE IF EXISTS `da_cpwarnlog`;
CREATE TABLE IF NOT EXISTS `da_cpwarnlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`logtype` varchar(20) NOT NULL,
`loginfo` text NOT NULL,
`dateline` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `da_mateclassify`;
CREATE TABLE IF NOT EXISTS `da_mateclassify` (
`MID` int(11) NOT NULL COMMENT '素材ID',
`CID` int(11) NOT NULL COMMENT '类別ID',
KEY `MID` (`MID`),
KEY `CID` (`CID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `da_material`;
CREATE TABLE IF NOT EXISTS `da_material` (
`MateID` int(11) NOT NULL AUTO_INCREMENT COMMENT '素材ID',
`MateName` char(250) NOT NULL COMMENT '素材名',
`ImageUrl` char(250) NOT NULL COMMENT '源圖',
`ThumbUrl` char(250) NOT NULL COMMENT '略縮圖',
`AddTime` int(11) DEFAULT NULL COMMENT '添加时间',
`UseTime` int(11) NOT NULL DEFAULT '0' COMMENT '使用次数',
PRIMARY KEY (`MateID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=156 ;
DROP TABLE IF EXISTS `da_materialdel`;
CREATE TABLE IF NOT EXISTS `da_materialdel` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`MateName` char(250) NOT NULL,
`ImageUrl` char(250) NOT NULL,
`MateID` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
DROP TABLE IF EXISTS `da_roles`;
CREATE TABLE IF NOT EXISTS `da_roles` (
`role_id` int(11) NOT NULL AUTO_INCREMENT,
`role_type` tinyint(4) NOT NULL DEFAULT '0',
`rolename` varchar(32) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL,
`num` int(10) NOT NULL DEFAULT '0',
`isdef` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
DROP TABLE IF EXISTS `da_users_roles`;
CREATE TABLE IF NOT EXISTS `da_users_roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` varchar(32) NOT NULL,
`role_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP VIEW IF EXISTS `mateclassify`;
CREATE TABLE IF NOT EXISTS `mateclassify` (
`ParentID` int(11)
,`Pcname` varchar(100)
,`ClassifyID` int(11)
,`Cname` char(100)
,`MID` int(11)
);
CREATE ALGORITHM=UNDEFINED DEFINER=`test`@`%` SQL SECURITY DEFINER VIEW `bannerclassify` AS select `bannerdiy`.`da_classify`.`ParentID` AS `ParentID`,(select `bannerdiy`.`da_classify`.`Cname` AS `Cname` from `da_classify` where (`bannerdiy`.`da_classify`.`ClassifyID` = `bannerdiy`.`da_classify`.`ParentID`)) AS `Pcname`,`bannerdiy`.`da_classify`.`ClassifyID` AS `ClassifyID`,`bannerdiy`.`da_classify`.`Cname` AS `Cname`,`bannerdiy`.`da_bannerclassify`.`BID` AS `BID` from (`da_classify` join (`da_banner` join `da_bannerclassify` on((`bannerdiy`.`da_banner`.`BannerID` = `bannerdiy`.`da_bannerclassify`.`BID`))) on((`bannerdiy`.`da_classify`.`ClassifyID` = `bannerdiy`.`da_bannerclassify`.`CID`)));
CREATE ALGORITHM=UNDEFINED DEFINER=`test`@`%` SQL SECURITY DEFINER VIEW `mateclassify` AS select `bannerdiy`.`da_classify`.`ParentID` AS `ParentID`,(select `bannerdiy`.`da_classify`.`Cname` AS `Cname` from `da_classify` where (`bannerdiy`.`da_classify`.`ClassifyID` = `bannerdiy`.`da_classify`.`ParentID`)) AS `Pcname`,`bannerdiy`.`da_classify`.`ClassifyID` AS `ClassifyID`,`bannerdiy`.`da_classify`.`Cname` AS `Cname`,`bannerdiy`.`da_mateclassify`.`MID` AS `MID` from ((`da_material` join `da_mateclassify` on((`bannerdiy`.`da_material`.`MateID` = `bannerdiy`.`da_mateclassify`.`MID`))) join `da_classify` on((`bannerdiy`.`da_mateclassify`.`CID` = `bannerdiy`.`da_classify`.`ClassifyID`)));
Mysql error number: 1054
Date: 2009-07-13 @ 02:03
Script: http://localhost/test/install/install.php