mysqlÔ¶³Ì·ÃÎÊ´ÎÊýÏÞÖÆÎÊÌ⣿£¿£¿
ÔÚ±¾µØ²åÈëÊý¾Ý¿âÖУ¬ÎÒÔËÐÐ5000´Î²åÈëÖм䲻»á³öÏÖÎÊÌ⣬µ«ÊÇÈç¹ûÊÇ»»³ÉÔ¶³Ì¿ØÖƲåÈëÊý¾Ý¿â£¬ÔòÖ»ÄÜÔËÐе½1316´ÎµÄʱºò¾ÍÌáʾ²»Äܽ¨Á¢Á¬½ÓÁË¡£ÇëÎÊÊÇʲôÔÒò£¿ÔõôÉèÖÃmysql???ÇëÀÏʦָµãһϡ£
Ìáʾʲô´íÎóÐÅÏ¢
MY¡£INIÖеÄÄÚÈÝ
ÔõôÐ޸ģ¿
ÀÏʦ ÎÒ¶¼¹Ø±ÕÁ˰¡¡£Ö»ÒªnewÁ˵ıäÁ¿¶¼È«²¿ÊÍ·ÅÁË¡£
void DBDialog::Test()
{
m_comboBox3->Append( wxT("TXT.txt") );
m_comboBox3->SetSelection(0);
wxDbConnectInf *DbConnectInf = NULL; // ¶¨ÒåÊý¾Ý¿âÁ¬½ÓÐÅÏ¢Ö¸ÕëDB connection information
wxDb *Conn = NULL; // ¶¨ÒåÊý¾Ý¿âÁ¬½ÓÖ¸ÕëDatabase connection
wxDbTable *table = NULL; // ¶¨ÒåÊý¾Ý±íÖ¸ÕëData table to mysql
DbConnectInf = new wxDbConnectInf(0, wxT(""), wxT(""), wxT(""));//ÕâÀﶨÒåµÄÄÚÈÝ»ù±¾Ã»Ó㬵«²»¶¨Òå»á±¨´í
Conn = new wxDb(DbConnectInf->GetHenv());
bool DBfailOnDataTypeUnsupported=!true;//
if(!Conn->Open(wxT("driver={mysql odbc 5.1 driver};server=192.168.100.13;DSN=icdata_db;charset=gb2312;database=icdata_db;uid=root;pwd=duangexin;port=3306;"),DBfailOnDataTypeUnsupported))//ʹÓÃÇý¶¯³ÌÐòµÄ·½Ê½´ò¿ªÊý¾Ý¿â
{
wxMessageBox("²»Äܽ¨Á¢Á¬½Ó!","DB CONNECTI
Ïà¹ØÎÊ´ð£º
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......