ÍøÕ¾Ê×Ò³
©¦
¿áÕ¾ÐÀÉÍ
©¦
֪ʶ·ÖÏí
©¦
½ØÍ¼Èí¼þ
©¦
IT×ÊѶ
©¦
ÎĵµÖÐÐÄ
©¦
ÎÊ´ðÖÐÐÄ
©¦
½¡¿µÆµµÀ
ÇóMFCͨ¹ýODBCÁ¬½ÓMYSQLÀý×Ó
RT
ÒýÓÃ
//³õʼ»¯dsn
MyODBC::MyODBC(DataBaseType db_type,const char* driver,const char* dsn,
const char* server,const char* db_name,const char* description,USHORT port)
{
m_erro = 0;
m_row_count = 0;
memset(m_sql_state,0,sizeof(m_sql_state));
memset(m_dsn,0,sizeof(m_dsn));
strncpy(m_dsn,dsn,sizeof(m_dsn) - 1);
m_db_type = db_type;
memset(m_db_name,0,sizeof(m_db_name));
strncpy(m_db_name,db_name,sizeof(m_db_name) - 1);
memset(m_driver,0,sizeof(m_driver));
strncpy(m_driver,driver,sizeof(m_driver) - 1);
memset(m_description,0,sizeof(m_description));
strncpy(m_description,description,sizeof(m_description) - 1);
memset(m_ip,0,sizeof(m_ip));
strncpy(m_ip,server,sizeof(m_ip) - 1);
char szPort[20];
memset(szPort,0,sizeof(szPort));
sprintf(szPort,"%d",port);
m_port = port;
char szAttributes[sizeof(m_dsn) + sizeof(m_ip) + sizeof(m_db_name) + sizeof(m_description) + 1];
memset(szAttributes,0,sizeof(szAttributes));
char* p = szAttributes;
sprintf(szAttributes,"DSN=%s\nServer=%s\nDatabase=%s\nDescription=%s",m_dsn,m_ip,m_db_name,m_description);
PR_DEBUG("this is port:%d\ndriver:%s\nAttributes:\n%s",port,driver,szAttributes);
while( *p )
{
if( *p ==
Ïà¹ØÎÊ´ð£º
c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÐèÒªÊÓÆµ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
MYSQL character_set_server Ôõô¸Ä
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
Sqlserver Óï¾äת³ÉMySqlÓï¾ä
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
¹ØÓÚMYSQLµÄinnodb±í±¸·ÝµÄÎÊÌâ
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
© 2009 ej38.com All Rights Reserved.
¹ØÓÚE½¡Íø
|
ÁªÏµÎÒÃÇ
|
Õ¾µãµØÍ¼
|
¸ÓICP±¸09004571ºÅ