ÈçºÎµ¼Èë.sqlÎļþµ½mysqlÖÐ
ÈçºÎµ¼Èë.sqlÎļþµ½mysqlÖУ¿
C:\mysql\bin>mysql -u Óû§Ãû -p Êý¾Ý¿âÃû < c:/test.sql (source "c:\adsense.sql" )
ÖмäµÄ¿Õ¸ñÊÇÒ»¸ö¿Õ¸ñλ¡£
ͬʱʹÓÃ200¶àMBµÄsqlÎļþ¡£
ÀýÈ磺
C:\Program Files\MySQL\bin>mysql -u root -p myrosz < c:/myro.sql
Enter password: ****
¸½£¨PDMתSQL½Å±¾Îļþ£©
pdm×öºÃºó£¬×îÖÕÊÇÒª½«Æäת»¯ÎªÊý¾Ý¿âʵÌåµÄ¡£
1.È·Èϵ±Ç°PowerdesignerÉèÖõÄdbmsÊÇ·ñÕýÈ·,¼´ÊÇ·ñÊÇÎÒÃÇÒªÉú³ÉµÄÊý¾Ý¿âÀàÐÍ£¬ÎÒÔÚÕâÀïʹÓõÄÊÇsqlserver2000:
Powerdesigner->Êý¾Ý¿â->¸ü¸Äµ±Ç°dbms£¬Ñ¡ÔñÄúµÄÊý¾Ý¿âÀàÐÍ¡£
2.ÅäÖÃPowerdesignerÓëÊý¾ÝÔ´µÄÁ¬½Ó
Powerdesigner->Êý¾Ý¿â->ÅäÖÃÁ¬½Ó->Óû§dsn(»òϵͳdsn)->Ñ¡Ôñ¡¢Ìí¼ÓÄúµÄÊý¾ÝÔ´
3.Á¬½Ó
Powerdesigner->Êý¾Ý¿â->Á¬½Ó->ÉèÖúÃÄú¸Õ²Å½¨Á¢µÄdsnÈ·¶¨¡£
OK,ÉèÖúÃÁ¬½ÓºóÎÒÃǾͿÉÒÔ½«pdmÉú³ÉsqlÓï¾äÁË¡£
4.Êý¾Ý¿âÉú³É
Powerdesigner->Êý¾Ý¿â->Éú³ÉÊý¾Ý¿â->ÅäÖúã¨Ä¬ÈϾͿÉÒÔ£©ºóÑ¡ÔñÈ·¶¨¾ÍºÃÁË¡£
Äõ½sql½Å±¾Óï¾ä£¬´ó¼Ò¶¼ÖªµÀÓ¦µ±ÈçºÎ×öÁË°É£¬·Åµ½sql²éѯ·ÖÎöÆ÷ÀïÖ´Ðаɡ£
ÎÄÕÂÀ´Ô´(WEB¿ª·¢¼¼Êõ֪ʶ¿â)£ºhttp://cn-web.com/cnweb/0/468/article/
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Îȹʶø֪У¬×î½üÓÖÓõ½ÁË£¬²Ý²ÝÄÃÀ´ÎÂϰһϣº×ª×Ô http://www.bccn.net/Article/sjk/mysql/jc/200601/3411.html
MySQL¹ÜÀíÔ±Ó¦¸ÃÖªµÀÈçºÎÉèÖÃMySQLÓû§Õ˺ţ¬Ö¸³öÄĸöÓû§¿ÉÒÔÁ¬½Ó·þÎñÆ÷£¬´ÓÄÄÀïÁ¬½Ó£¬Á¬½ÓºóÄÜ×öʲô¡£MySQL
3.22.11¿ªÊ¼ÒýÈëÁ½ÌõÓï¾äʹµÃÕâÏ×÷¸üÈÝÒ××ö£ºGRANTÓï¾ä´´½¨MySQLÓû§²¢Ö¸¶¨ÆäȨÏÞ£¬¶øREV ......
²éѯËÙ¶ÈÂýµÄÔÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
4¡¢ÄÚ´æ²»×ã
5¡¢ÍøÂçËÙ¶ÈÂý
6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó£¨¿ÉÒÔ²ÉÓöà´Î²éѯ£¬ÆäËûµÄ·½·¨½µµÍÊý¾ÝÁ¿£©
7¡¢Ëø»òÕßËÀËø(ÕâÒ²ÊDzé ......
½ñÌìÔÚµçÄÔÉÏ°²×°ÁËVisual Studio 2005£¬ÀïÃæ×Ô´øÁËÒ»¸öSQL Server 2005 Express¡£°²×°Íê³ÉÖ®ºó½øÈëVS£¬Ð½¨Ò»¸öÊý¾Ý¿âÏîÄ¿£¬Ôړн¨Êý¾Ý¿âÒýÓÔһ²½Óöµ½ÁËÆæ¹ÖµÄÎÊÌâ¡£
ÔÚ·þÎñÆ÷ÃûµÄÏÂÀÁбíÀïÃ棬ͨ¹ýµã»÷“ˢД°´Å¥¿ÉÒÔÏÔʾµ±Ç°Í¨¹ýÍøÂç¿ÉÒÔÁ¬½Óµ½µÄÊý¾Ý¿âµÄÐÅÏ¢£¬ÆäÖÐÓÐÎÒµÄÖ÷»ú¡£È»¶ø£¬Ñ¡ÔñÁ ......
¼Ù¶¨±ítbl_name¾ßÓÐÒ»¸öPRIMARY KEY»òUNIQUEË÷Òý£¬±¸·ÝÒ»¸öÊý¾Ý±íµÄ¹ý³ÌÈçÏ£º
1¡¢Ëø¶¨Êý¾Ý±í£¬±ÜÃâÔÚ±¸·Ý¹ý³ÌÖУ¬±í±»¸üÐÂ
mysql>LOCK
TABLES READ tbl_name;
¹ØÓÚ±íµÄËø¶¨µÄÏêϸÐÅÏ¢£¬½«ÔÚÏÂÒ»Õ½éÉÜ¡£
2¡¢µ¼³öÊý¾Ý
mysql>SELECT
* INTO OUTFILE ‘tbl_name.bak’ from tbl_name;
3¡¢½âË ......