SQL*PlusµÄ³£ÓÃÃüÁî
Á¬½ÓÃüÁî
1.CONNECT(CONN)£º½¨Á¢Óû§Á¬½Ó
Óï·¨£ºCONNECT [USERNAME]/[password][@connect_identifier]
²ÎÊý£ºUSERNAME£ºÓû§Ãû£» password£ºÃÜÂ룻 connect_identifier£ºÊý¾Ý¿âʵÀýÃû
ÀýÈ磺CONNECT scott/tiger@ORCL
×¢Ò⣺Èç¹ûÒªÒÔÌØȨÓû§Éí·ÝÁ¬½Ó£¬Ôò±ØÐë´ø£ºAS SYSDBA »ò AS SYSOPERÑ¡Ï
ÀýÈ磺CONNECT sys/tiger@ORCL AS SYSDBA
2.DISCONNECT£º¶Ï¿ªÓëÊý¾Ý¿âÁ¬½Ó£¬²»Í˳öSQL*Plus»·¾³
±à¼ÃüÁî
1.ÊäÈ룺ÃüÁîÊäÈëÍê³ÉºóµÄ3ÖÖ´¦Àí·½Ê½£º“£»enter” “enter£¬enter” “/”
“£»enter”£ºÁ¢¼´Ö´ÐиÃÐÐÃüÁî
“enter£¬enter”£º½áÊøSQLµ«²»Ö´ÐиÃÓï¾ä
“/”£ºÓï¾äÊäÈëÍêºó£¬»Ø³µ£¬°´“/”»Ø³µ£¬Á¢¼´Ö´ÐÐÓï¾ä
2.LIST£ºÏÔʾ»º³åÇøµÄÄÚÈÝ
3.±à¼»º³åÇø
APPEND£º½«Öƶ¨µÄÎı¾×·¼Óµ½»º³åÇøµ±Ç°ÐеÄĩβ
CHANGE£ºÐ޸Ļº³åÇøÖе±Ç°ÐеÄÎı¾
DEL£ºÉ¾³ý»º³åÇøÖе±Ç°ÐеÄÎı¾
N£ºÓÃÊýÖµ¶¨Î»»º³åÇøÖеĵ±Ç°ÐÐ
INPUT£ºÔÚ»º³åÇøµ±Ç°ÐеĺóÃæÐÂÔö¼ÓÒ»ÐÐÎı¾
EDIT£ºÒÔÎı¾±à¼Æ÷·½Ê½´ò¿ª»º³åÇø£¬½øÐбà¼
4.Ö´Ðлº³åÇø
RUN»ò/£ºÖ´Ðлº³åÇøÖеÄSQLÓï¾ä»òPL/SQL³ÌÐò
5.Çå³þ»º³åÇø
CLEAR BUFFER£ºÇå³þ»º³åÇøÖеÄÄÚÈÝ
Ïà¹ØÎĵµ£º
select *
from
(select [id]=row_number() over (order by getdate()),
date=convert(varchar(8),dateadd(dd,number,'2010-01-01'),112)
from
(select number from master..spt ......
if exists(select * from sysobjects where name='atzk')--ÅжÏÊÇ·ñ´æÔڴ˱í
drop table atzk
go
create table atzk
(
nid int identity(1,1) primary key,--nid×Ô¶¯±àºÅ£¬²¢ÉèΪÖ÷¼ü¡£
mytitle varchar(50) not null,--֪ͨµÄ±êÌâ¡£
mycontents varchar(200)--·¢²¼Í¨ÖªµÄÄÚÈÝ¡£
) ......
ÈÕÖ¾ÐòÁбàºÅ(LSN)ÊÇÊÂÎñÈÕÖ¾ÀïÃæÿÌõ¼Ç¼µÄ±àºÅ¡£
µ±ÄãÖ´ÐÐÒ»´Î±¸·Ýʱ£¬Ò»Ð©LSNÖµ¾Í±»Í¬Ê±´æ´¢ÔÚÎļþ±¾Éí¼°msdb..backupset±íÖС£Äã¿ÉÒÔʹÓÃRESTORE HEADERONLYÓï·¨À´´Ó±¸·ÝÎļþÖлñÈ¡LSNÖµ¡£
×¢Ò⣺ÔÚSQL Server 2000ÖУ¬ÓÐÒ»ÁнÐ×öDifferentialBaseLSN¡£µ«ÔÚSQL Server 2005ÖУ¬ÏàͬµÄÁÐÃû³Æ±ä³ÉÁËData ......
֮ǰûÔõôÑо¿¹ýMySQLµÄÈÝÁ¿£¬ÓÉÓÚÏîÄ¿ÐèÒª£¬ÐèÒªÒ»¸öÃâ·ÑµÄ¿ÉÒÔÖ§³ÖǧÍòÌõÊý¾Ý¼¶ÒÔÉϵÄÊý¾Ý¿â£¬²é¿´ÏÂmysqlµÄÎĵµ£¬·¢ÏÂmysql»¹ÊǺÜÇ¿´óµÄ£¬¼Ç¼Ï£¬ºÇºÇ¡£ÔÎÄÈçÏ£º
MySQL 3.22ÏÞÖƵıí´óСΪ4GB¡£ÓÉÓÚÔÚMySQL 3.23ÖÐʹÓÃÁËMyISAM´æ´¢ÒýÇ棬×î´ó±í³ß´çÔö¼Óµ½ÁË65536TB£¨2567 –1×Ö½Ú£©¡£ÓÉÓÚÔÊÐíµÄ±í³ß´ç¸ü´ ......
SQL ServerµÄ¸´ºÏË÷Òýѧϰ
¸ÅÒª
ʲôÊǵ¥Ò»Ë÷Òý,ʲôÓÖÊǸ´ºÏË÷ÒýÄØ? ºÎʱн¨¸´ºÏË÷Òý£¬¸´ºÏË÷ÒýÓÖÐèҪעÒâЩʲôÄØ£¿±¾ÆªÎÄÕÂÖ÷ÒªÊǶÔÍøÉÏһЩÌÖÂÛµÄ×ܽᡣ
Ò».¸ÅÄî
µ¥Ò»Ë÷ÒýÊÇÖ¸Ë÷ÒýÁÐΪһÁеÄÇé¿ö,¼´Ð½¨Ë÷ÒýµÄÓï¾äֻʵʩÔÚÒ»ÁÐÉÏ¡£
Óû§¿ÉÒÔÔÚ¶à¸öÁÐÉϽ¨Á¢Ë÷Òý£¬ÕâÖÖË÷Òý½Ð×ö¸´ºÏË÷Òý(×éºÏË÷Òý)¡£¸´ºÏË÷ÒýµÄ´´½¨· ......