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

MySql ÅжϺº×Ö¡¢ÈÕÆÚ¡¢Êý×ֵĺ¯Êý

¼¸¸öƽ³£ÓõÄmysqlº¯Êý
/*****************************************************
1.ÅжÏ×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö
*****************************************************/
DROP FUNCTION IF EXISTS fc_is_hanzi;
CREATE FUNCTION  fc_is_hanzi(
p_str VARCHAR(1024)
)
    RETURNS int(11)
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT '¼ì²é×Ö·û´®ÊÇ·ñΪºº×Ö'
BEGIN
/*¼ì²é×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö*/
    DECLARE _ret, i, other_cnt, l_acode INT DEFAULT 0;
    SET _ret = 0;
    SET i = 1;
    SET other_cnt = 0;
    SET l_acode = 0;
    WHILE i <= CHAR_LENGTH(p_str) DO
        SET l_acode = ASCII(SUBSTRING(p_str, i, 1));
        IF  l_acode<124 or l_acode>254 THEN
            SET other_cnt = other_cnt + 1;
        END IF;
        SET i = i + 1;
    END WHILE;
    IF other_cnt = 0 THEN
        SET _ret = 1;
    ELSE
        SET _ret = 0;
    END IF;
    RETURN _ret;
END;
/*****************************************************
2.ÅжÏÈÕÆÚ¸ñʽÊÇ·ñÕýÈ·£¨·µ»ØÖµ£º1-ÕýÈ· 0-´íÎó£©
*****************************************************/
DROP FUNCTION IF EXISTS  fc_ck_date;
CREATE FUNCTION fc_ck_date(
p_cont CHAR(32)  
)
    RETURNS tinyint(4)
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT 'Åж¨ÈÕÆÚ¸ñʽÊÇ·ñÕýÈ·'
BEGIN
/*Åж¨ÈÕÆÚ¸ñʽÊÇ·ñÕýÈ·£¨·µ»ØÖµ£º1-ÕýÈ· 0-´íÎó£©*/
/*ÊäÈëÖµ¸ñʽΪ£ºyyyyMMdd »ò yyyy-MM-dd*/
IF(SELECT DATE_FORMAT(p


Ïà¹ØÎĵµ£º

±È½Ï²»´íµÄmysql²Ù×÷Àà

<?php
/*
 * by:lenush
 * qicq:707207845
 * email:lenus-h@163.com
 * site:www.hackthiswebsite.cn
 * that's all
 *
 */ 
class mysql{
 
 private $db_host;  //Êý¾Ý¿âÖ÷»ú
 private $db_user;  //Êý¾Ý¿âÓû§Ãû
 private $d ......

C#.NETÁ¬½Ómysql·½·¨

Ò»¡£ mysql.data.dll¿½±´µ½binÏÂÃæ²¢ÒýÓÃÒ»ÏÂ
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string myConnectionString ......

MySQLµÄÍâ¼üºÍ²ÎÕÕÍêÕûÐÔ

Ò»¡¢²ÎÕÕÍêÕûÐÔ(Referential integrity)ºÍÍâ¼ü(foreign key)
²ÎÕÕÍêÕûÐÔ(Referential integrity)ÊÇÓÃÓÚÔ¼¶¨Á½¸ö¹ØÏµÖ®¼äµÄÁªÏµ£¬ÀíÂÛÉϹ涨£ºÈôMÊǹØÏµSÖеÄÒ»ÊôÐÔ×飬ÇÒMÊÇÁíÒ»¹ØÏµZµÄÖ÷¹Ø¼ü×Ö£¬Ôò³ÆMΪ¹ØÏµS¶ÔÓ¦¹ØÏµZµÄÍâ¹Ø¼ü×Ö¡£ÈôMÊǹØÏµSµÄÍâ¹Ø¼ü×Ö£¬ÔòSÖÐÿһ¸öÔª×éÔÚMÉϵÄÖµ±ØÐëÊÇ¿ÕÖµ»òÊǶÔÓ¦¹ØÏµZÖÐij¸öÔª×éµÄÖ÷¹ ......

mysqlÖ®Íü¼ÇrootÃÜÂë

Ê×ÏÈ£¬´ò¿ªcmd—–net start ²é¿´mysqlÊÇ·ñÆô¶¯¡£Æô¶¯µÄ»°¾ÍÍ£Ö¹net stop mysql.
1¡¢ÔÚdosÏÂÔËÐÐC:\Program Files\MySQL\MySQL Server 5.0\bin
2¡¢mysqld-nt --init-file=c:\mysql\pwdhf.txt ÆäÖÐÔÚc:\mysql½¨Ò»¸öpwdhf.txtÎļþ£¬²¢Ð´ÏÂÄãµÄÐÂÃÜÂë¡£
3¡¢ÔËÐÐЩÃüÁîºó£¬ÔÙÓÃÐÂÃÜÂëµÇ¼£¬¼´¿É³É¹¦ÐÞ¸ÄÃÜÂë¡£ ......

MySQLÊÖ¼Ç002

1¡¢´´½¨Ò»¸öÊý¾Ý¿â
create database Êý¾Ý¿âÃû
2¡¢´´½¨Ò»¸öÊý¾Ý±í
create table Êý¾Ý±íÃû(
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
......
×Ö¶ÎÃû ÀàÐÍ(³¤¶È)
);
3¡¢²é¿´Êý¾Ý±í½á¹¹
describe Êý¾Ý±íÃû;
4¡¢²åÈëÒ»ÌõмǼ
insert into Êý¾Ý±íÃû values(Öµ1,Öµ2,....Öµn ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ