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Ö»ÓÐÍâ¼üÔ¼Êø£¬Ã»ÓÐÖµÔ¼Êø¹¦ÄÜ¡£ ÒýÓà ÓÃÔ¼Êø¿ÉÒÔʵÏÖ
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
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. ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿ 1 nike 100 ϵͳʱ¼ä 2 nike 300 &n ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл ½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£ http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......