Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ËùÒ ......

linuxÏÂ×Ô´øµÄmysqlÐ¶ÔØºÍ°²×°

linuxÏ mysql µÄÐ¶ÔØºÍ°²×°
¹Ø¼ü×Ö: linuxÏ mysql µÄÐ¶ÔØºÍ°²×°

Ò»¡¢Ç°ÆÚ×¼±¸£º
    1
.ÓÉÓÚredhat Enterprise 5 ÖÐ×Ô´øÒ»¸ömysqlµÄ°æ±¾£¬Èç¹ûÔÚ°²×°linuxǰδѡÔñmysqlµÄ°²×°´Ë²½¾Í¿ÉÌø¹ý£¬ÒòΪÎÒµ±Ê±°²×°ÁËÏÖÔÚ½«ÆäÐ¶ÔØ
£¬²½ÖèÈçÏ£º
     &nb ......

¡¶PHP Óë MySQL Web ¿ª·¢¡·¶ÁÊé±Ê¼Ç £¨Ò»£©

¸ÅÊö
1.PHP ÊÇʲô£¿
   PHP ÊÇ·þÎñÆ÷¶Ë½âÊ͵Ľű¾ÓïÑÔ£¬ËüÊÇĿǰ×îÁ÷ÐÐµÄ web ±à³ÌÓïÑÔÖ®Ò»¡£  ÔÚÒ»¸ö HTML Ò³ÃæÖпÉÒÔǶÈëPHP´úÂ룬ÕâЩ´úÂëÔÚÿ´ÎÒ³Ãæ·ÃÎÊʱִÐС£PHP ´úÂ뽫ÔÚ Web ·þÎñÆ÷Öб»½âÊͲ¢ÇÒÉú³É HTML»òÕß·ÃÎÊÕß¿´µ½ÆäËûÊä³ö½á¹û¡£
2.My SQL ÊÇʲô£¿
   My SQL ÊÇ»ùÓÚ SQL µÄÍê ......

ÄãÓ¦¸ÃÖªµÀµÄ10¸öMySQL¿Í»§Æô¶¯Ñ¡Ïî

´ó²¿·Ö·þÎñÆ÷¹ÜÀíÔ±ÖªµÀMySQLÊý¾Ý¿â¹ÜÀíϵͳ£¨RDBMS£©ÊǸ߶ÈÁé»îµÄÈí¼þ¿é£¬´øÓз¶Î§¹ãÀ«µÄÆô¶¯Ñ¡Ï¿ÉÒÔÓÃÀ´ÐÞ¸ÄÏà¹ØÐÐΪ¡£È»¶ø£¬´ó²¿·ÖÈËÈ´²»
Çå³þ£¬±ê×¼MySQL¿Í»§¶Ë´øÓÐͬµÈ´óÁ¿µÄÆô¶¯Ñ¡ÏÆäÖÐһЩÔÚÈÕ³£MySQL½»»¥×÷ÓÃÖм«ÎªÓÐÓá£ÕâЩѡÏî±¾Éí²»ÊÇ
“ÃØÃÜ”£¬¶øËüÃÇÖкܶàδ±»Ê¹Óã¬ÉõÖÁÆäÖÐһЩ¿ÉÒÔÏÔÖø ......

mysql³£ÓÃÃüÁî

1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ