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

ÈçºÎÖ´ÐÐÒ»¸ömysqlµÄsql½Å±¾Îļþ


2009-12-08 18:53
sql½Å±¾Êǰüº¬Ò»µ½¶à¸ösqlÃüÁîµÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ½«ÕâЩsql½Å±¾·ÅÔÚÒ»¸öÎı¾ÎļþÖУ¨ÎÒÃdzÆÖ®Îª“sql½Å±¾Îļþ”£©£¬È»ºóͨ¹ýÏà¹ØµÄÃüÁîÖ´ÐÐÕâ¸ösql½Å±¾Îļþ¡£»ù±¾²½ÖèÈçÏ£º
1¡¢´´½¨°üº¬sqlÃüÁîµÄsql½Å±¾Îļþ
ÎļþÖаüº¬Ò»Ð©ÁеÄsqlÓï¾ä£¬Ã¿ÌõÓï¾ä×îºóÒÔ;½á⣬ÎļþÄÚÈÝʾÀýÈçÏ£º
--´´½¨±í£¬Ê¹ÓÓ--”½øÐÐ×¢ÊÍ
create table ±íÃû³Æ
(                   
Guid Varchar(38) not null primary key, 
Title Varchar(255),       
              
) TYPE=InnoDB;
--ÔÚ±íAÖÐÔö¼Ó×Ö¶ÎStatus
alter table A add Status TinyInt default '0';
--ÔÚ±íAÉÏ´´½¨Ë÷Òý
create index XX_TaskId_1 on A(Id_);
--ÔÚA±íÖÐÌí¼ÓÒ»Ìõ¼Ç¼
Insert into A (Id,ParentId, Name) values(1,0,'Ãû³Æ');
--Ìí¼Ó¡¢Ð޸ġ¢É¾³ýÊý¾Ýºó£¬ÓпÉÄÜÐèÒªÌá½»ÊÂÎñ
Commit;
2¡¢Ö´ÐÐsql½Å±¾Îļþ
·½·¨Ò» Ê¹ÓÃdosÃüÁîÖ´ÐÐ(windowsÏ£¬unix»òlinuxÔÚµÄÆä¿ØÖÆÌ¨ÏÂ)
¡¾MysqlµÄbinĿ¼¡¿\mysql –uÓû§Ãû –pÃÜÂë –DÊý¾Ý¿â<¡¾sql½Å±¾Îļþ·¾¶È«Ãû¡¿£¬Ê¾Àý£º
D:\mysql\bin\mysql –uroot –p123456 -Dtest<d:\test\ss.sql
×¢Ò⣺
A¡¢Èç¹ûÔÚsql½Å±¾ÎļþÖÐʹÓÃÁËuse Êý¾Ý¿â£¬Ôò-DÊý¾Ý¿âÑ¡Ïî¿ÉÒÔºöÂÔ
B¡¢Èç¹û¡¾MysqlµÄbinĿ¼¡¿Öаüº¬¿Õ¸ñ£¬ÔòÐèҪʹÓÓ”°üº¬£¬È磺“C:\Program Files\mysql\bin\mysql” –uÓû§Ãû –pÃÜÂë –DÊý¾Ý¿â<¡¾sql½Å±¾Îļþ·¾¶È«Ãû¡¿
·½·¨¶þ ½øÈëmysqlµÄ¿ØÖÆÌ¨ºó£¬Ê¹ÓÃsourceÃüÁîÖ´ÐÐ
Mysql>source ¡¾sql½Å±¾ÎļþµÄ·¾¶È«Ãû¡¿
ת×Ô£ºhttp://hi.baidu.com/tangmingjie85/blog/item/01670d0395159c0c1c95834e.html


Ïà¹ØÎĵµ£º

SQL SERVERÃüÁî´óÈ«£¨ÖµµÃѧϰµÄ¶«Î÷£©

ÒýÓÃ
show me µÄ SQL SERVERÃüÁî´óÈ«£¨ÖµµÃѧϰµÄ¶«Î÷£©
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER T ......

sys.identity_columns (sql server 2005)

sys.identity_columns
ÓÃ×÷±êʶÁеÄÿÁж¼ÔÚ±íÖÐÕ¼Ò»ÐС£
ÁÐÃû Êý¾ÝÀàÐÍ ËµÃ÷
<´Ó sys.columns ¼Ì³ÐµÄÁÐ>
ÓйشËÊÓͼËù¼Ì³ÐÁеÄÁÐ±í£¬Çë²ÎÔÄ sys.columns
seed_value
sql_variant
¸Ã±êʶÁеÄÖÖ×ÓÖµ¡£ÖÖ×ÓÖµµÄÊý¾ÝÀàÐÍÓëÁб¾ÉíµÄÊý¾ÝÀàÐÍÏàͬ¡£
increment_value
sql_variant
¸Ã±êʶÁеÄÔöÁ¿Öµ¡£ÖÖ×ÓÖµµÄÊ ......

ÓÃInstallAnywhere´ò°üJava³ÌÐò°üº¬MySQLÊý¾Ý¿â

ÓÃInstallAnywhere´ò°üJava³ÌÐò°üº¬MySQLÊý¾Ý¿â
 
InstallAnywhere´ò°üJava³ÌÐòʱ¿ÉÒÔ×Ô¶¯Íê³ÉjreµÄ´ò°ü£¬µ«ÊÇÐèÒªMySQLÊý¾Ý¿âµÄ³ÌÐò¾ÍµÃÊÖ¶¯Ìí¼Ó¡£×ÊÁÏÌ«ÉÙ£¬¾À½áÁËÈýÌ죬ÖÕÓÚ½â¾ö
 
1¡¢  ÏÂÔØÂÌÉ«°æµÄMySQL£¬¿ÉÒÔÈ¥¹ÙÍøÏÂÔØ¡£ÍøÓÑÖÆ×÷ÁËMySQLµÄÂÌÉ«¾«¼òBat°æ£¨http://download.csdn.net/source/524812 ......

ubuntuϸü¸ÄmysqlĬÈϱàÂë(×Ö·û¼¯)

 
°²×°mysql
sudo apt-get install mysql-server #Ö±½Ó×Ô¶¯»ñµÃ¿ÉÓð汾
Ò²¿ÉÒÔÕâÑùд
sudo apt-get install mysql-server-5.0 #°²×°mysql·þÎñÆ÷5.0°æ±¾
°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄm ......

´´½¨oracle·ÃÎÊmysqlµÄÊý¾ÝÁ´Â·²½Öè

(1)µÇ½µ½mysql
C:\Documents and Settings\Administrator>mysql -h localhost -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' fo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ