Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlÖеݹéɾ³ý¸¸½Úµã¼°ËùÓÐÆä×Ó½Úµã


DROP TABLE IF EXISTS `T_DeviceRel`;
CREATE TABLE `T_DeviceRel` (
  `Id` int(11) NOT NULL auto_increment,
  `pid` int(11) default NULL,
  `deviceId` int(11) default NULL,
  `deviceTypeId` int(11) default NULL,
  PRIMARY KEY  (`Id`)
)

INSERT INTO `T_DeviceRel` VALUES (1,0,1,1);
INSERT INTO `T_DeviceRel` VALUES (2,0,2,1);
INSERT INTO `T_DeviceRel` VALUES (3,0,3,1);
INSERT INTO `T_DeviceRel` VALUES (4,0,4,1);
INSERT INTO `T_DeviceRel` VALUES (5,0,5,1);
INSERT INTO `T_DeviceRel` VALUES (6,1,1,2);
INSERT INTO `T_DeviceRel` VALUES (7,2,22,2);
INSERT INTO `T_DeviceRel` VALUES (8,3,23,2);
INSERT INTO `T_DeviceRel` VALUES (9,3,30,2);
INSERT INTO `T_DeviceRel` VALUES (10,3,31,2);
INSERT INTO `T_DeviceRel` VALUES (11,3,32,2);
INSERT INTO `T_DeviceRel` VALUES (12,3,36,2);
INSERT INTO `T_DeviceRel` VALUES (13,3,6,3);
INSERT INTO `T_DeviceRel` VALUES (14,6,7,3);
INSERT INTO `T_DeviceRel` VALUES (15,3,2,3);
INSERT INTO `T_DeviceRel` VALUES (16,1,3,3);
INSERT INTO `T_DeviceRel` VALUES (17,7,4,3);
INSERT INTO `T_DeviceRel` VALUES (18,1,5,3);
INSERT INTO `T_DeviceRel` VALUES (19,12,5,3);


id  pid  deviceId  deviceTypeId
1    0      1            1
2    0&n


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

MYSQL character_set_server Ôõô¸Ä

ÎÒ¿ª·¢ASP.netʱ 
²åÈëÍâÎÄÂÒÂë 
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8 
character_set_connection utf8 
character_set_database utf8 
ch ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ