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

¸Õ½Ó´¥MYSQL£¬ÏëÎÊÏÂMYSQL°²×°ºó¾ÍÖ»ÓÐÒ»¸öDOS£¿

MYSQL¸úSQLÍêÈ«²»Ò»Ñù£¿³ýÁËÕâ¸öDOS½çÃæµÄ²Ù×÷Í⻹ÓÐÄÇЩ¶«Î÷ÄØ£¿ÒªÕâÑùÈ¥ÅªÄØ£¿
http://topic.csdn.net/u/20080102/22/e3d988a1-f957-4736-a155-03bdd9d267e6.html

¿ÉÒÔװһЩµÚ3·½µÄͼÐι¤¾ß£¬Èç

Toad For MySQL

SQLyog

Navicat

PHPMyAdmin

MySQL-Front


mysqlºÍSQL ServerÊÇÓкܴóµÄ²»Í¬µÄ£¬MySQL°²×°ºó¾ÍÖ»ÄÜÔÚÃüÁîÐвÙ×÷£¬µ«ÊǽüÄêÀ´ÓÐһЩºÃµÄ²å¼þ¿ÉÒÔʵÏÖmysqlµÄWEB·½Ê½²Ù×÷£¬Ïñphpmyadmin¡¢MySQLdumper¡¢Navicat¡¢MySQL GUI Tools¡¢MySQL ODBC ConnectorÕâЩͼÐβÙ×÷¹¤¾ß¶¼ÊDZȽϺÃÓõģ¬Äܹ»ÊµÏÖ¾ÍÏñÉÏÍøÒ»Ñù¹ÜÀíÄãµÄMySQLÊý¾Ý¿âÁË¡£

Èç¹û³õѧµÄ»°£¬½¨Ò黹ÊÇÓÃÕâ¸ö¡°DOS¡±µÄÃüÁîÐй¤¾ß°É.

Äã¿ÉÒÔµ½MYSQLµÄ¹ÙÍøÏÂÔØ http://dev.mysql.com/downloads/gui-tools/5.0.html ͼÐλ¯½çÃæ¡£


Ïà¹ØÎÊ´ð£º

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ÉÏÏÞÎÊÌâ

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

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......

Ò»¸ömysqlµÄÎÊÌâ

ÓÐÒ»¸ö±í mytable ÓÐÏÂÃæ¼¸¸ö×Ö¶Î
id    class(ѧÉú°à¼¶)    studentSex(ѧÉúÐÔ±ð,1ÄÐ2Å®)  studentName(ѧÉúÐÔÃû)

¼ÙÉèÏÖÓÐÊ®¼¸¸ö°à¼¶,
ÎÒÏë»ñµÃ°à¼¶ÖÐÄÐѧÉú×î¶àµÄÈýÌõÏàÓ¦ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ