NETÁ¬½ÓMySQLµÄÎÊÌâ
Èç¹ûmysqlÊý¾Ý¿âµÄ×Ö¶ÎÀàÐÍΪ tinyint(1)
Ϊʲô¶ÁÈ¡³öÀ´µÄ¶¼ÊÇtrue ºÍfalse
ÎÒÊý¾Ý¿âÖÐÓÐ0,1,2°¡
Èç¹ýд0 ¶¼ÊÇfalse;
Èç¹û²»ÊÇд0 (±ÈÈç1,2µÈ) ¾ÍÊÇtrue;
µ«ÊÇÎÒÏëÈ¡³ö0,1,2ÕâЩ¾ßÌåµÄÊý×Ö°¡£¬ Òª×öÅжÏÄêÁäÓÃ
select name,username,hsf.sex,hsf.birthyear from uchome_space as hs inner join uchome_spacefield as hsf on hs.uid = hsf.uid order by hs.credit desc limit 0 ,2;
´ó¼ÒÖªµÀÕâÒªÔõô½â¾öô? ÎÒ¾ÍÕâ¸öhsf.sexÕâ¸ö×Ö¶ÎҪȡµ½ÀïÃæµÄÖµ
×Ö¶ÎÀàÐÍÀàÐÍ ¿ÉÒÔ¸ÄÂ𣿣¿£¿
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ÉÊÇÎÒÕÒ ......