³õ´Î°²×°µÄʱºòûÎÊÌ⣬µ«ÊÇÒ»²»Ð¡ÐÄÖØ×°ÏµÍ³ÁË£¬Ôٴΰ²×°MySQLµÄʱºò£¬µ½start serviceµÄʱºò¾Í²»ÐÐÁË£¬°²×°²»³É¹¦£¡
ÎҰѰ²×°ÎļþʲôµÄ¶¼É¾ÍêÁË£¬×¢²á±íÀïµÄҲɾÁË£¬µ«ÊÇ»¹ÊÇ×°²»³É¹¦£¡µ½ÏÖÔÚ»¹Ã»ÕÒµ½½â¾öµÄ·½·¨£¬Çë½Ì£¡
Ìáʾʲô´íÎó£¿
Â¥Ö÷£¬Çë°Ñ°²×°²»ÉϵĴíÎóÌáʾ
Ìù³öÀ´£¬·ñÔòÎÒÃÇÎÞ·¨°ïÖúÄã ......
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 ......
ÎÒÊdzõѧ my sql £¬ÓÃHibernateÁ¬½ÓÊý¾Ý¿âÖ®ºó£¬¶ÁÈ¡³öÀ´µÄÊý¾Ý£¬ÖÐÎͼ±ä³ÉÁËÂÒÂ룬Ôõô×öת»¯°¡£¿ÎÒдÁ˸ö¹ýÂËÆ÷£¬µ«ÊÇ»¹ÊDz»Ðа¡¡£
Çó¸÷λ´óÏÀÁË¡¡Èç¹ûÓÐЧ¹û¸ßµÄ¹ýÂËÆ÷£¬ÄܸøÎÒÔ´´úÂëÂð£¿
ÓÐÇëPÁº
ÊÔÏ£ºset names 'utf8'
»ò¿´Ï°ßÖñµÄÌû×Ó£º
http://blog.csdn.net/ACMAIN_CHM/archive/ ......