MySqlÖеÄÄ£ºý²éѯ
ÔÚMySqlÖеÄÄ£ºý²éѯºÍÔÚMSSQLÖеIJ¶à£¬±¾¼Ç¼Ö÷ÒªÊÇ˵ÔÚJDBCÖÐʹÓÃPreparedStatementÀ´¹¹ÔìÒ»¸öÄ£ºý²éѯµÄÓï¾ä¡£
Ä£ºý²éѯSQLÓï¾ä£ºSELECT * from tableA WHERE colA LIKE '%ҪƥÅäµÄÄÚÈÝ%'
¹¹ÔìPreparedStatement£º
String sql = "SELECT * from tableA WHERE colA LIKE [-ÕâÀïÌîʲôÄØ£¿-]";
PreparedStatement pstmt = ...;
ÄDZßÌîʲôÄØ£¿¾¹ý³¢ÊÔ£¬µÃ³ö£º
String sql = "SELECT * from tableA WHERE colA LIKE ?";
String pattern = "ҪƥÅäµÄÄÚÈÝ";
pstmt.setString(1, "%" + pattern + "%");
²»Òª³¢ÊÔÔÚLIKEºóÃæ½Ó£º'%?%'»òÕßÖ±½Ó?
¶¼ÊDz»Ðеģ¬ÊÔ¹ýÁË¡£¡£
Ïà¹ØÎĵµ£º
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
mysql Ã÷Ã÷ÒѾװºÃÁË£¬µ«ÊÇÎÞ·¨·ÃÎÊ¡£Á´½ÓµÄʱºò ×ÜÊÇ˵
Access Denied.
½â¾ö·½·¨£º
ÓÃmysqld --skip-grant-tableÆô¶¯mysql
È»ºóÔÚmysql¿âÖÐÖ´ÐÐÕâ¸ö
INSERT INTO user VALUES ('localhost', 'root', PASSWORD('some_pass'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y', ......
MySql Error Nr. 1045
¹Ø¼ü×Ö: error 1045
ÎÊÌâÃèÊö£º
Ò»¸ö¿Í»§µÄ·þÎñÆ÷£¨windows£©ÉÏÒѾװÁËÒ»¸öphp+apache+mysql£¬ÏÖÔÚÐèÒªÔÚÕą̂·þÎñÆ÷ÉÏÔÙ×°Ò»¸ö֪ʶ¿âϵͳ£¬
Êý¾Ý¿âÒ²ÊÇʹÓõÄmysql£¬È»ºó°²×°Ò»¸öеÄmysql£¬Ê¹ÓÃÁËеĶ˿ںͷþÎñÃû£¬
°²×°×îºóÒ»²½Ìáʾ“Error Nr. 1045 ......”£¬½øÈëMySQL Comm ......
CREATE TABLE `user` (
`db_id` varchar(255) NOT NULL,
`name` varchar(45) default NULL,
`age` int(10) unsigned NOT NULL,
`address` varchar(45) default NULL,
PRIMARY KEY (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
// ÉèÖÃname='888'µÄageµÈÓÚname='111' ......
[perl] ÅúÁ¿Ìø¹ýmysql slave´íÎóС½Å±¾
2009Äê02ÔÂ20ÈÕ 16:24
·¢ÏÖmysql slave·þÎñÆ÷¾³£ÒòΪһЩÌØÊâ×Ö·û»òÕß·ûºÅ²úÉúµÄ¸üÐÂÓï¾ä±¨´í£¬Õû¸öͬ²½Ò²»áÒò´Ë¶ø¿¨ÔÚÄÇ£¬×î³õµÄ°ì·¨Ö»ÊÇÊÖ¶¯È¥³ö´íµÄ»úÆ÷£¬Ö´ÐÐÏÂÃæÈýÌõsqlÓï¾ä£¬Ìø¹ý´íÎó¼´¿É¡£
slave stop;
set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
slave start;
һ̨slave»ú ......