以前用sqlserver数据库 现在转到mysql上了 就最后一个函数不会转 其他都弄好了 ...请教一下高手 先谢谢了
函数一 set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER FUNCTION [dbo].[fu_GetPhoneNamesByOfficeID]
(
@OfficeID int
)
RETURNS varchar(250)
AS
BEGINdeclare @Str varchar(250), @PhoneName varchar(50), @isFirst bit
select @Str=''
set @isFirst=0declare name_cur cursor scroll forselect
p.手机品牌+ ' ' + p.手机型号
from
TB_BAS_Office_Model m inner join phoneInfo p on p.flngID=m.flngPhoneID and m.flngOfficeID=@OfficeIDorder by p.手机品牌, p.flngID descopen name_curfetch name_cur
into @PhoneNamewhile @@fetch_status = 0
begin
if @isFirst=0
begin
set @isFirst=1
select @Str=@Str + @PhoneName
end
else
begin
select @Str=@Str + ',' + @PhoneName
end
fetch next from name_cur
into @PhoneName
end close name_cur
deallocate name_cur
-- 返回值
return @Str
End最好能做好 我实在是搞不定了.....谢谢了 麻烦版主了
函数一 set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER FUNCTION [dbo].[fu_GetPhoneNamesByOfficeID]
(
@OfficeID int
)
RETURNS varchar(250)
AS
BEGINdeclare @Str varchar(250), @PhoneName varchar(50), @isFirst bit
select @Str=''
set @isFirst=0declare name_cur cursor scroll forselect
p.手机品牌+ ' ' + p.手机型号
from
TB_BAS_Office_Model m inner join phoneInfo p on p.flngID=m.flngPhoneID and m.flngOfficeID=@OfficeIDorder by p.手机品牌, p.flngID descopen name_curfetch name_cur
into @PhoneNamewhile @@fetch_status = 0
begin
if @isFirst=0
begin
set @isFirst=1
select @Str=@Str + @PhoneName
end
else
begin
select @Str=@Str + ',' + @PhoneName
end
fetch next from name_cur
into @PhoneName
end close name_cur
deallocate name_cur
-- 返回值
return @Str
End最好能做好 我实在是搞不定了.....谢谢了 麻烦版主了
concat(p.手机品牌, ' ' , p.手机型号 )
跪求高手指教
(
OfficeID int
)
RETURNS varchar(250)
AS
BEGINdeclare Str varchar(250);
declare PhoneName varchar(50);
declare isFirst bit;
set Str='';
set isFirst=0;declare name_cur cursor for
select
concat(p.手机品牌, ' ' , p.手机型号 )
from
TB_BAS_Office_Model m inner join phoneInfo p on p.flngID=m.flngPhoneID and m.flngOfficeID=@OfficeID
order by p.手机品牌, p.flngID desc;open name_cur;fetch name_cur into PhoneName;repeat
if isFirst=0 thenset isFirst=1;
set Str=concat(Str, PhoneName);
else
set Str=concat(Str ,',',PhoneName);
end if
fetch name_cur into PhoneName;
until 0 end repeat ;close name_cur ;
return Str;End
试试~
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(
OfficeID int
)
RETURNS varchar(250)
AS
BEGIN
declare Str varchar(25' at line 2
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : declare PhoneName varchar(50)
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'declare PhoneName varchar(50)' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : declare isFirst bit
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'declare isFirst bit' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : set Str=''
Error Code : 1193
Unknown system variable 'Str'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : set isFirst=0
Error Code : 1193
Unknown system variable 'isFirst'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : declare name_cur cursor for select concat(p.手机品牌, ' ' , p.手机型号 ) from TB_BAS_Office_Model m inner join ph...
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'declare name_cur cursor for
select
concat(p.手机品牌, ' ' , p.手机型�' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : open name_cur
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'open name_cur' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : fetch name_cur into PhoneName
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fetch name_cur into PhoneName' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : repeat if isFirst=0 then set isFirst=1
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat
if isFirst=0 then
set isFirst=1' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : set Str=concat(Str, PhoneName)
Error Code : 1193
Unknown system variable 'Str'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : else set Str=concat(Str ,',',PhoneName)
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'else
set Str=concat(Str ,',',PhoneName)' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : end if fetch name_cur into PhoneName
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end if
fetch name_cur into PhoneName' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : until 0 end repeat
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'until 0 end repeat' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : close name_cur
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'close name_cur' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : return Str
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return Str' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000Query : End
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'End' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
在sqlyog里运行出这个错误
另外描述一下你的这个函数的功能。建议能自己参考着手册改一下,如果有什么问题可以具体提出。
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
/*[DEFINER = { user | CURRENT_USER }]*/
FUNCTION `jnxp`.`fu_GetPhoneNamesByOfficeID`()
RETURNS TYPE
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN END$$DELIMITER ;为什么sqlyog里提示的格式是这个呢
/*[DEFINER = { user | CURRENT_USER }]*/
FUNCTION `jnxp`.`fu_GetPhoneNamesByOfficeID`()
RETURNS TYPE
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN END$$DELIMITER ;转义用的 必须用上
USE `jnxp`;DROP TABLE IF EXISTS `clientleave`;CREATE TABLE `clientleave` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`ServerID` int(11) DEFAULT NULL,
`LeaveTime` datetime DEFAULT NULL,
`ClientPhone` varchar(50) DEFAULT NULL,
`CEmail` varchar(50) DEFAULT NULL,
`LeaveTxt` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=666 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phonebrand`;CREATE TABLE `phonebrand` (
`flngid` int(10) NOT NULL AUTO_INCREMENT,
`fstrname` varchar(50) DEFAULT NULL,
`fbolDel` int(1) DEFAULT '0',
PRIMARY KEY (`flngid`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phonehot`;CREATE TABLE `phonehot` (
`flngid` int(10) NOT NULL AUTO_INCREMENT,
`phoneID` int(11) DEFAULT NULL,
`hot` int(11) DEFAULT NULL,
PRIMARY KEY (`flngid`)
) ENGINE=InnoDB AUTO_INCREMENT=2393 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phoneinfo`;CREATE TABLE `phoneinfo` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`phoneBrand` varchar(200) DEFAULT NULL,
`phoneType` varchar(50) DEFAULT NULL,
`phoneModels` varchar(200) DEFAULT NULL,
`phoneZMimage` varchar(200) DEFAULT NULL,
`flash` varchar(50) DEFAULT NULL,
`fstryear` varchar(200) DEFAULT NULL,
`phoneJX` varchar(200) DEFAULT NULL,
`phoneVolume` varchar(200) DEFAULT NULL,
`phoneOLCD` varchar(100) DEFAULT NULL,
`phoneILCD` varchar(200) DEFAULT NULL,
`phoneWP` varchar(200) DEFAULT NULL,
`phoneWeight` varchar(200) DEFAULT NULL,
`phoneColor` varchar(200) DEFAULT NULL,
`phoneCallTime` varchar(200) DEFAULT NULL,
`phoneSleepTime` varchar(200) DEFAULT NULL,
`phoneMomory` varchar(200) DEFAULT NULL,
`phoneExpansionCard` varchar(200) DEFAULT NULL,
`phoneSystem` varchar(200) DEFAULT NULL,
`phoneMethod` varchar(200) DEFAULT NULL,
`phoneStandConf` varchar(200) DEFAULT NULL,
`phoneCharacteristic` varchar(200) DEFAULT NULL,
`phoneAddressBook` varchar(200) DEFAULT NULL,
`phoneSMS` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`phoneMMS` varchar(100) DEFAULT NULL,
`phoneCamera` varchar(200) DEFAULT NULL,
`phoneCameraPixels` varchar(200) DEFAULT NULL,
`phoneflashlight` varchar(200) DEFAULT NULL,
`phoneZoomMode` varchar(200) DEFAULT NULL,
`phonevideoshooting` varchar(200) DEFAULT NULL,
`phoneVideoPlayer` varchar(200) DEFAULT NULL,
`phoneRing` varchar(200) DEFAULT NULL,
`phoneMp3` varchar(200) DEFAULT NULL,
`phoneBluetooth` varchar(200) DEFAULT NULL,
`phoneInfrared` varchar(200) DEFAULT NULL,
`WLAN` varchar(200) DEFAULT NULL,
`WAP` varchar(200) DEFAULT NULL,
`EDGE` varchar(200) DEFAULT NULL,
`phoneSynchronous` varchar(200) DEFAULT NULL,
`phoneDataLine` varchar(200) DEFAULT NULL,
`phoneGSM` varchar(200) DEFAULT NULL,
`phoneFrequency` varchar(200) DEFAULT NULL,
`JAVA` varchar(200) DEFAULT NULL,
`BREW` varchar(200) DEFAULT NULL,
`GPS` varchar(200) DEFAULT NULL,
`phoneOtherData` varchar(200) DEFAULT NULL,
`phoneAdditional` varchar(200) DEFAULT NULL,
`phoneOffers` varchar(100) DEFAULT NULL,
`phoneContent` varchar(200) DEFAULT NULL,
`fcurMember` int(11) DEFAULT NULL,
`fcurEmpty` int(11) DEFAULT NULL,
`fcurKit` int(11) DEFAULT NULL,
`fbolDel` int(1) NOT NULL,
`phoneZCimage` varchar(100) DEFAULT NULL,
`phoneYCimage` varchar(100) DEFAULT NULL,
`phoneBMimage` varchar(100) DEFAULT NULL,
`phoneAdvertisement` varchar(100) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=404 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phoneinfotj`;CREATE TABLE `phoneinfotj` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`orderbyid` int(11) DEFAULT NULL,
`Phoneflngid` int(11) DEFAULT NULL,
`serverID` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phonemovelog`;CREATE TABLE `phonemovelog` (
`MoveDatetime` datetime DEFAULT NULL,
`ServerID` int(11) DEFAULT NULL,
`PhoneID` int(11) DEFAULT NULL,
`IpAddress` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phoneoptpd`;CREATE TABLE `phoneoptpd` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`OptID` int(11) DEFAULT NULL,
`orderbyid` int(11) DEFAULT NULL,
`Phoneflngid` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3168 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phonepaihang`;CREATE TABLE `phonepaihang` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`orderbyid` int(11) DEFAULT NULL,
`Phoneflngid` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `phonepointlog`;CREATE TABLE `phonepointlog` (
`MoveDatetime` datetime DEFAULT NULL,
`ServerID` int(11) DEFAULT NULL,
`PhoneID` int(11) DEFAULT NULL,
`IpAddress` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
`ID` int(10) NOT NULL AUTO_INCREMENT,
`orderbyid` int(11) DEFAULT NULL,
`Phoneflngid` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_bas_office`;CREATE TABLE `tb_bas_office` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`fstrName` varchar(200) DEFAULT NULL,
`fstrLinkman` varchar(50) DEFAULT NULL,
`fstrPhone` varchar(50) DEFAULT NULL,
`fstrAddr` varchar(200) DEFAULT NULL,
`fstrRe` varchar(200) DEFAULT NULL,
`fbolDel` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_bas_office_model`;CREATE TABLE `tb_bas_office_model` (
`flngOfficeID` int(11) NOT NULL,
`flngPhoneID` int(11) NOT NULL,
`fintNumber` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_action`;CREATE TABLE `tb_opt_action` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`fstrName` varchar(50) DEFAULT NULL,
`fintType` int(6) DEFAULT NULL,
`fstrLogo` varchar(50) DEFAULT NULL,
`fstrRe` varchar(200) DEFAULT NULL,
`fbolDel` int(1) DEFAULT '0',
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_action_phone`;CREATE TABLE `tb_opt_action_phone` (
`flngActionID` int(11) NOT NULL,
`flngPhoneID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_media`;CREATE TABLE `tb_opt_media` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`fstrName` varchar(250) DEFAULT NULL,
`fstrUrl` varchar(250) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_mediapd`;CREATE TABLE `tb_opt_mediapd` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`flngMediaID` int(20) DEFAULT NULL,
`flngOfficeID` int(20) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;/*Data for the table `tb_opt_mediapd` *//*Table structure for table `tb_opt_menu` */DROP TABLE IF EXISTS `tb_opt_menu`;CREATE TABLE `tb_opt_menu` (
`flngID` int(11) NOT NULL,
`flngDesc` int(11) DEFAULT NULL,
`fstrMenuName` varchar(50) DEFAULT NULL,
`fbolType` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_pc`;CREATE TABLE `tb_opt_pc` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`flngOfficeID` int(11) DEFAULT NULL,
`fstrName` varchar(50) DEFAULT NULL,
`fstrMAC` varchar(50) DEFAULT NULL,
`fstrIP` varchar(50) DEFAULT NULL,
`fstrType` varchar(50) DEFAULT NULL,
`fstrVersion` varchar(50) DEFAULT NULL,
`fdtmCreateTime` datetime DEFAULT NULL,
`fdtmUpdateTime` datetime DEFAULT NULL,
`fintOrder` int(11) DEFAULT NULL,
`fbolDel` int(1) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_phonetype`;CREATE TABLE `tb_opt_phonetype` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`fstrTypeName` varchar(50) NOT NULL,
`fstrRe` varchar(200) DEFAULT NULL,
`fbolDel` int(1) NOT NULL,
`flngDetailID` int(11) DEFAULT NULL,
`fstrDesc` varchar(200) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_plcconfig`;CREATE TABLE `tb_opt_plcconfig` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`flngPCID` int(20) DEFAULT NULL,
`fintPort` int(11) DEFAULT NULL,
`flngID1` int(11) DEFAULT NULL,
`flngID2` int(11) DEFAULT NULL,
`flngID3` int(11) DEFAULT NULL,
`flngID4` int(11) DEFAULT NULL,
`flngID5` int(11) DEFAULT NULL,
`flngID6` int(11) DEFAULT NULL,
`flngID7` int(11) DEFAULT NULL,
`flngID8` int(11) DEFAULT NULL,
`flngID9` int(11) DEFAULT NULL,
`flngID10` int(11) DEFAULT NULL,
`flngID11` int(11) DEFAULT NULL,
`flngID12` int(11) DEFAULT NULL,
`flngID13` int(11) DEFAULT NULL,
`flngID14` int(11) DEFAULT NULL,
`flngID15` int(11) DEFAULT NULL,
`flngID16` int(11) DEFAULT NULL,
`flngID17` int(11) DEFAULT NULL,
`flngID18` int(11) DEFAULT NULL,
`flngID19` int(11) DEFAULT NULL,
`flngID20` int(11) DEFAULT NULL,
`flngID21` int(11) DEFAULT NULL,
`flngID22` int(11) DEFAULT NULL,
`flngID23` int(11) DEFAULT NULL,
`flngID24` int(11) DEFAULT NULL,
`fstrShelf` varchar(50) DEFAULT NULL,
`fintMoveType` int(6) DEFAULT NULL,
`fstrDBPath` varchar(100) DEFAULT NULL,
`fstrResPath` varchar(100) DEFAULT NULL,
`fstrMainurl` varchar(50) DEFAULT NULL,
`fstrQuiturl` varchar(50) DEFAULT NULL,
`fstrMoveurl` varchar(50) DEFAULT NULL,
`fstrRegNo` varchar(50) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_watch`;CREATE TABLE `tb_opt_watch` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`flngPCID` int(11) DEFAULT NULL,
`fdtmUpdateTime` datetime DEFAULT NULL,
`fintState` int(6) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_opt_watch_exception`;CREATE TABLE `tb_opt_watch_exception` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`flngPCID` int(11) DEFAULT NULL,
`fdtmStartTime` datetime DEFAULT NULL,
`fdtmEndTime` datetime DEFAULT NULL,
`fintType` int(6) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=929 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_photoopt_mx`;CREATE TABLE `tb_photoopt_mx` (
`OptId` int(10) NOT NULL AUTO_INCREMENT,
`TypeId` int(11) DEFAULT NULL,
`OptName` varchar(50) DEFAULT NULL,
`Orderby` int(6) DEFAULT NULL,
`logo` varchar(50) DEFAULT NULL,
`flash` varchar(50) DEFAULT NULL,
`miaoshu` varchar(200) DEFAULT NULL,
`fbolDel` int(1) DEFAULT NULL,
PRIMARY KEY (`OptId`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_sys_group`;CREATE TABLE `tb_sys_group` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`fstrDesc` varchar(200) DEFAULT NULL,
`fstrRe` varchar(200) DEFAULT NULL,
`fbolDel` int(1) NOT NULL,
`fdtmCreateTime` datetime DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_sys_power`;CREATE TABLE `tb_sys_power` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`fstrSys` varchar(50) DEFAULT NULL,
`fstrModel` varchar(50) DEFAULT NULL,
`fstrPower` varchar(50) DEFAULT NULL,
`fstrFunction` varchar(100) DEFAULT NULL,
`flngClientID` int(11) DEFAULT NULL,
`fstrType` varchar(50) DEFAULT NULL,
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=290 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_sys_user`;CREATE TABLE `tb_sys_user` (
`flngID` int(10) NOT NULL AUTO_INCREMENT,
`fstrUserName` varchar(50) DEFAULT NULL,
`fstrPassword` varchar(50) DEFAULT NULL,
`fstrTrueName` varchar(50) DEFAULT NULL,
`flngGroupID` int(11) DEFAULT NULL,
`fbolLock` int(1) NOT NULL DEFAULT '0',
`flngOfficeID` int(11) DEFAULT NULL,
`fdtmLastLogin` datetime DEFAULT NULL,
`fdtmCreateTime` datetime DEFAULT NULL,
`fbolDel` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`flngID`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `tb_xiao_log`;CREATE TABLE `tb_xiao_log` (
`flngid` int(10) NOT NULL AUTO_INCREMENT,
`fstrmenu` varchar(50) DEFAULT NULL,
`fstrPor` varchar(200) DEFAULT NULL,
`fstrJiaoSe` char(10) DEFAULT NULL,
`fstrUser` varchar(50) DEFAULT NULL,
`fstrIP` varchar(50) DEFAULT NULL,
`fstrTime` datetime DEFAULT NULL,
`fboldel` int(1) DEFAULT NULL,
PRIMARY KEY (`flngid`)
) ENGINE=InnoDB AUTO_INCREMENT=6433 DEFAULT CHARSET=gbk;DROP TABLE IF EXISTS `pd`;DROP TABLE IF EXISTS `phb`;DROP TABLE IF EXISTS `rm`;DROP TABLE IF EXISTS `tj`;DROP TABLE IF EXISTS `vphonehot`;DROP TABLE IF EXISTS `vw_movetj`;DROP TABLE IF EXISTS `vw_pointtj`;
手机型号 phoneModels
手机品牌和型号开始是中文字段后来我改了英文的 避免他出乱码 这个是前后的对照