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

MYSQL ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º

SQL code:
update tb_blog set memo=concat('add---',cast(memo as char)) where id=1;


BLOBÊý¾ÝÊÇһЩÓû§ÐÅÏ¢  
  
ÁíÍ⻹ÓÐ1¸öÎÊÌâ:
  select data from table where id='XXX'
  DATAµÄֵΪBLOBÀàÐÍ  
  select hex(data) from table where id='user1' µÃµ½user1µÄHEX DATAÖµ  
  ÎÒÏëÈÃidΪuser2µÄdataÖµ µÈÓÚ user1µÄDATAÖµ 
  ÈçºÎͨ¹ýת»»³ÉHEXµÄ·½Ê½À´ÐÞ¸ÄUSER2µÄÖµ?

ÔõÑù ת»»³ÉHEXÖµµ¼³ö È»ºó½øÐÐÊý¾ÝÖеÄij×Ö·û È»ºóÔÙµ¼Èë?

update table set data=hex(data) where ?

SQL code:
select data into @str from table where id='user1';
update table set data=@str where id='user2';


лл¥ÉϵĴó´ó

  ±à¼­²éѯµÃµ½µÄBLOBÖµ ¿ÉÒÔͨ¹ýʲô·½Ê½ÐÞ¸Ä? 
  16½øÖÆ »¹ÊÇÖ±½ÓÐÞ¸Ä?


ÒýÓÃ
ʹÓÃmysql_real_query¶ø²»ÊÇmysql_query£¬²¢ÇÒ¶þ½øÖÆÊý¾ÝÒª×öתÒå
ÓÐÁ½ÖÖ·½·¨£º
·½·¨Ò»
1¡¢Í¨¹ýmysql_real_escape_string°Ñ¶þ½øÖÆÊý¾ÝתÒå¡£
2¡¢¹¹ÔìsqlÓï¾ä£¬°ÑתÒåºóµÄ¶þ½øÖÆÊý¾Ýµ±³É×


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MysqlÁ¬½Óoracle

ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ

oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó

ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬

ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ