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

mysql²å²»½øÈ¥ÖÐÎÄÔõôÉèÖã¿

mysql²å²»½øÈ¥ÖÐÎÄÊÇÔõô»ØÊ£¬Ó¦¸ÃÔõôÉèÖã¿
SQL code:

mysql> insert into person values('ºÎ','sss',23,2);
ERROR 1366 (HY000): Incorrect string value: '\xBA\xCE' for column 'firstName' at
row 1


ÓÐÇëPÁº

²»¶®

set names gbk

OKÁË£¬ ллÁË

½øÈëÅäÖ㬵÷³Éutf-8¾Í¿ÉÒÔÁË

set names ....

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

ÒýÓÃ
mysql²å²»½øÈ¥ÖÐÎÄÊÇÔõô»ØÊ£¬Ó¦¸ÃÔõôÉèÖã¿
SQL code
mysql>insertinto personvalues('ºÎ','sss',23,2);
ERROR1366 (HY000): Incorrect string value:'\xBA\xCE'forcolumn'firstName' at
row1


°Ñ×Ö¶ÎÀàÐ͸ÄΪblobÀàÐͼ´¿É


Ïà¹ØÎÊ´ð£º

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

mysqlÄ£ºý²éѯÈçºÎ²éѯÁ½¸ö¹Ø¼ü×Ö

ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿

mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿

ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿



½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö

ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......

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
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ