Mysql°²×°¿¨×¡ÁË
ÎÒÒѾ°²×°ÁË10´ÎÁË
¿ÉÊÇ»¹ÊÇÿ´Î°²×°µ½×îºóÒ»²½µÄʱºò¾Í¿¨×¡ÁË
°²×°µ½×îºóʱÓÐËĸöÌáʾ£º
µ«ÊÇ£¬Ã¿´Î¶¼Ö»ÓÐÇ°ÃæÁ½¸ö¿ÉÒÔͨ¹ý£¬Ò»µ½µÚÈý¸ö¾Í¿¨×¡ÁË
Prepare configuration
Write configuration file(my.iniµÄ·¾¶)
Start service
Apply security settings
ÕâÊÇΪʲô°¡£¿
СµÜµÄµçÄÔÉÏÃæÒѾ°²×°ÁËSQL2000,SQL2005
СµÜµÄÊÇxp sp3µÄ ²»¹ýÒѾÏÂÁËÃâ°²×°°æµÄÁË ¸ã¶¨ÁË
¾ÍÊÇMYSQLûÓÐͼÐνçÃæ£¬Óе㲻̫ϰ¹ß£¬ÓÃMSSQLÓÃϰ¹ßÁË
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ÏñoracleµÄ·µ»ØÖµÊÇsqlcode£¬
mysqlÓзµ»ØÖµÃ´£¿Âé·³ÄÄλ¸æËßһϡ£
°ï¶¥ MYSQL½¨ÒéÈ¥ÆäËûÊý¾Ý¿â¿ª·¢°æ¿é
mysqlÓзµ»ØÖµÃ´£¿
---
ÎÒÖªµÀmssqlÓУ¬@@error
²»ÖªµÀÓÐûÓÐÀàË ......