SQL code:
091102 11:03:46 mysqld_safe Starting mysqld daemon with databases from /mysql/data/
091102 11:03:46 [Note] Plugin 'FEDERATED' is disabled.
091102 11:03:46 InnoDB: Started; log sequence number 0 44233
091102 11:03:46 [Note] Event Scheduler: Loaded 0 events
091102 11:03:46 [Note] /m ......
Óà mysql ×öË«Ïòͬ²½ ³öÏÖÁËÒ»µãÎÊÌâ ¾ßÌåÇé¿öÈçÏÂ
A »ú ºÍ B»ú ×öË«Ïòͬ²½
µ± A»ú¸üÐÂÊý¾Ýʱ B»ú»áͬ²½¸üÐÂ
µ«ÊÇ µ± ¶ÏÍøÁË AB»ú ²»ÄÜÁ¬Í¬µÄÇé¿öÏ ·Ö±ðÔÚ A»ú ºÍ B»ú ²Ù×÷Êý¾Ý¿â
¹ýÒ»»á ÍøÂç»Ö¸´ £¬ÔÚ¶ÏÍøÇé¿öÏ ²Ù×÷µÄÊý¾Ý ²»»áͬ²½µ½
ºóÀ´µ÷Á˰ëÌì ³öÏÖÁËÁíÒ»ÖÖÇé¿ö ¾ÍÊÇ ¶ÏÍøºó²Ù×÷µÄÊý¾Ý A» ......
½¨±í£º²å¼Ç¼
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
select 2,'2009-01-02 10:00:00','2009-01-04 10:30:00' union
select 3,'2009-01-03 10:00:00','2009-01- ......
ÏÈл¹ý½øÀ´¿´µÄͬºÃ£¬¼òµ¥µÄ˵£¬ÎÒÒ»¿ªÊ¼ÊDZ¨´í£¨no suitable Driver£©£¬¾¹ýÎÒµÄÄÍÐĽ̵¼ºÍÑÑÉÆÓÕ£¬ÎÒµÄEclipseÏÖÔÚÖ±½ÓÁÌÌô×Óß·¡£¡£¡£
Java code:
import java.sql.*;
public class myConn {
/**
* @param args
* @throws IllegalAccessException
* @throws InstantiationExceptio ......
´úÂëÈçÏÂÇë¸÷λָÕýÒ»ÏÂÄÄÀï³ö´í£¬ÒªÔõô¸Ä£¬Ð»Ð» <?php
header("Content-type: text/vnd.wap.wml;charset=gb2312 \n");
echo(" <?xml version=\"1.0\" encoding=\"gb2312\"?>\n");
echo(" <!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD W ......
ǰ¼¸ÌìÔÚ°³µÄ±¾×ÓÉϰ²×°ÁË
1,MySQL server 5.0
2,MySQL tools for 5.0
3,MySQL Connector\ODBC 3.51
È»ºó½¨Á¢ÁËÃûΪxyxµÄÊý¾Ý¿â£¬ÔÚ¸ÃÊý¾Ý¿âÄÚ½¨ÁËÒ»¸ö±í¸ñdblist,°üº¬ID,NAME,AGEÈýÏîÄÚÈÝ£ººÜ¼òµ¥£¬ÔÝÇÒΪÁËÊìϤһÏÂvcÏ·ÃÎÊÊý¾Ý¿âµÄÒ»°ã¹ý³Ì¡£
£¨1£©½¨Á¢ODBCÊý¾ÝÔ´£¬²âÊÔÁ¬½Ó³É¹¦£¡£¡
£¨2£©½¨Á¢Ò»¸öMFC ......