Á´½ÓmysqlʱBDEÈçºÎÉèÖã¿
֮ǰoracleÊý¾Ý¿âµÄʱºòÓõÄÊÇ
dm->database->Session->AddAlias(sDbIp,"ORACLE",slBDEConfig);
ÏÖÔÚÊý¾Ý¿â»»×÷mysql,ÓõÄODBCµÄ·½Ê½...
֮ǰÐÞ¸ÄÆäËû´úÂëµÄʱºòÊÇÖ±½ÓÔÚdatabase¿Ø¼þÀïµÄAliasNameÏÂÀ¿òÖÐÖ±½ÓÑ¡ÖеÄmysqlÊý¾Ý¿â(Ãû×Ö½Ð×ötest)
¿ÉÒÔʹÓÃ...
ÏÖÔÚÐÞ¸ÄÍê±Ï,Ï£Íûͨ¹ý½çÃæÒ²¿ÉÒÔÅäÖÃÊý¾Ý¿â,Ò²¾ÍÐèÒª¶¯Ì¬µÄÐÞ¸ÄdatabaseµÄÄÚÈÝ
ÄÇÓ¦¸ÃÈçºÎÐÞ¸ÄÄØ?
dm->database->Session->AddAlias("test","MySQL ODBC 5.1 Driver",slBDEConfig);
ÕâÑù»á±¨´í...ÎÊÏÂmysqlµÄÊý¾Ý¿â,BDE¸ÃÈçºÎÉèÖÃÄØ?
°¡ ·¢´íÁË...= =
°æÖ÷¸ø¸ÄÏÂСÂÛ̳°É.¡£¡£¡£
ÊÇÒòΪMySQLµÄAliasÅäÖúÍOracleÓÐʲô²»Ò»Ñùô£¿
»¹ÊÇ˵ҪÏÈAddDriver²Å¿ÉÒÔ£¿
ÎÊÌâ¸ã¶¨ÁË...
Ó¦¸ÃModifyµÄʱºòȱAddÁË
É¢·ÖÁË...
²»ºÃÒâ˼£¬À´½Ó·ÖÁË
jf
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
mysql>create book(
->id varchar(20) not null,g
->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......
½¨±í£º²å¼Ç¼
SQL code:
create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......