ÔõôÔÚ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
Ïà¹ØÎÊ´ð£º
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......