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 ;
Ïà¹ØÎĵµ£º
1. ¸½¼ÓÏîÒ»¶¨ ¼ÓÉÏlibmysql.lib¡£
2. include Ò»¶¨¼ÓÉÏ mysqlµÄinclude£¨ÒòΪҪÅÜÕâ¹Ø¼üÒ»¾ä
#include <mysql.h>£©
3 lib Ò»¶¨¼ÓÉÏ mysqlµÄlib
ºÃÁËÏÂÃæÊÇʵÀýºÍphpº¯Êý»ù±¾Ò»ÑùµÄ¡£±¾È˲»¿ÉÄܸøÄã·ÒëÎĵµ£¬º¯Êý²»¶®×Ô¼º¿´¡£
#include
<windows.h>//ÓÃÕâ¸ö·½±ã£¬°üº¬winsock.hËùÒ ......
ÒýÓà ҹÂä¹ÅÁú µÄ MySql Administrator µÄ¼òµ¥Ê¹Óã¨Í¼£©
MySQL AdministratorÌṩͼÐνçÃæÒÔ°ïÖúÄã¹ÜÀíMySQLÊý¾Ý¿â£¬WindowsÓû§¿ÉÒÔͨ¹ýÃüÁîÌáʾÐÐÔËÐÐMySQL
Administrator£¬ÔÚÓàÏÂʱ¼äÀïÎÒ¼Ù¶¨ÄãÒѾ°²×°ÁËMySQL Administrator£¬²¢ÇÒ½«Ê¹ÓÃÏà¹ØÍ¼Àý¡£
MySQL
AdministratorÖ÷½çÃæ
¡¡¡¡´´½¨Êý¾Ý¿â
......
¸ÅÊö
1.PHP ÊÇʲô£¿
PHP ÊÇ·þÎñÆ÷¶Ë½âÊ͵Ľű¾ÓïÑÔ£¬ËüÊÇĿǰ×îÁ÷ÐÐµÄ web ±à³ÌÓïÑÔÖ®Ò»¡£ ÔÚÒ»¸ö HTML Ò³ÃæÖпÉÒÔǶÈëPHP´úÂ룬ÕâЩ´úÂëÔÚÿ´ÎÒ³Ãæ·ÃÎÊʱִÐС£PHP ´úÂ뽫ÔÚ Web ·þÎñÆ÷Öб»½âÊͲ¢ÇÒÉú³É HTML»òÕß·ÃÎÊÕß¿´µ½ÆäËûÊä³ö½á¹û¡£
2.My SQL ÊÇʲô£¿
My SQL ÊÇ»ùÓÚ SQL µÄÍê ......
how to install apache, PHP and MySQL on Linux
This tutorial explains the installation of Apache web server, bundled with PHP and MySQL server on a Linux machine. The tutorial is primarily for SuSE 9.2, 9.3, 10.0 & 10.1 operating systems, but most of the steps ought to be valid for all Linux-lik ......
how to install apache, PHP and MySQL on Linux
This tutorial explains the installation of Apache web server, bundled
with PHP and MySQL server on a Linux machine. The tutorial is primarily for SuSE
9.2, 9.3, 10.0 & 10.1, but most of the steps ought to be valid for all
Linux-like operating ......