ÔõôÔÚlinuxϽøÈëmysqlÃüÁîÐУ¿
ÎÒÐèÒª½«Êý¾Ý¿âµÄ±íµ¼³öÀ´£¬ÏÖÔÚ¿âÀïµÄ×Ö·û¼¯ÊÇÂҵģ¬ÎÒÏëÏÈÉèÖÃlatin1¸ñʽµ¼³öÀ´£¬Äܲ»ÄܸæËßÎÒÔõô½øÈëmysqlÃüÁî·ûÏ£¿ºÃÏñÊDZØÐë½øÈëmysqlÃüÁî·ûϲÅÐУ¬ÎÒµÄϵͳÊÇlinux£¬ÎÒÓÃlocate mysql ²éµ½Á˺öàĿ¼£¬²»ÖªµÀmysqlĿ¼ÔÚÄÄ£¬×îºÃÄÜ˵µÄÏêϸµãлл
Ö±½ÓÊäÈëmysqlÃüÁî²»ÐÐÂð£¿
which mysql
/data/mysql/bin/mysql -uroot -p123456
Ç°ÃæÊÇmysqlµÄ°²×°Â·¾¶
-uºóÃæÊÇÓû§Ãû£¬-pºóÃæÊÇimima
²Î¿¼Ò»ÏÂÊÖ²áÖеĽ̳̲¿·Ö¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
ѧϰ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
mysql -u root -p
password
µ½/etc/my.cnfÎļþÀïÈ¥²é¿´Ò»ÏÂÄØ £¿ÕÒ²»µ½¾Ífind / -uname |grep my.cnf
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÔÚ×Ô¼ºµÄµçÄÔÉϰ²×°ÁËubuntu ¾ÍÊÇÏëÍæÒ»ÏÂ3D×ÀÃæ£¬ÓÚÊÇÏÂÔØÁË
compizconfig-settings-manager
emerald
simple-ccsm
fusion
ÕâЩ¶«Î÷£¬°²×°ÍêÖ®ºó£¬ÎÒÔÚµçÄÔÀïµã»÷ÁËemerald ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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 ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......