تبلیغات
SQL - دستور DELETE :

دستور DELETE :

نویسنده :tamishan tamishan1
تاریخ:دوشنبه 6 آذر 1391-06:27 ب.ظ

دستور DELETE  : رکورد های جدول را پاک می کند(می تواند همه رکورد های جدول را هم پاک کند).

ساختار  اصلی دستور DELETE  :

DELETE <table_or_view>

[

WHERE  <condition>

]

مثال : رکوردی را پاک کند که ستون CID ان بین   60  تا 80 باشد.

DELETE CityInfo

     WHERE  CID  BETWEEN  60  AND  80

SELECT

      *

FROM

                                                                                                                                                                 CityInfo

State

Population

CityName

CID

Tehrsn

520000

Tehran

10

Sari

145000

Sari

20

Sari

120000

Behshahr

30

Hamedan

320000

Ahvaz

40

Tehran

410000

Tehran

50

 




داغ کن - کلوب دات کام
نظرات() 
How do you get a growth spurt?
دوشنبه 16 مرداد 1396 08:06 ب.ظ
I always spent my half an hour to read this weblog's articles or reviews all the time along with a mug of coffee.
http://julianaoberhaus.blogas.lt/date/2015/07
سه شنبه 2 خرداد 1396 02:48 ق.ظ
Thanks for sharing your thoughts about دستور. Regards
BHW
دوشنبه 4 اردیبهشت 1396 08:31 ق.ظ
Hey! I know this is kinda off topic but I was wondering if you knew where I could
get a captcha plugin for my comment form? I'm using the same
blog platform as yours and I'm having trouble finding one?
Thanks a lot!
BHW
دوشنبه 28 فروردین 1396 07:31 ق.ظ
Hi, I do think this is a great blog. I stumbledupon it ;) I am going to
revisit yet again since i have book-marked it.
Money and freedom is the greatest way to change, may you be rich and continue to help others.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo