Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Navicat For MySQL¼òÌåÖÐÎİæ×¢²áÂë

ÏÂÔØµØÖ·£ºhttp://download.csdn.net/down/434743/yuzhongqing2005
Navicat 8 for MySQLµÄ×¢²áÂ룺
PremiumSoft Navicat for MySQL Enterprise Edition v8.XX
ÐÕÃû(Name)£º3ddown.com
×éÖ¯(Organization)£º3ddown.com
×¢²áÂë(Serial)£ºNAVJ-W56S-3YUU-MVHV


Ïà¹ØÎĵµ£º

Mysql´æ´¢¹ý³Ì£¨Î壩——SEQUENCEµÄʵÏÖ

ÔÚ
oracle
ÖУ¬
sequence
Ìṩ¶à±í¶à×ֶοɹ²ÓÃÒ»¸ö²»Öظ´Öµ¡£
Mysql
ÖдæÔÚ×ÔÔöÁУ¬»ù±¾¿ÉÒÔÂú×ã
PK
µÄÒªÇó¡£µ«×ÔÔöÁдæÔÚÏÞÖÆ£º
a.
Ö»ÄÜÓÃÓÚ±íÖеÄÒ»¸ö×ֶΣ¬Ò»ÕŲ»ÄÜͬʱ´æÔÚÁ½¸öÒÔÉϵÄ×ÔÔöÁÐ
;
b.
×ÔÔöÁбØÐë±»¶¨ÒåΪ
key
£¨
PK
»ò
FK
£©
;
c.
×ÔÔöÁв»Äܱ»¶à¸ö±í¹²ÓÃ
;
d.
µ±
insert
Óï¾ä² ......

mysql³£ÓÃÖ¸ÁºÏ


Java´úÂë
mysql> select version(),current_date;   
²éѯmysqlµÄ°æ±¾ºÅ ºÍ  ÈÕÆÚ   
mysql> select version();   
²éѯmysqlµÄ°æ±¾ºÅ   
select now();   
²éѯµ±Ç°ÈÕÆÚºÍ׼ȷµÄʱ¼ä  
Java ......

MysqlµÄÐÐËø»úÖÆ


<!-- [if gte mso 10]>
ÒÔÏÂÄÚÈÝÀ´×ÔÍøÂ磬ÒѲâÊÔ¡£
½áÂÛ£º
mysql
ÐÐËø²»°²È«£¬ËæÊý¾ÝµÄ±ä»¯£¬¿ÉÄÜ»á³öÏÖÐÐËøÎÞЧ£¡Òò´Ë£¬·ÇÈ·¶¨Çé¿öÏ£¬²»Òª¶Ô
mysql
±í¼ÓÐÐËøÀ´¿ØÖÆÒµÎñÂß¼­¡£
ÓÉÓÚÒµÎñÂß¼­µÄÐèÒª£¬±ØÐë¶ÔÊý¾Ý±íµÄÒ»Ðлò¶àÐмÓÈëÐÐËø£¬¾Ù¸ö×î¼òµ¥µÄÀý×Ó£¬Í¼Êé½èÔÄϵͳ¡£¼ÙÉè
id=1
µÄÕâ±¾Êé¿â´æÎª
1
£ ......

MySql °²×°½Ì³Ì ʵ¼

×÷ÕߣºÐûÕ×Åô
--------------------------------------------------------------------------------------------------------------------------------------------
½ñÌìÔÚ±¾±¾Éϰ²×°MYSQL£¬ÔÚ°²×°¹ý³Ì³öÏÖÁËÒ»Ð©Ææ¹ÖµÄÎÊÌ⣬Òò´ËÔÚÕâÀï·ÖÏíÕû¸ö°²×°Á÷³ÌÓë´íÎó½â¾ö·½·¨¡£
MySQL°æ±¾£º5.1.40-community
1¡¢ÏÂÔØ°²×°°ü²¢° ......

tomcat+jdk+mysqlÃâ°²×°µÄÕûºÏÐÎʽ

tomcat+jdk+mysqlÃâ°²×°µÄÕûºÏÐÎʽ
 
Ò»£º tomcat+jdk Ãâ°²×°
ºÜ¾ÃÒÔǰ¾Í¿ªÊ¼Óà tomcat µÄÃâ°²×°°æ(zip ½âѹ°æ)¡£Ö±½ÓÔËÐÐ bin/startup.bat µÄ·½Ê½ÔËÐУ¬ÓÐÒ»¸ö²»ºÃµÄµØ·½¾ÍÊÇ×¢ÏúµÇ¼Óû§³ÌÐò¾ÍÍ˳öÁË¡£±ÈÈç windows 2003 server °æÖÐÔËÐÐ tomcat ÒÔÌṩ¶ÔÍâ·þÎñ£¬ºÜ¿ÉÄܹÜÀíÔ±Æô¶¯ÁË tomcat ºó¾ÍÍ˳ö windows 200 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ