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

mylab_sys_exec UDFµ÷ÓÃmysqlÍⲿϵͳÃüÁî(For linux)

ÓÐʱºòΪÁË·½±ã£¬ÀûÓÃevent/triggerµ÷ÓÃϵͳÍⲿÃüÁ¿ÉÒòΪ°²È«ÎÊÌ⣬mysql×ÔÉí²¢Ã»ÓÐÌṩÏà¹ØÃüÁÕâÀïÌṩ¸öµ÷ÓÃϵͳÃüÁîµÄ×Ô¶¨Ò庯Êýmylab_sys_exec
soÎļþÏÂÔØ:mylab_sys_exec.so ( mysql5.1.34 ²âÊÔͨ¹ý)
¼ÓÔØ:
CREATE FUNCTION mylab_sys_exec RETURNS INTEGER SONAME "mylab_sys_exec.so";
ʹÓÃ:
SELECT mylab_sys_exec ('CMD');
Ô´Âë:
my_bool mylab_sys_exec_init (UDF_INIT *initid, UDF_ARGS *args, char *message );
void mylab_sys_exec_deinit (UDF_INIT *initid );
int mylab_sys_exec (UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error );
 
my_bool mylab_sys_exec_init( UDF_INIT *initid, UDF_ARGS *args, char *message )
{
if(args->arg_count == 1 && args->arg_type[0]==STRING_RESULT)
{
return 0;
} else {
strcpy( message, "One string type parameter expected");
return 1;
}
}
void mylab_sys_exec_deinit ( UDF_INIT *initid ){}
int mylab_sys_exec( UDF_INIT *initid , UDF_ARGS *args , char *is_null , char *error)
{
return system (args->args[0]);
}
 
hi.baidu.com/isno
Marco Ivaldi ¼¸ÄêÇ°Ôø¾­·¢±í¹ýÒ»¸ö raptor_udf2.c£¬ÑÝʾÁËÈçºÎÀûÓÃmysql udfÈëÇÖϵͳ£¬µ«ÊÇÕâ¸ömysql udfÒ²ÑÝʾÁËÒ»¸öµ÷ÓÃϵͳÃüÁîµÄ·½Ê½¡£µ«ÊÇÕâÒ»²å¼þĿǰӦ¾­²»ÄܼæÈÝmysql 5.0+£¬Ö÷ÒªÊÇÒѾ­²»·ûºÏеÄmysql udfµÄ¹æ·¶ÁË£¬²¢ÇÒûÓзµ»Ø½á¹û¡£
mysql User-Defined Functions ÊÇ Roland Bouman ¿ª·¢µÄÒ»¸öеĵ÷ÓÃϵͳÃüÁîµÄudf°ü£¬ÆäÖÐÓÐÈý¸öº¯Êý£º
sys_exec: µ÷ÓÃϵͳÃüÁִÐÐÍⲿ³ÌÐò
sys_get: ·µ»ØÏµÍ³»·¾³±äÁ¿µÄÖµ
sys_set: ÉèÖÃϵͳ»·¾³±äÁ¿
ÕâÒ»mysql udf °üÊǼæÈÝmysql 5.0+ £¬Í¬Ê±Ö§³ÖlinuxºÍwindows¡£µ«ÊÇÕâÒ»°üÒ²ÓÐÒ»¸öÎÊÌ⣬ִÐÐÃüÁîºó·µ»ØÊÇÃüÁîµÄexit_code £¬¶ø²»ÊÇÃüÁîµÄÖ´Ðнá¹û¡£
Bernardo Damele A. G. Õë¶ÔÕâÒ»ÎÊÌâ×öÁËÒ»¸ö¸üаü£¬Ôö¼ÓÁËÒ»¸ösys_evalº¯Êý£¬ÕâÒ»º¯ÊýÃüÁîÖ´Ðгɹ¦·µ»ØÖ´Ðнá¹û£¬¶øÈç¹û´íÎó·µ»ØNULL¡£
ÕâÀïÏÂÔØ²¹¶¡£º here
lib_mysqludf_sys version 0.0.2 ÔÚÕâÀïÏÂÔØ here.
ʹÓÃʵÀý£º
$ wget --no-check-certificate https://svn.sqlmap.org/sqlmap/trunk/sqlmap/extra/mysqludfsys/lib_mysqludf_sys_0.0.3.tar.gz
$ tar xfz lib_mysqludf_sys_0.0.3.tar.gz
$ cd lib_mysqludf_sys_0.0.3
$


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì (Æß) SDPЭÒé

Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖЭÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀЭÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......

CentoS5ϱàÒë°²×°mysqlÊý¾Ý¿â

ΪʲôѡÔñÔ´Âë±àÒë°²×°mysql£ºÎÒÔÚʹÓÃrpm»òÕßÊÇyum°²×°Ê±myql£¬ÀÏÊÇÌáʾÎÒÕÒ²»µ½*.sockÎļþ£¬ÕÒÁ˵ã
×ÊÁÏ˵ÊǸðüÊǷǹٷ½°æ±¾£¨Ã÷Ã÷Êǹٷ½ÏÂÔØ µÄ£©£¬ÆäÖÐÔ­Òòµ½ÏÖÔÚ»¹Ã»ÓиãÇå³þ¡£Ï£ÍûÖªÇéÈËÊ¿¸æÖª¡££¨¿ªÊ¼±àÒëµÄʱºò£¬ÏµÍ³»·¾³Ò»¶¨ÒªÅäÖúã¬GCC£¬GC++...µÈµÈµÄ±àÒëÆ÷Ò»¶¨Òª×öºÃ,±¾È˵ÄcentosÓÉÓÚ¿ªÊ¼
ϵͳ»·¾³Ã»ÅäÖ ......

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¸öÔª×éµÄÖ÷¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ