Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

MySQL°²×°ÎÊÌ⣡

³õ´Î°²×°µÄʱºòûÎÊÌ⣬µ«ÊÇÒ»²»Ð¡ÐÄÖØ×°ÏµÍ³ÁË£¬Ôٴΰ²×°MySQLµÄʱºò£¬µ½start serviceµÄʱºò¾Í²»ÐÐÁË£¬°²×°²»³É¹¦£¡
ÎҰѰ²×°ÎļþʲôµÄ¶¼É¾ÍêÁË£¬×¢²á±íÀïµÄҲɾÁË£¬µ«ÊÇ»¹ÊÇ×°²»³É¹¦£¡µ½ÏÖÔÚ»¹Ã»ÕÒµ½½â¾öµÄ·½·¨£¬Çë½Ì£¡
Ìáʾʲô´íÎó£¿

Â¥Ö÷£¬Çë°Ñ°²×°²»ÉϵĴíÎóÌáʾ

  Ìù³öÀ´£¬·ñÔòÎÒÃÇÎÞ·¨°ïÖúÄã ......

mysqlÎÊÌâÇóÖú

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Êý¾Ýͬ²½ÎÊÌâÇóÖú

Óà mysql ×öË«Ïòͬ²½ ³öÏÖÁËÒ»µãÎÊÌâ ¾ßÌåÇé¿öÈçÏÂ
A »ú ºÍ B»ú ×öË«Ïòͬ²½
µ± A»ú¸üÐÂÊý¾Ýʱ B»ú»áͬ²½¸üÐÂ
µ«ÊÇ µ± ¶ÏÍøÁË AB»ú ²»ÄÜÁ¬Í¬µÄÇé¿öÏ ·Ö±ðÔÚ A»ú ºÍ B»ú ²Ù×÷Êý¾Ý¿â
¹ýÒ»»á ÍøÂç»Ö¸´ £¬ÔÚ¶ÏÍøÇé¿öÏ ²Ù×÷µÄÊý¾Ý ²»»áͬ²½µ½

ºóÀ´µ÷Á˰ëÌì ³öÏÖÁËÁíÒ»ÖÖÇé¿ö ¾ÍÊÇ ¶ÏÍøºó²Ù×÷µÄÊý¾Ý  A» ......

MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
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- ......

MysqlÁ¬½ÓÎÊÌ⣬ÎÒÓÐÏëײǽµÄ¸Ð¾õ¡£¡£¡£

ÏÈл¹ý½øÀ´¿´µÄͬºÃ£¬¼òµ¥µÄ˵£¬ÎÒÒ»¿ªÊ¼ÊDZ¨´í£¨no suitable Driver£©£¬¾­¹ýÎÒµÄÄÍÐĽ̵¼ºÍÑ­Ñ­ÉÆÓÕ£¬ÎÒµÄEclipseÏÖÔÚÖ±½ÓÁÌÌô×Óß·¡£¡£¡£

Java code:

import java.sql.*;
public class myConn {
/**
* @param args
* @throws IllegalAccessException
* @throws InstantiationExceptio ......

Á´½ÓMySQL¶ÁÈ¡Êý¾Ý£¬ÖÐÎͼ±ä³ÉÂÒÂëÁË£¿

ÎÒÊdzõѧ my sql £¬ÓÃHibernateÁ¬½ÓÊý¾Ý¿âÖ®ºó£¬¶ÁÈ¡³öÀ´µÄÊý¾Ý£¬ÖÐÎͼ±ä³ÉÁËÂÒÂ룬Ôõô×öת»¯°¡£¿ÎÒдÁ˸ö¹ýÂËÆ÷£¬µ«ÊÇ»¹ÊDz»Ðа¡¡£
Çó¸÷λ´óÏÀÁË¡­¡­Èç¹ûÓÐЧ¹û¸ßµÄ¹ýÂËÆ÷£¬ÄܸøÎÒÔ´´úÂëÂð£¿
ÓÐÇëPÁº

ÊÔÏ£ºset names 'utf8'

»ò¿´Ï°ßÖñµÄÌû×Ó£º

http://blog.csdn.net/ACMAIN_CHM/archive/ ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [3590] [3591] [3592] [3593] 3594 [3595] [3596] [3597] [3598] [3599]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ