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

mysql ÓÐûÓÐsqlserverµÄ¡¡¹æÔò¹¦ÄÜ

mysql ÓÐûÓÐsqlserverµÄ¡¡¹æÔò¹¦ÄÜ
±ÈÈçsqlserverµÄ¹æÔòÈçÏÂ
create rule [IsSpecial] as @ in ('y','n')

Ëû¿ÉÒÔÖ¸¶¨×ֶεÄÖµ¡¡µÄ¡¡È¡Öµ·¶Î§
ÓÃÔ¼Êø¿ÉÒÔʵÏÖ

mysql ÖÐûÓÐÕâ¸öRULEµÄ¹¦ÄÜ¡£

²»¹ýÄã¿ÉÒÔʹÓà ENUM ÀàÐÍÀ´ÊµÏÖÀàËÆ¹¦ÄÜ¡£

¸Ðл¥ÉÏ¡¡


ĿǰmysqlÖÐûÓÐÕâ¸ö£¬Äã¿ÉÒÔ°Ñ×ֶεÄÊý¾ÝÀàÐͶ¨ÒåΪenum¾Í¿ÉÒÔʵÏÖÁË
È磺

SQL code:
create table tb_test (id int, flag enum('y','n'));


mysqlÓÐÕýÔò±í´ïʽ
ö¾ÙÀàÐÍ
like×Ö¶Î
ÎÞcheck

mysql 5Ö»ÓÐÍâ¼üÔ¼Êø£¬Ã»ÓÐÖµÔ¼Êø¹¦ÄÜ¡£

ÒýÓÃ
ÓÃÔ¼Êø¿ÉÒÔʵÏÖ



Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysqlÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ