Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql¹ý³ÌÓαê

DELIMITER $$
DROP PROCEDURE IF EXISTS `heli`.`prodtest` $$
CREATE PROCEDURE `heli`.`prodtest` ()
BEGIN
  /*¾Ö²¿±äÁ¿µÄ¶¨Òå declare*/
  declare pid varchar(45) default '';
  declare pq int default 0;
  declare pk double default 0.0;
  declare cur1 CURSOR FOR SELECT product_id,product_quantity,product_kg from productstock;
  /* ÓαêÒì³£ºóÉèÖÃpidΪNULL */
  declare CONTINUE HANDLER FOR SQLSTATE '02000' SET pid = null;
  /*¿ªÓαê*/
     OPEN cur1;
        FETCH cur1 INTO pid,pq,pk;
        WHILE (pid is not null) DO
            /* dosomething */
            select pid,pq,pk;
            FETCH cur1 INTO pid,pq,pk;
        END WHILE;
     CLOSE cur1;
END $$
DELIMITER ;


Ïà¹ØÎĵµ£º

MySQLµÄcµ÷ÓÃ


1. ¸½¼ÓÏîÒ»¶¨ ¼ÓÉÏlibmysql.lib¡£
2. include Ò»¶¨¼ÓÉÏ mysqlµÄinclude£¨ÒòΪҪÅÜÕâ¹Ø¼üÒ»¾ä
#include <mysql.h>£©
3  lib Ò»¶¨¼ÓÉÏ mysqlµÄlib
 
ºÃÁËÏÂÃæÊÇʵÀýºÍphpº¯Êý»ù±¾Ò»ÑùµÄ¡£±¾È˲»¿ÉÄܸøÄã·­ÒëÎĵµ£¬º¯Êý²»¶®×Ô¼º¿´¡£
#include
<windows.h>//ÓÃÕâ¸ö·½±ã£¬°üº¬winsock.hËùÒ ......

mysql on suse linux ϵͳÃüÁî±Ê¼Ç

SLES 11
ÉèÖÃmysql·þÎñ×Ô¶¯Æô¶¯×´Ì¬
chkconfig mysql on
(chkconfig mysql off)
Ìí¼Ó/ɾ³ýmysql·þÎñ
/sbin/chkconfig --del mysql
/sbin/chkconfig --add mysql
²é¿´mysql°æ±¾
mysql -V

mysqld -V
ÆôÍ£ mysql
service mysql start
service mysql stop
service mysql restart
......

MYSQL³£ÓÃÃüÁî


Java´úÂë < width="14" height="15" src="/javascripts/syntaxhighlighter/clipboard_new.swf" pluginspage="http://www.macromedia.com/go/getflashplayer">
//¿´µ±Ç°Ê¹ÓõÄÊÇÄĸöÊý¾Ý¿â  
mysql> SELECT DATABASE();  
+------------+ 
| DATABASE() | 
+------- ......

MySQL µÄǶÌײéѯ

×î½üÔÚMySQLÉÏ×öÁ˵㹤×÷£¬·¢ÏֺܶàÈ˶¼ÔÚѯÎÊMySQLǶÌײéѯµÄÎÊÌ⣬Ðí¶àÈ˶¼¾õµÃMySQL²»Ö§³ÖǶÌײéѯ£¬ÆäʵMySQl´Ó4.11°æºóÒѾ­Íêȫ֧³ÖǶÌײéѯÁË£¬ÄÇôÏÂÃæÎÒ¾ÙЩ¼òµ¥µÄǶÌײéѯµÄÀý×Ó°É£¨Ô´³ÌÐòÀ´×ÔMySQL User Manual£©£º
1. SELECTÓï¾äµÄ×Ó²éѯ:
Óï·¨: SELECT ... from (subquery) AS name ...
ÏÈ´´½¨Ò»¸ö±í:
......

mysqlµ¥»ú¶àʵÀýÔËÐÐʵ¼ù(1)

1.install mysql
get mysql
http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# tar -zxvf mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# cd mysql-5.1.41-linux-i686-icc-glibc23
[root@localhost mysql]# vim RE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ