Èí¼þ²âÊÔÖг£ÓõÄSQLÓï¾ä
²éѯÓï¾ä
Óï·¨¸ñʽ£º
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUN
select_expr [, select_expr ...]
[from table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFF
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name' export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]
³£ÓþÙÀý
--²éѯmember±íÖÐËùÓеĻáÔ±¼Ç¼
SELECT * from member;
ÆäÖГ*”ºÅ±íʾÏÔʾ·ûºÏÌõ¼þµÄ¼Ç¼µÄËùÓÐ×Ö¶Î
ÔÚÊý¾Ý¿âÖд洢ÀàÐÍΪÎı¾µÄ×ֶβéѯ
--²éѯmember±íÖÐÐÕÃû½ÐÕÅÈýµÄ»áÔ±
SELECT * from member WHERE name = 'ÕÅÈý';
--²éѯmember±íÖÐËùÓÐÐÕÕŵĻáÔ±
SELECT * from member WHERE name like ‘ÕÅ%’;
ÆäÖГ%”±íʾÈÎÒâ×Ö·û¶¼·ûºÏÌõ¼þ¡£¼´Ö»ÓÐÂú×ãÐÕÃûÖеÚ1¸ö×Ö·ûÊÇ“ÕÅ”¾ÍÂú×ã²éѯÌõ¼þ
--²éѯmember±íÖÐËùÓÐÃû×Ö°üº¬“Èý”µÄ»áÔ±
SELECT * from member WHERE name like ‘%Èý%’;
ÓÉÓÚ“Èý”×Öǰºó¶¼º¬Óаٷֺœ%”£¬Õâ¾Í±íʾ“Èý”×ÖÇ°ÃæºÍ“Èý”×ÖºóÃæ²»¹ÜÊÇÈκÎ×Ö·û¶¼Âú×ã²éѯÌõ¼þ£¬¼´Ê¹“Èý”×ÖǰºóûÓÐ×Ö·ûÒ²·ûºÏÌõ¼þ
ÔÚÊý¾Ý¿âÖÐÄêÁä´æ´¢ÎªÊý×ÖÀàÐ͵Ä×ֶβéѯ
--²éѯmember±íÖÐÄêÁäµÈÓÚ18µÄ»áÔ±
SELECT * from member WHERE age = 18;
--²éѯmember±íÖÐÄêÁä´óÓÚµÈÓÚ18µÄ»áÔ±
SELECT * from member WHERE age >= 18;
Ïà¹ØÎĵµ£º
²éѯ card µÄ¼Ç¼ΪÁ½´ÎÒÔÉ쵀 card£¬¼Ç¼Êý:
select count(card), card from TableName group by card having count(card) > 1
¼¶Áª¸üУ¬¼¶ÁªÉ¾³ý:
ColumnName type not null constraint FK_Name foreign key(ColumnName) references PrimaryTable(ColumnName) on update/delete cascade
×Ô¶¯¼ÆËãÁÐ:
create tabl ......
ÎÒ·¢ÏÖ×Ô¼ºÀí½âÆðsqlÓï¾äÀ´ºÜÀ§ÄÑ£¬½ñÌì¿´ÁËÒ»±¾Ê飬¶ÙʱéÈû¶Ù¿ª£¬Ìù³öÀ´ºÍ´ó¼Ò·ÖÏíÒ»ÏÂ
selectÓï¾äÖ´ÐÐ˳Ðò
(7)SELECT (8)DISTINCT (10)<TOP_specification> <select_list>
(1)from <left_table>
(3)¡¡<join_t ......
ÎÊÌâÀ´×Ôhttp://topic.csdn.net/u/20091128/10/6750afae-71df-42df-ae23-14024736e1d8.html?64174
ÒÀÎҲ²â¿ÉÄÜÊÇҪƴ×Ö¶ÎÃû³Æ
if (D > 0)
{
UpData_D = "D_D" + D.ToString();
DataSet myData = Socut.Data.ExecuteDataSet("UPDATE YUAN SET " + UpData_D + "='" + Y + "',..........
}
......
Union All/Union/Intersect²Ù×÷
ÊÊÓó¡¾°£º¶ÔÁ½¸ö¼¯ºÏµÄ´¦Àí£¬ÀýÈç×·¼Ó¡¢ºÏ²¢¡¢È¡ÏàͬÏî¡¢ÏཻÏîµÈµÈ¡£
Concat£¨Á¬½Ó£©
˵Ã÷£ºÁ¬½Ó²»Í¬µÄ¼¯ºÏ£¬²»»á×Ô¶¯¹ýÂËÏàͬÏÑÓ³Ù¡£
1.¼òµ¥ÐÎʽ£º
var q = (
from c in db.Customers
select c.Phone
).Concat(
from c in db.Customers
......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......