СÌâ´ó×öÖ®MySQL 5.0´æ´¢¹ý³Ì±à³ÌÈëÃÅ
MySQL °æ±¾£º5.0.45 phpMyAdmin°æ±¾£º2.11.3
Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
CREATE
[DEFINER = { user | CURRENT_USER }]
PROCEDURE sp_name ([proc_parameter[,...]])
[characteristic ...] routine_body
proc_parameter:
[ IN | OUT | INOUT ] param_name type
type:
Any valid MySQL data type
characteristic:
LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'
routine_body:
Valid SQL procedure statement
Èç¹ûÄã¶ÔMySQL»¹²»Ì«ÊìϤµÄ»°£¬µ¥µ¥¿´Õâ¸öÓï·¨½á¹¹µ±È»²»×ãÒÔ½øÐÐMySQL´æ´¢¹ý³Ì±à³Ì¡£ÎÒ֮ǰ»ù±¾¶¼ÊÇʹÓÃMS SQL SERVER£¬ËùÒÔÒÔϼǼÎÒÊìϤMySQL´æ´¢¹ý³ÌµÄ¹ý³Ì£¬Ò²ÊÇÖصã½éÉÜMS SQL SERVERÓëMySQLÇø±ð½Ï´óµÄµØ·½¡£
µÚÒ»²½£¬µ±È»ÊÇд¸öHello WordµÄ´æ´¢¹ý³Ì£¬ÈçÏ£º
CREATE PROCEDURE phelloword()
BEGIN
SELECT 'Hello Word!' AS F;
END;
½«ÉÏÃæ´´½¨phelloword´æ´¢¹ý³ÌµÄÓï¾ä¿½µ½phpMyAdminÖÐÖ´ÐУ¬±¨ÈçÏ´íÎó£º
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
ÔÚÕâ¸öÎÊÌâÉÏÎÒ¾À²øÁ˺ܾã¬ÔÚMySQLµÄÃüÁîÐй¤¾ßÖÐÖ´ÐÐͬÑù²»³É¹¦£¬µ«ÊǸù¾ÝÌáʾÐÅÏ¢¿ÉÒÔÖªµÀÖ´ÐÐÔÚ SELECT 'Hello Word!' AS F;´¦½áÊø£¬ºóÃæµÄEND;ûÓÐÖ´ÐУ¬ÕâÏÔÈ»»áµ¼Ö´íÎó¡£
ÕâÀïÐèҪѡÔñÒÔ¸ö·Ö¸ô·û£¬Óï·¨ÈçÏ£ºDELIMITER //
·Ö¸ô·ûÊÇ֪ͨMySQL¿Í»§¶ËÒѾÊäÈëÍê³ÉµÄ·ûºÅ¡£Ò»Ö±¶¼ÊÇÓÓ;”£¬µ«ÊÇÔÚ´æ´¢¹ý³ÌÖв»ÐУ¬ÒòΪ´æ´¢¹ý³ÌÖкܶàÓï¾ä¶¼ÐèÒªÓõ½·ÖºÅ¡£
Òò´ËÉÏÃæµÄ´æ´¢¹ý³Ì¸ÄΪ£º
CREATE PROCEDURE ptest()
BEGIN
SELECT 'Hello Word!' AS F;
END //
ÁíÍâÔÚphpMyAdminÖÐÖ´ÐÐʱ£¬ÔÚDelimiterÎı¾¿òÖÐÌîд //£¬Õâ´Î´æ´¢¹ý³Ì¼´¿É´´½¨³É¹¦¡£
µÚ¶þ²½£¬Ð´Ò»¸ö°üÀ¨²ÎÊý£¬±äÁ¿£¬±äÁ¿¸³Öµ£¬Ìõ¼þÅжϣ¬UPDATEÓï¾ä£¬SELECT·µ»Ø½á¹û¼¯µÄÍêÕûµÄÒ»¸ö´æ´¢¹ý³Ì£¬ÈçÏ£º
CREATE
Ïà¹ØÎĵµ£º
/*²éѯÊý¾Ý¿â*/
show databases;
/*´´½¨Êý¾Ý¿â*/
create database dengheping;
/*ʹÓÃÊý¾Ý¿â*/
use dengheping;
/*´´½¨±í*/
create table user(id int primary key auto_increment,name char(255));
/*²éѯ±í*/
show tables;
/*ÏÔʾ±í½á¹¹*/
desc user;
/*²åÈë×Ö¶Î*/
alter table user add password varchar(6 ......
×î½üÔÚ×öÒ»¸öСÏîÄ¿£¬¿ª·¢»·¾³£ºÊý¾Ý¿âmysql5.0£¬·þÎñÆ÷Tomcat5.5¡£ÏîÄ¿´ò³Éwar²¿ÊðÔÚtomcatÉÏÖ®ºó£¬Í¨¹ýÓ¦ÓýøÐвéѯ²Ù×÷£¬Èç¹û²Ù×÷¹ýÓÚƵ·±£¬ºǫ́»áÅ×ÈçÏÂÒì³££º
javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [08S01]; error co ......
Ò» ÏÂÔØMySQL
http://dev.mysql.com/downloads/mysql/5.0.html
½âѹMySQL£¨F:\Program Files\MySQL\£©MySQL°²×°Ä¿Â¼
¶þ н¨my.ini
ÔÚF:\Program Files\MySQL\Ͻ¨Á¢my.iniÎļþ£¬ÄÚÈÝΪ
my.ini
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=F:\\Program Files\\MySQL
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐ ......
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G ²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊǼà¿ØMYSQL¸´ÖÆij¸ö´Ó·þÎñÆ÷µÄÊä³ö£º
mysql> show slave status\G
*************************** 1. row ***************************
&nbs ......
ת×Ôhttp://blog.csdn.net/ytz_linuxer/archive/2009/07/04/4321259.aspx
ÒÔ°æ±¾phpMyAdmin-2.6.1.tar.gzΪÀý
ÏȽâѹphpMyAdmin-2.6.1.tar.gzµ½/usr/local/apache2/htdocs£¬
µÃµ½Îļþ¼ÐphpMyAdmin-2.6.1£¬½«ÆäÖØÃüÃûΪphpmyadmin,(ÕâÑùÔÚÒÔºóµÄ²Ù×÷Öн«»á±äµÄ¼ò±ã)¡£
  ......