×ܽáÒ»ÏÂdelphiÖÐSQLÓï¾äÖÐÒýºÅ
×ܽáÒ»ÏÂSQLÓï¾äÖÐÒýºÅ(')¡¢quotedstr()¡¢('')¡¢format()ÔÚSQLÓï¾äÖеÄÓ÷¨ÒÔ¼°SQLÓï¾äÖÐÈÕÆÚ¸ñʽµÄ±íʾ(#)¡¢('')
ÔÚDelphiÖнøÐÐ×Ö·û±äÁ¿Á¬½ÓÏà¼Óʱµ¥ÒýºÅÓÃ('''),ÓÖÒýºÅÓÃ('''')±íʾ
Ê×Ïȶ¨Òå±äÁ¿
var
AnInt:integer=123;//ΪÁË·½±ãÔڴ˶¼¸øËüÃǸ³³õÖµ¡£ËäÈ»¿ÉÄÜÔÚÒý¸³³õÖµÔÚijЩÇé¿öϲ»¶Ô
AnIntStr:string='456';
AStr:string='abc';
AFieldName: string='×Ö·ûÐͱàºÅ';
ATableName: string='YourTable';
ADate:Tdatetime=now;
Adoquery1:tadoquery;
1£¬DelphiÓï¾ä
adoquery1.sql.text:=
'select ×Ö·ûÐͱàºÅ from YourTable where ×Ö·ûÐͱàºÅ='abc' and ÕûÐͱàºÅ=123';
µÈ¼ÛÓÚ
adoquery1.sql.text:=
'select '+AFieldName+' from '+ATableName+' where '+AFieldName
+'='''+AStr+''' and ÕûÐͱàºÅ='+AnIntStr;
Ò²µÈ¼ÛÓÚ
adoquery1.sql.text:=
'select '+AFieldName+' from '+ATableName+' where '+AFieldName
+'='+QuotedStr(AStr)+' and ÕûÐͱàºÅ='+Inttostr(AnInt);
´«µ½Êý¾Ý¿â·þÎñÆ÷Ϊ£º
select ×Ö·ûÐͱàºÅ from YourTable where ×Ö·ûÐͱàºÅ='abc' and ÕûÐͱàºÅ=123
2,DelphiÓï¾äÖÐÈÕÆÚ±íʾ
¶ÔÓÚaccessÊý¾Ý¿â£º
adoquery1.sql.text:=
'select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î=#2003-12-01#';
µÈ¼ÛÓÚ£º
adoquery1.sql.text:=
'select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î=#'+FormatDateTime('yyyy-MM-dd',now)+'#';
´«µ½·þÎñÆ÷Ϊ£º
select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î=#2003-12-01#
¶ÔÓÚMSSQLÊý¾Ý¿â£º
adoquery1.sql.text:=
'select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î='2003-12-01'';
µÈ¼ÛÓÚ£º
adoquery1.sql.text:=
'select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î='''+FormatDateTime('yyyy-MM-dd',now)+'''';
Ò²µÈ¼ÛÓÚ£º
µÈ¼ÛÓÚ£º
adoquery1.sql.text:=
'select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î='+QuotedStr(FormatDateTime('yyyy-MM-dd',now));
´«µ½·þÎñÆ÷Ϊ£º
select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î='2003-12-01'
ÈÕÆÚ×ֶλ¹¿ÉÒÔÕâÑù±íʾ
DelphiÓï¾ä
adoquery1.sql.text:=
'select ×Ö·ûÐͱàºÅ from YourTable where ÈÕÆÚÐÍ×Ö¶Î>='+QuotedStr(FormatDateTime('yyyy-MM-dd',now))
+' and ÈÕÆÚÐÍ×Ö¶Î<='+QuotedStr(FormatDateTime('yyyy-MM-dd',now+1));//Ã÷Ìì
µÈ¼ÛÓÚ
adoquery1.sql.text:=
'sele
Ïà¹ØÎĵµ£º
µ±ÎÒÃÇÓÃoracleµÄSQL*Plus¹¤¾ßÊäÈësqlÓï¾äµÄʱºò£¬SQL*PlusµÄĬÈÏÉèÖÃ×ÜÓÐЩ²»ºÏÀíµÄµØ·½£¬´ËʱÎÒÃÇͨ¹ýÒÔÏÂһЩ·½·¨¸Ä½ø£º
1¡¢¿ÉÒÔÔËÓÃSQL*Plus×ÔÉíһЩÓï¾ä¸Ä±ä»·¾³²ÎÊý¡£
SQL> set linesize 900 ; /* ¸ü¸ÄÏÔʾµÄ¿í¶È, ÉèÖóÉ900ºó, Ò»ÐÐÊý¾Ý¾Í²»»á·ÖÁ½ÐÐÏÔʾÁË */
&nb ......
½¨±í
create table users(
id number(4) primary key,
username varchar2(10),
password varchar2(10)
)
²éѯ±í²¢½âËø±í(¼´¿ÉÒÔµã»÷ÊäÈë¿òÏÂÃæµÄ"Ëø"ͼ±ê¹¤¾ß, ¼´"Edit data")
select * from users for update
ɾ³ý±íÖжàÓàµÄÁÐ
alter table mobilephone drop column mobiletype
תÔØ
------------------- ......
ËÄ¡¢ÁªºÏÊý×éµÄʹÓ÷½·¨
ÁªºÏÊý×éÒÔÇ°±»³ÆΪPL/SQL±í¡£ÔÚ±íÖв»ÄÜʹÓÃÁªºÏÊý×飬ֻÄܽ«ËüÃÇÓÃ×÷³ÌÐòÉè¼ÆµÄ½á¹¹Ìå¡£Ö»ÄÜÔÚPL/SQLÖзÃÎÊÁªºÏÊý×é¡£
×¢Òâµ½ÁªºÏÊý×é´øÀ´µÄһЩ¹Ø¼üÎÊÌâÊǷdz£ÖØÒªµÄ¡£ÕâЩÎÊÌâʹÎÒÃǽéÉÜËüÃǵÄÓ÷¨Ê±£¬ÐèÒª²ÉȡһЩÌرðµÄ·½·¨¡£ÕâЩÎÊÌâ°üÀ¨£º
ÁªºÏÊý×é²»ÐèÒª³õʼ»¯£¬Ò²Ã»Óй¹Ô캯ÊýÓï·¨¡£ÔÚ ......
ORACLE 10GµÄ¼¯ºÏAPI
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔÇ°£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......
QT DataBase SQL Explorer
1¡¢°²×°MySQLµ½¹Ù·½ÍøÕ¾ÏÂÔØMySQLÊý¾Ý¿â£¬·Ç°²×°°æ£¬Ö±½ÓÔËÐÐmysqld½ø³Ìǰ̨µÄ
2¡¢Ìí¼Óϵͳ»·¾³±äÁ¿£¬Path+=':\mysql\bin'µÄpath£¬ÔÙÔÚ¿ªÊ¼ÔËÐУ¬CMD->mysql -uroot µÇ¼µ½mySQLÊý¾Ý¿â
Default passwordûÓеģ¬ÓеĻ° mysql -uroot -pÊäÈëÃÜÂ룻ÍøÂçµÇ¼£ºmysql -h ip ......