xampp Óë mysql - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒÊDzËÄñ£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
ÎÒµÄmysql rootÃÜÂëÊÇ root
×Ô´Ó°²×°ÁËxamppÖ®ºó£¬Ö±½ÓÔËÐÐMySQL Command Line Client ÊäÈëroot¾Í²»ÄܽøÈëmysql£¬¶ø¿ªÆôxamppÖ®ºó¾Í¿ÉÒÔ¡£²¢ÇҹرÕÁËxamppÖ®ºóÒ²¿ÉÒÔ½øÈëmysqlÁË¡£
Ò²¾ÍÊÇ˵£¬Ã¿´Î¿ª»úÎÒÔÚÔËÐÐmysql֮ǰ±ØÐëÏÈÔËÐÐÒ»´Îxampp¡£ÕâÊÇʲôµÀÀíÄØ£¿
ÄãµÄmysqlÓ¦¸ÃÊÇÓÉxamppÁ¬´øÆô¶¯µÄ.
¿ÉÄÜÊÇ£¬µ«ÊÇÎÒµÄmysql°²×°ÔÚxampp֮ǰ¡£
ÄÇôxampp¸Ä±äÁËmysqlµÄÉèÖá£Æñ²»ÊÇmysql¾Í²»°²È«¡£ÈκÎÈ˶¼¿ÉÒÔͨ¹ý°²×°xampp½øÈëÊý¾Ý¿â¡£
ÕâÑù×Ó£¿ÄÇ¿ÉÄÜÊÇxampp¸Ä¶¯ÁËmysqlµÄÆô¶¯²ÎÊý¡£
Äã´Ó·þÎñÁбíÀï¿´¿´mysql·þÎñµÄÆô¶¯²ÎÊý¡£¿´Ëü¶ÔÓ¦µÄÊÇÄĸöÅäÖÃÎļþ£¿
ÁíÍ⣬ÄãÍêÈ«¿ÉÒÔÊÖ¶¯Æô¶¯mysqlµÄ¡£Ö»ÒªÖªµÀmysqlµÄÅäÖÃÎļþµÄλÖ㨲»ÒªÅª´íÁË)
¶÷£¬Ð»Ð»¡£
{{
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊ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 ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......
¹òÇó½«ÒÔϺ¯Êý·ÒëΪ mysql µÄÓï·¨
CREATE FUNCTION workdayadd(
@date datetime, --»ù´¡ÈÕÆÚ
@workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý
)RETURNS datetime
AS
BEGIN
DEC ......