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

mysql ´´½¨¹ØÁª

SQL code:
alter table `test`.`shangpin` add constraint `FK_shangpin_dingdan` FOREIGN KEY (`shangPinID`) REFERENCES `dingdanshangpinxiang` (`shangPinID`) ON UPDATE RESTRICT

±¨´í£º
Can't create table '.\test\#sql-588_2fa.frm' (errno: 150)

±íʲôÒýÇæ¡¢ÊÇ·ñ´æÔÚ¡¢ÊÇ·ñÓмǼ


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySqlÎÊÌâ

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

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

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

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

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 µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ