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

mysqlÖÐÔõô²é¿´Ä£Ê½Ä¬ÈϵÄËÑË÷·¾¶search_path°¡

ÎÒÔÚÊéÉÏ¿´µ½ËµÃ¿Ò»¸ö±í¶¼ÊôÓÚijһ¸öģʽ£¬Èç¹ûҪΪ±íÖ¸¶¨Ä£Ê½£¬ÓÐÈýÖÖ·½·¨£º
1£©
ÔÚ´´½¨±íʱÏÔʽµÄ¸ø³öģʽÃû£¬±ÈÈçcreate table "xxx".sno(......);
2£©
ÔÚ´´½¨Ä£Ê½µÄʱºòͬʱ´´½¨±í
3)
Èç¹û´´½¨±íʱûÓÐÖ¸¶¨Ä£Ê½£¬ÄÇôϵͳ»á¸ù¾ÝËÑË÷·¾¶À´È·¶¨¸Ã¶ÔÏóËùÊôµÄģʽ¡£

ʹÓÃÏÂÃæµÄÓï¾ä¿ÉÒÔÏÔʾµ±Ç°µÄËÑË÷·¾¶£º
SHOW search_path;

¿ÉÊÇÎÒÔÚmysqlÀïÃæÊäÈëÕâÌõÃüÁ¾ÓȻ˵ÎÒµÄÓÐÓï·¨´íÎó¡£
°´Àí˵²»Ó¦¸Ã°¡£¬Õâ¸öÊDZê×¼sqlÖ§³ÖµÄÓï¾ä°¡£¬¶øÇÒpostgresqlÒ²Ö§³Ö°¡¡£
ÒýÓÃÕâ¸öÊDZê×¼sqlÖ§³ÖµÄÓï¾ä°¡


ĿǰµÄANSI SQL±ê×¼ÖÐûÓÐÕâ¸ö¡£ÄãµÄ±ê×¼ÊÇÖ¸µÃÄĸö±ê×¼°æ±¾£¿



ÈøÊ¦ìÓµÄÄDZ¾ºìƤµÄ¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·ÖС°¹ØÏµÊý¾Ý¿â±ê×¼ÓïÑÔsql¡±Ò»ÕÂÀïÃæÀï½²µÄ£¬ÀïÃæÃ»ÓÐÉæ¼°µ½¾ßÌåµÄDBMS²úÆ·£¬µ«ÊÇËûҲûÓÐÌáµ½ÊǸù¾ÝµÄÄĸösql±ê×¼°æ±¾¡£

ÒýÓÃ
ÒýÓÃÕâ¸öÊDZê×¼sqlÖ§³ÖµÄÓï¾ä°¡

ĿǰµÄANSI SQL±ê×¼ÖÐûÓÐÕâ¸ö¡£ÄãµÄ±ê×¼ÊÇÖ¸µÃÄĸö±ê×¼°æ±¾£¿



Èç¹ûÊÇÕâÑùµÄ»°£¬mysqlÊÇÔõô´¦ÀíÕâ¸öÎÊÌâµÄÄØ£¿mysqlÊÇÔõô´¦ÀíĬÈϵÄģʽÎÊÌâÄØ£¿

MYSQl µÄsqlmode£¿


ÒýÓÃÈç¹ûÊÇÕâÑùµÄ»°£¬mysqlÊÇÔõô´¦ÀíÕâ¸öÎÊÌâµÄÄØ£¿mysqlÊÇÔõô´¦ÀíĬÈϵÄģʽÎÊÌâÄØ£¿


1¡£ÄãËù˵µÄģʽ£¬SCHEMA£¬ÔÚMYSSQL½ÐDATABASE»òÕßSCHEMA¡£
2¡£MYSQLÖÐûÓÐʲôËÑË÷·¾¶µÄ¸ÅÄÆäËüÊý¾Ý¿âSQL SERVER£¬ORACLEÖÐͬÑùҲûÓУ©
3¡£MYSQLÖÐÈç¹ûÄã²»Ö¸¶¨databaseµÄ»°£¬ÔòÒÔµ±Ç°µ


Ïà¹ØÎÊ´ð£º

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

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

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

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

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

mysql ¼òµ¥ÎÊÌâ

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

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

mysqlÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......

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.
¿ÉÊÇÎÒÕÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ