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

hibernate mysqlÓ³ÉäÀàÐÍ

 
integer »òÕß int
int »òÕß java.lang.Integer
INTEGER
4 ×Ö½Ú
long
long  Long
BIGINT
8 ×Ö½Ú
short
short  Short
SMALLINT
2 ×Ö½Ú
byte
byte  Byte
TINYINT
1 ×Ö½Ú
float
float  Float
FLOAT
4 ×Ö½Ú
double
double  Double
DOUBLE
8 ×Ö½Ú
big_decimal
java.math.BigDecimal
NUMERIC
NUMERIC(8,2)8 λ
character
char  Character  String
CHAR(1)
¶¨³¤×Ö·û
string
String
VARCHAR
±ä³¤×Ö·û´®
boolean
boolean  Boolean
BIT
²¼¶ûÀàÐÍ
yes_no
boolean  Boolean
CHAR(1) (Y-N)
²¼¶ûÀàÐÍ
true_false
boolean  Boolean
CHAR(1) (T-F)
²¼¶ûÀàÐÍ
 
2 ¡¢ Java ʱ¼äºÍÈÕÆÚÀàÐ굀 Hibernate Ó³Éä
Ó³ÉäÀàÐÍ
Java ÀàÐÍ
±ê×¼ SQL ÀàÐÍ
ÃèÊö
date
util.Date »òÕß sql.Date
DATE
YYYY-MM-DD
time
Date    Time
TIME
HH:MM:SS
timestamp
Date   Timestamp
TIMESTAMP
YYYYMMDDHHMMSS
calendar
calendar
TIMESTAMP
YYYYMMDDHHMMSS
calendar_date
calendar
DATE
YYYY-MM-DD
 
3 ¡¢ Java ´ó¶ÔÏóÀàÐ굀 Hibernate Ó³ÉäÀàÐÍ
Ó³ÉäÀàÐÍ
Java ÀàÐÍ
±ê×¼ SQL ÀàÐÍ
MySQL ÀàÐÍ
Oracle ÀàÐÍ
binary
byte[]
VARBINARY( »ò BLOB)
BLOB
BLOB
text
String
CLOB
TEXT
CLOB
serializable
Serializable ½Ó¿ÚÈÎÒâʵÏÖÀà
VARBINARY( »ò BLOB)
BLOB
BLOB
clob
java.sql.Clob
CLOB
TEXT
CLOB
blob
java.sql.Blob
BLOB
BLOB
BLOB
 
       ÔÚ³ÌÐòÖÐͨ¹ý Hibernate À´±£´æ java.sql.Clob »òÕß java.sql.Blob ʵÀýʱ£¬±ØÐë°üº¬Á½¸ö²½Ö裺
l         ÔÚÒ»¸öÊý¾Ý¿âÊÂÎñÖÐÏȱ£´æÒ»¸ö¿ÕµÄ Blob »ò Clob ʵÀý¡£
l         ½Ó×ÅËø¶¨ÕâÌõ¼Ç¼£¬¸üÐÂÉÏÃæ±£´æµÄ Blob »ò Clob ʵÀý£¬°Ñ¶þ½øÖÆÊý¾Ý»òÎı¾Êý¾Ýдµ½ Blob »ò Clob ʵÀýÖÐ


Ïà¹ØÎĵµ£º

½«MySQLÖÐsqlÔËÐнá¹û±£´æµ½Îļþ

 ÓÐÁ½ÖÖ·½·¨¡£
·½·¨Ò»£ºÔÚmysql>Ìáʾ·ûÖÐʹÓÃtee
mysql> tee output.txt
Logging to file 'output.txt'
mysql> notee
Outfile disabled.
»òÕß
mysql> \T output.txt
Logging to file 'output.txt'
mysql> \t
Outfile disabled.
Õâ¸öÀàËÆÓÚsqlplusµÄspool¹¦ÄÜ£¬¿ÉÒÔ½«ÃüÁîÐÐÖеĽá¹û±£´æµ½Í ......

mysqlµÄCR_COMMANDS_OUT_OF_SYNC´íÎó

mysqlÖ´ÐÐsqlÓï¾äʱÓÐʱ»á³öÏÖCR_COMMANDS_OUT_OF_SYNC´íÎó£¨2014£©
ÌáʾÓïΪ
commands out of sync; you can't run this command now
ÍøÉ϶Դ˴íÎóµÄÃèÊöºÜÉÙ£¬¶øÇÒûÓиø³ö½â¾ö·½·¨¡£
ÆäʵÕâÊÇÒòΪÉÏÒ»¸ösqlÖ´Ðзµ»ØÁ˶à¸ö½á¹û¼¯£¬µ«Ã»Óаѽá¹û¶¼È¡³öÀ´£¬¾ÍÖ´ÐÐÁËеÄsqlÓï¾ä£¬¾Í»á²úÉúÕâ¸ö´íÎó¡£
Ó¦ÔÚsqlÓï¾äÖ´Ðкó ......

ÈçºÎµ¼Èë.sqlÎļþµ½mysqlÖÐ

ÈçºÎµ¼Èë.sqlÎļþµ½mysqlÖУ¿
C:\mysql\bin>mysql  -u  Óû§Ãû -p  Êý¾Ý¿âÃû  <   c:/test.sql    (source "c:\adsense.sql" )
ÖмäµÄ¿Õ¸ñÊÇÒ»¸ö¿Õ¸ñλ¡£
ͬʱʹÓÃ200¶àMBµÄsqlÎļþ¡£
ÀýÈ磺
C:\Program Files\MySQL\bin>mysql -u root -p myrosz & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ