Mysql ¶¨Òå×ֶεij¤¶È
Mysql Öж¨Òå×ֶκóµÄÊý¾ÝµÄÓô¦£º
int(1)ºÍint(10)ËƺõûÓÐʲô²î±ð£¬¶¼±íʾ×î´óËĸö×Ö½ÚµÄÕûÐÍÊý¾Ý¡£
ÀýÈ綨ÒåÒ»¸öÃû×ÖΪtestµÄ±í:
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(1) NOT NULL,
`ids` int(10) default NULL,
`c` char(1) default NULL,
`cs` varchar(2) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `test` VALUES ('1', '1', 'a', 'aa');
INSERT INTO `test` VALUES ('10', '10', 'a', 'aa');
INSERT INTO `test` VALUES ('2147483647', '2147483647', 'a', 'aa');
¿ÉÒÔ·¢ÏÖ£º
ÎÞÂÛÊÇint(1)»¹ÊÇint(10)¶¼×î´ó´æÈ¡2147483647 £¨¶þ½øÖÆ31¸ö1£¬ÒòΪÕý¸ºÈ¡Öµ£©£¬¿É¼û×î´ó´æÈ¡4¸ö×Ö½Ú£¬¼´intµÄ×î´ó×Ö½ÚÊý¡£
varchar(1)×î´ó´æÈ¡Ò»¸ö×Ö·û£¬varchar(2)×î´ó´æÈ¡Á½¸ö×Ö·û¡£
Ïà¹ØÎĵµ£º
Õ⼸Ìì°²×°ÁËһ̨linux·þÎñÆ÷¡£±¾À´Ò»Î»Í¦¼òµ¥¸öÊ£¬Ã»Ïëµ½ÕÛÌÚÁ˺ü¸Ìì¡£
Ê×ÏÈÊÇ °²×° AS4.4
·þÎñÆ÷ÊÇÁªÏë R520 G6£¬±¾ÒÔΪŪ¸öаæµÄunbuntu¾ÍÄÜÇý¶¯ÆðÀ´£¬Ã»Ïëµ½ÉÏÀ´¾ÍÓöµ½ÁËÂé·³¡£Ð°æµÄlinux»¹ÊÇû°ì·¨Çý¶¯ÆðÀ´£¬ÁªÏëËæ»ú¸øµÄÇý¶¯×î¸ß¾Íµ½AS4.4£¬Ã»°ì·¨Ö»ºÃÕÒÕÒAS4.4 °²×°ÁË¡£
Ê×ÏȹâÅÌÆô¶¯ ÊäÈë linux dd&nb ......
µÚÒ»¡¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þ¡¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µÚÈý¡ ......
GRANT ALL PRIVILEGES
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
Sql´úÂë ¸´ÖÆ´úÂë
1. mysql -u root -pvmwaremysql>use mysql;
  ......
http://linux.chinaitlab.com/MYSQL/524755_2.html
http://bbs.chinaunix.net/archiver/?tid-809159.html
ÔÚApache, PHP,
MySQLµÄÌåϵ¼Ü¹¹ÖУ¬MySQL¶ÔÓÚÐÔÄܵÄÓ°Ïì×î´ó£¬Ò²ÊǹؼüµÄºËÐIJ¿·Ö¡£¶ÔÓÚDiscuz!ÂÛ̳³ÌÐòÒ²ÊÇÈç´Ë£¬MySQLµÄÉèÖÃÊÇ·ñºÏÀíÓÅ»¯£¬Ö±½Ó
Ó°Ïìµ½ÂÛ̳µÄËٶȺͳÐÔØÁ¿£¡Í¬Ê±£¬MySQLÒ²ÊÇÓÅ»¯ÄѶÈ×î´ó ......