Interbase/FirebirdµÄSQLÓï·¨(ÊÕ²Ø)
×î½üÔÚȺÀï´ó¼ÒͻȻÌÖÂÛÏÂfb(firebird)À´ÁË£¬ºÇ£¬¿´ÁËһЩ×ÊÁÏ£¬Í»È»·¢¾õÕâ¸ö¶«Î÷Ò²ÂùºÃÍæµÄ£¬ÓÚÊÇ¿ªÊ¼´óÁ¿µÄ²éÕÒÓйصÄ×ÊÁÏ£¬ÏÂÃæÊÇÒ»
ЩfbϵÄsqlд·¨£¬×ª×ÔÍøÉÏ£¬¸÷λÅóÓѽ«¾ÍЩ¿´¿´°É£¬¹ý¼¸ÌìżÕûÀíºÃ.netÏÂʹÓÃfbµÄdemoÉÏÀ´¸ø´ó¼Ò¿´¿´°É£¬µ½Ê±Ö§³ÖÖ§³Ö°É£¬ºÇºÇ
Ò»¡¢·Öҳд·¨Ð¡Àý£º
SELECT FIRST
10 templateid,code,name from
template ;
SELECT FIRST
10 SKIP
10 templateid,code,name from
template ;
SELECT
* from
shop ROWS
1 TO
10; --firebird2.0Ö§³ÖÕâÖÖд·¨
¶þ¡¢ÏÔʾ±íÃûºÍ±í½á¹¹
¡¡¡¡SHOW TABLES
;
SHOW TABLE
tablename;
Èý¡¢Ê¹ÓÃISQLÁ¬½ÓÊý¾Ý¿â
firebird%92bin>isql -u sysdba -p masterkey
SQL>CONNECT
'E:companyxmwsoftnewxmwsoftc2dbcts2.fdb';
»ò
SQL>CONNECT
'E:%92'
CON>USER
'sysdba'
CONT>PASSWORD
'masterkey';
ËÄ¡¢¸üÐÂ×Ö¶Î×¢ÊÍ
UPDATE
RDB$RELATION_FIELDS
SET
RDB$DESCRIPTION
= 'ÃèÊöÐÅÏ¢'
WHERE
(RDB$RELATION_NAME
= 'SHOP')
AND
(RDB$FIELD_NAME
= 'CREDIT_BUY')
Îå¡¢ÏÔʾ×Ö¶Î×¢ÊÍ
SELECT
RDB$FIELD_NAME
,RDB$DESCRIPTION
from
RDB$RELATION_FIELDS
WHERE
(RDB$RELATION_NAME
= 'SHOP')
AND
(DB$FIELD_NAME
= 'CREDIT_BUY')
Áù¡¢¸üбí×¢ÊÍ
UPDATE
RDB$RELATIONS
SET
RDB$DESCRIPTION
= 'ÃèÊöÐÅÏ¢'
WHERE
RDB$RELATION_NAME
= 'TABLE_NAME';
Æß¡¢²éѯËùÓеıíºÍÊÓͼ£¨°üÀ¨ÏµÍ³±íºÍϵͳÊÓͼ£©
SELECT
RDB$RELATION_NAME
from
RDB$RELATIONS
;
°Ë¡¢²éѯËùÓеÄÓû§±íºÍÓû§ÊÓͼ
SELECT
RDB$RELATION_NAME
from
RDB$RELATIONS
WHERE
RDB$SYSTEM_FLAG
= 0;
¾Å¡¢²éѯËùÓеÄÓû§±í
SELECT
RDB$RELATION_NAME
from
RDB$RELATIONS
WHERE
RDB$SYSTEM_FLAG
= 0
AND
RDB$VIEW_BLR
IS
NULL
;
Ê®¡¢²éËùÓÐÓû§±í¡¢Óû§ÊÓͼËùÓÐ×ֶμ°Ïà¹Ø¶¨Òå
SELECT
a.RDB$RELATION_NAME
,
b.RDB$FIELD_NAME
,
&nb
Ïà¹ØÎĵµ£º
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname ......
MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä
1¡¢SELECT ²éѯÓï¾äºÍÌõ¼þÓï¾ä
SELECT ²éѯ×ֶΠfrom ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£º Êý¾Ý¿â.±íÃû £¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢&nb ......
ΪÁË´¦Àí SQL Óï¾ä£¬ORACLE ±ØÐë·ÖÅäһƬ½ÐÉÏÏÂÎÄ( context area )µÄÇøÓòÀ´´¦ÀíËù±ØÐèµÄÐÅÏ¢£¬ÆäÖаüÀ¨Òª´¦ÀíµÄÐеÄÊýÄ¿£¬Ò»¸öÖ¸ÏòÓï¾ä±»·ÖÎöÒÔºóµÄ±íʾÐÎʽµÄÖ¸ÕëÒÔ¼°²éѯµÄ»î¶¯¼¯(active set)¡£
ÓαêÊÇÒ»¸öÖ¸ÏòÉÏÏÂÎĵľä±ú( handle)»òÖ¸Õ롣ͨ¹ýÓα꣬PL/SQL¿ÉÒÔ¿ØÖÆÉÏÏÂÎÄÇøºÍ´¦ÀíÓï¾äʱÉÏÏÂÎÄÇø»á·¢ÉúЩʲôÊÂÇ ......