ÖÕÓÚÕÒµ½Ò»¸ö¿ÉÒÔ½â¾öMySQLÆô¶¯Ê±1067´íÎóµÄ·½·¨ÁË£¡
°²×°ºóMYSQL5ºó£¬·¢ÏÖÆô¶¯³ö´í.
³ö´í´úÂ룺1067
½â¾ö°ì·¨ÈçÏ£º
ɾ³ý%windows%/my.ini
ɾ³ýÆäËüµØ·½µÄmy.ini
ÔÚmysql°²×°Ä¿Â¼Ï°Ñmy-small.ini¸´ÖÆΪmy.ini
ÔÚmy.ini×îºóÒ»ÐвåÈ룺
CODE:
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=C:\mysql-5.1.11-beta-win32
datadir=C:\mysql-5.1.11-beta-win32\data
ÖØÐÂÆô¶¯·þÎñ¡£¡£¡£
CODE:
C:\mysql-5.1.11-beta-win32\bin>net start mysql
MySQL ·þÎñÕýÔÚÆô¶¯ .
MySQL ·þÎñÎÞ·¨Æô¶¯¡£
ϵͳ³ö´í¡£
·¢Éúϵͳ´íÎó 1067¡£
½ø³ÌÒâÍâÖÕÖ¹¡£
C:\mysql-5.1.11-beta-win32\bin>mysqld-nt --remove
Service successfully removed.
C:\mysql-5.1.11-beta-win32\bin>mysqld-nt --install
Service successfully installed.
C:\mysql-5.1.11-beta-win32\bin>net start mysql
MySQL ·þÎñÕýÔÚÆô¶¯ .
MySQL ·þÎñÒѾÆô¶¯³É¹¦¡£
C:\mysql-5.1.11-beta-win32\bin>net stop mysql
MySQL ·þÎñÕýÔÚÍ£Ö¹..
MySQL ·þÎñÒѳɹ¦Í£Ö¹¡£
Ïà¹ØÎĵµ£º
Õë¶Ôselect * from table where col1 > number order by col2 desc¡£
Æäʵ°´ÕÕ³£¹æµÄ·½·¨¿ÉÒÔÕâÑùÉè¼Æ£ºkey(col1, col2)
µ«ÊÇÕâÖÖ°ì·¨ÔÚmysqlÀï²»ËãÊÇÀíÏëµÄ£¬whereÌõ¼þÀïÏÞ¶¨Ë÷ÒýÇ°²¿·ÖÊÇÒ»¸ö·¶Î§µÄÇé¿öϺóÃæµÄorder by»¹ÊÇ»áÓÐfilesort¡£Èç¹ûwhereÌõ¼þÀïÏÞ¶¨Ë÷ÒýÇ°²¿·ÖÊÇÒ»¸ö³£Á¿£¬ÄÇôorder by¾Í»áÓÐЧÀûÓÃË÷Òý¡£À ......
ǰһֱûעÒâÕâÒ»µã£¬Í»È»Ò»ÉÁÄîÏëÆðÀ´£¬ÏÂÃæßëß룺
±È·½ËµÓÐÒ»¸öÎÄÕÂ±í£¬ÎÒÃÇҪʵÏÖij¸öÀà±ðÏ°´Ê±¼äµ¹ÐòÁбíÏÔʾ¹¦ÄÜ£º
SELECT * from articles WHERE category_id = … ORDER BY created DESC LIMIT …
ÕâÑùµÄ²éѯºÜ³£¼û£¬»ù±¾Éϲ»¹ÜʲôӦÓÃÀﶼÄÜÕÒ³öÒ»´ó°ÑÀàËƵÄSQLÀ´£¬Ñ§ÔºÅɵĶÁÕß¿´µ½ÉÏÃæµÄS ......
Èç¹ûÖ»ÊÇÒ»¸öÊý¾Ý¿âµÄ»°£¬ÎÒÃÇÒ»°ãÏ°¹ßÕâÑùд£ºmysql_select_db("guestbook")£»
mysql_query('select * from users');
µ«ÊÇÈç¹ûÊÇÁ¬½Ó¶à¸ömysql£¬ÓпÉÄܳöÏÖͬÃûµÄÊý¾Ý¿â£¬»òÕßÊý¾Ý¿âÖгöÏÖͬÃûµÄ±í£¬ËùÒԾͱØÐëÓÃÍêÕûµÄÐÎʽÁË£¬ÈçÏ´úÂ룺
<?php
$link1 = mysql_connect('localhost1','root','root');
mysql ......
¹²3¸öÎļþ
IncDB.phpÊý¾Ý¿âÁ¬½Ó
index.phpÊ×Ò³
InsetToDB.phpÊý¾Ý¿â²Ù×÷
Êý¾Ý¿âlguestbookÀïÃ潨±í
CREATE TABLE `intd` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set utf8 collate utf8_bin N ......
ÔÚTOMCAϵÄCatalina\localhostĿ¼µÄ¹¤³Ìxml£¬±àдÈçÏ´úÂ룺
<Context path="/testProject" docBase="E:\project\TestProject\WebContent" reloadable="true" debug="0" privileged="true">
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name=" ......