Linux mysql ÎÊÌâ
bash-2.05b# gcc -o oo oo.c -I /usr/local/mysql/include -L /usr/local/mysql/lib
/tmp/ccEQAkDG.o(.text+0x1f): In function `main':
: undefined reference to `SQLAllocHandle'
/tmp/ccEQAkDG.o(.text+0x58): In function `main':
: undefined reference to `SQLSetEnvAttr'
/tmp/ccEQAkDG.o(.text+0x88): In function `main':
: undefined reference to `SQLFreeHandle'
/tmp/ccEQAkDG.o(.text+0xa1): In function `main':
: undefined reference to `SQLAllocHandle'
/tmp/ccEQAkDG.o(.text+0xd4): In function `main':
: undefined reference to `SQLFreeHandle'
/tmp/ccEQAkDG.o(.text+0xea): In function `main':
: undefined reference to `SQLSetConnectAttr'
/tmp/ccEQAkDG.o(.text+0x10d): In function `main':
: undefined reference to `SQLConnect'
/tmp/ccEQAkDG.o(.text+0x154): In function `main':
: undefined reference to `SQLGetDiagRec'
/tmp/ccEQAkDG.o(.text+0x17e): In function `main':
: undefined reference to `SQLFreeHandle'
/tmp/ccEQAkDG.o(.text+0x1aa): In function `main':
: undefined reference to `SQLAllocHandle'
/tmp/ccEQAkDG.o(.text+0x1f1): In function `main':
: undefined reference to `SQLGetDiagRec'
/tmp/ccEQAkDG.o(.text+0x21b): In function `main':
: undefined reference to `SQLFreeHandle'
/tmp/ccEQAkDG.o(.text+0x245): In function `main':
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÎÒÓÃRPM±¨°²×°ÁËÒ»¸öÀϰ汾µÄJRE£¬ºóÀ´Ïëװа汾µÄ£¬
²»¹ý£¬ÎÒ°Ñ/usr/javaĿ¼ֱ½Ó¸øÉ¾ÁË£¬
ºóÔÙ°²×°µÄʱºò£¬×ÜÊÇÌáʾ°æ±¾³åÍ»£¬
¶øÇÒÎÒÓÃRPM°üÐ¶ÔØÊ±Ò²ÕÒ²»µ½ÎļþÁË¡£
ÎÒ¶ÔLINUX²»ÊìϤ£¬Ï£Íû¸ßÊÖ°ïæ¡£
http: ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......