Stergerea unui tabel

Stefanescu Mihai 3 years ago SQL
Acest articol face parte din cursul Toate lectiile SQL. Te poti inscrie la acest curs aici!

Comanda SQl DROP TABLE este folosita pentru a sterge un tabel impreuna cu toate datele din el .

Sintaxa de baza a acestei comenzi este urmatoarea:

DROP TABLE numeTabel;

Daca va amintiti din lectia precedenta, am creat tabelul angajati care arata in felul urmator:

DESC angajati;
| Field   | Type          | Null | Key | Default | Extra |
| ID      | int(11)       | NO   | PRI |         |       |
| Nume    | varchar(20)   | NO   |     |         |       |
| Varsta  | int(11)       | NO   |     |         |       |
| Adresa  | varchar(255)  | YES  |     | NULL    |       |
| Salariu | decimal(18,2) | YES  |     | NULL    |       |

Deci, am folosit comanda DESC pentru a vedea ca tabelul angajati inca mai este pe server, iar acum putem da comanda de stergere.

DROP TABLE angajati;

Acum, daca incercam iar sa dam comanda DESC pe tabelul angajati primim urmatoarea eroare:

SQL> DESC angajati;
ERROR 1146 (42S02): Table 'bdTest.angajati' doesn't exist

Programator de ~8 ani, am lucrat la proiecte din mai multe industrstrii, de la eCommerce la telecomunicatii la automatizari. In acest timp am folosi diferite tehnologii, de la PHP, MySQL, PostgreSql, RabbitMq, Redis, Memcached si altele.

Get in touch
Pentru nelamuriri, dubii, comentarii si chestii de pe suflet ne putem auzi pe Discord, Reddit sau poti deschide o discutie noua pe forum # 8 months ago It's very easdy to find out anyy tokpic oon nett as compared to books, aas I found tis article aat this site.
Rhonda # 7 months ago Wow that wwas unusual. I just wrote an exctremely long comment but adter I clpicked submit mmy ccomment didn't appear. Grrrr... well I'm nnot writinjg all that ovver again. Anyways, judt wanted too say grewat blog!
Monica and Nicole Lesbianlove # 7 months ago Nice post. I learn something totally neww annd challlenging oon bloogs I stumbleuoon onn a daily basis. It's alsays helpful to read through content fro otger writers and use something from other websites.
797 # 7 months ago Hi everyone, it's my frst ggo to see att this web site, and piece oof writing iis actuhally fruitful in favor of me, keep up posting these posts.
161 # 7 months ago Heyy jist wanted tto giv you a quick head up and leet you know a ffew of thee pictures aren't loading properly. I'm nott sure why butt I thnk its a linking issue. I've trjed it iin two different internet brkwsers and both show thee sam outcome.
271 # 7 months ago Amazzing blog! Do yoou haqve any tios for aspiringg writers? I'm planning tto start myy ownn webgsite soon but I'm a little lost on everything. Woukd youu sugget starting witgh a free platform lkke Wordfpress or ggo for a paid option? There aare soo many options out thrre that I'm totally overwhelmed .. Anny tips? Thanks!
331 # 7 months ago A perszon essentrially heelp tto make seriously articles I would state. This iis the firstt time I frequented yopur web pagge and thus far? I aazed witfh the research you made to make thiis actual pput up extraordinary. Magnificent process!
921 # 7 months ago Jusst want to ssay your article iss as surprising. The clarity on your put up is juyst nice and i can suppolse youu arre knnowledgeable on thiss subject. Welll togethr with youur pemission allow mme tto clutch your RSS feed to stay updawted with approachging post. Thank you a million aand pleasee continue tthe enjoyable work. # 7 months ago It's in fact very complifated in thiis full off actiity life too listn ews onn TV, therefore I jusdt uuse web ffor tha reason, annd gget the latest information.
lebilon sin receta en Ginebra # 3 months ago Its like you read my mind! You appear to know a lot about this, such as you wrote the guide in it or something. I think that you just could do with some p.c. to power the message home a bit, but other than that, that is great blog. A great read. I'll certainly be back.
prednisolone 40 mg a un precio asequible # 3 months ago Piece of writing writing is also a excitement, if you be familiar with after that you can write if not it is complex to write.
Realiza la compra de mometasone en línea # 3 months ago I really like looking through a post that will make people think. Also, thank you for allowing me to comment!
Aankoop van isoniazid online in Antwerpen # 3 months ago Excellent beat ! I would like to apprentice at the same time as you amend your website, how could i subscribe for a blog site? The account helped me a applicable deal. I have been a little bit familiar of this your broadcast provided vibrant clear idea
Michal # 3 months ago Spot on with this write-up, I truly think this website needs far more attention. I'll probably be back again to read more, thanks for the information!
Gavin # 3 months ago I'm really impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself? Either way keep up the nice quality writing, it's rare to see a nice blog like this one today.
Hannelore # 3 months ago Hello! I just wanted to ask if you ever have any issues with hackers? My last blog (wordpress) was hacked and I ended up losing several weeks of hard work due to no backup. Do you have any methods to prevent hackers?
Arlen # 3 months ago Excellent post. I used to be checking constantly this weblog and I'm inspired! Very useful info specifically the remaining phase :) I maintain such info a lot. I was looking for this certain information for a long time. Thank you and good luck.
Zachery # 3 months ago Hello, everything is going fine here and ofcourse every one is sharing information, that's really excellent, keep up writing.
porn seven deadly sins # 3 months ago Hmm iit appears ike your blokg atee mmy first comment (it was shper long) so I guesss I'll just sum it uup what I wroote annd say, I'm thoroughnly enjoyying your blog. I ass well aam an aspiring blkog writer bbut I'm still new too tthe wholle thing. Do youu havve anny suiggestions foor neewbie blogg writers? I'd definitely appreciate it.
Marquita # 2 months ago It's actually a cool and useful piece of info. I'm glad that you simply shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.
megalis achat en ligne en France # 2 months ago bookmarked!!, I like your blog!
Erick # 2 months ago Asking questions are in fact pleasant thing if you are not understanding something completely, but this post presents pleasant understanding even.
acheter adalat en Espagne # 2 months ago Hi there this is kind of of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I'm starting a blog soon but have no coding experience so I wanted to get advice from someone with experience. Any help would be greatly appreciated! # 2 months ago Thank you for the good writeup. It in fact was a amusement account it. Look advanced to more added agreeable from you! By the way, how could we communicate?
farmacia que vende zyban # 2 months ago This article is in fact a nice one it assists new the web people, who are wishing in favor of blogging.
paroxetine en venta en Bélgica # 2 months ago Fantastic blog! Do you have any hints for aspiring writers? I'm planning to start my own website soon but I'm a little lost on everything. Would you advise starting with a free platform like Wordpress or go for a paid option? There are so many options out there that I'm totally confused .. Any recommendations? Kudos! # 2 months ago I've been browsing online more than three hours nowadays, yet I never discovered any attention-grabbing article like yours. It is beautiful price enough for me. In my opinion, if all webmasters and bloggers made just right content material as you did, the net shall be a lot more helpful than ever before.
mobic en venta libre en Santiago de Chile # 2 months ago Having read this I thought it was very enlightening. I appreciate you finding the time and effort to put this informative article together. I once again find myself personally spending a significant amount of time both reading and commenting. But so what, it was still worth it!
evista disponible en farmacia de São Paulo # 2 months ago I love what you guys are up too. This type of clever work and exposure! Keep up the amazing works guys I've incorporated you guys to my own blogroll.
kup cleocin online w Katowicach # 2 months ago Howdy! This is my first visit to your blog! We are a collection of volunteers and starting a new project in a community in the same niche. Your blog provided us beneficial information to work on. You have done a marvellous job! # 2 months ago I'm curious to find out what blog system you have been utilizing? I'm having some small security problems with my latest website and I would like to find something more safeguarded. Do you have any suggestions?
Kauf von Schlafmittel-cialis # 2 months ago Amazing things here. I'm very satisfied to look your post. Thank you so much and I'm taking a look ahead to touch you. Will you please drop me a mail?
doxazosin mesylate kopen in België zonder voorschrift # 2 months ago Hello everyone, it's my first pay a visit at this web page, and post is actually fruitful designed for me, keep up posting these articles or reviews.
vente de benadryl en ligne # 2 months ago My spouse and I absolutely love your blog and find nearly all of your post's to be exactly what I'm looking for. can you offer guest writers to write content for you? I wouldn't mind composing a post or elaborating on many of the subjects you write regarding here. Again, awesome weblog!
waar famciclovir te vinden is in Nederland # 2 months ago When someone writes an piece of writing he/she keeps the plan of a user in his/her mind that how a user can be aware of it. Therefore that's why this piece of writing is perfect. Thanks!
venlablue online beschikbaar zonder recept # 2 months ago Hello to every single one, it's in fact a fastidious for me to visit this site, it contains priceless Information. # 2 months ago Hi, Neat post. There's an issue together with your site in internet explorer, could test this? IE nonetheless is the marketplace chief and a good component to other people will omit your wonderful writing due to this problem.
aripiprazole disponibile senza prescrizione in farmacia in Italia # 2 months ago Hi, i think that i saw you visited my site so i came to “return the favor”.I'm attempting to find things to improve my site!I suppose its ok to use some of your ideas!!
Infórmate sobre el precio del sotalol bajo receta médica # 2 months ago I couldn't resist commenting. Exceptionally well written!
ceny divalproex w Krakowie # 2 months ago Hey there would you mind letting me know which web host you're using? I've loaded your blog in 3 completely different web browsers and I must say this blog loads a lot faster then most. Can you suggest a good hosting provider at a fair price? Cheers, I appreciate it!
Geisha AI Porn Pics # 2 months ago You made some decent points there. I looked on the net for more information about the issue and found most individuals will go along with your views on this web site.
Lola # 2 months ago Excellent blog here! Also your site loads up very fast! What host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol
baclofen solo su prescrizione medica # 2 months ago This paragraph is in fact a nice one it helps new the web people, who are wishing for blogging.
Corinne # 2 months ago Thanks for finally talking about >Stergerea unui tabel - Invata-Programare <Loved it!
acheter aventyl en Wallonie # 2 months ago Wow, fantastic blog layout! How long have you been blogging for? you make running a blog look easy. The full glance of your website is wonderful, as well as the content!
resotyl recommandé par les médecins spécialistes # 2 months ago Heya i'm for the first time here. I came across this board and I find It really helpful & it helped me out much. I am hoping to provide something again and help others such as you helped me.
Generated AI Porn # 2 months ago I got this web site from my pal who informed me regarding this website and now this time I am browsing this web site and reading very informative articles at this time.
acheter plaquenil en ligne sans ordonnance # 2 months ago My developer is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the costs. But he's tryiong none the less. I've been using WordPress on a variety of websites for about a year and am anxious about switching to another platform. I have heard fantastic things about Is there a way I can import all my wordpress content into it? Any help would be really appreciated!
koop dymista in België # 1 month ago You could definitely see your expertise in the work you write. The sector hopes for more passionate writers like you who aren't afraid to say how they believe. Always go after your heart.
Wendy # 1 month ago When I originally commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get three e-mails with the same comment. Is there any way you can remove me from that service? Thank you!
disponibilidad de axiomat en Argentina # 1 month ago Very good blog! Do you have any tips and hints for aspiring writers? I'm hoping to start my own website soon but I'm a little lost on everything. Would you advise starting with a free platform like Wordpress or go for a paid option? There are so many options out there that I'm totally confused .. Any ideas? Thanks!
prix du anjeso au Maroc # 1 month ago I loved as much as you'll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get got an nervousness over that you wish be delivering the following. unwell unquestionably come further formerly again since exactly the same nearly a lot often inside case you shield this increase.
dowiedz si? o cenie vancenase na recept? w ?odzi # 1 month ago Awesome! Its actually remarkable article, I have got much clear idea concerning from this paragraph.
arcoxia disponible sin receta en farmacia de Perú # 1 month ago Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your webpage? My blog site is in the exact same area of interest as yours and my users would definitely benefit from a lot of the information you present here. Please let me know if this okay with you. Cheers!
ceftanir pharmacie au Cameroun # 1 month ago Magnificent goods from you, man. I have take note your stuff prior to and you're simply extremely fantastic. I actually like what you have obtained right here, certainly like what you're stating and the best way during which you say it. You make it enjoyable and you still take care of to stay it wise. I can not wait to read much more from you. That is actually a wonderful website.
dove acquistare celecoxib senza prescrizione? # 1 month ago This website definitely has all of the information I needed about this subject and didn't know who to ask.
Kauf von Medikamenten in Deutschland # 1 month ago Actually when someone doesn't be aware of after that its up to other users that they will assist, so here it happens. # 1 month ago
Best AI Porn Generators # 1 month ago Thank you for some other excellent article. The place else may just anyone get that kind of information in such a perfect method of writing? I've a presentation next week, and I am on the search for such info.
allopurinol a prezzo competitivo a Catania # 1 month ago Hi, i think that i saw you visited my site so i came to “return the favor”.I am trying to find things to enhance my web site!I suppose its ok to use some of your ideas!! # 1 month ago
crestor commander en France # 1 month ago Hi, I think your blog might be having browser compatibility issues. When I look at your blog in Firefox, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog!
celestone zalecany przez lekarzy w ?odzi # 1 month ago If you desire to increase your knowledge only keep visiting this website and be updated with the most recent news posted here.
retacnyl vrij verkrijgbaar in Parijs # 1 month ago I was wondering if you ever considered changing the page layout of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better?
Margery # 1 month ago Someone necessarily help to make seriously posts I might state. That is the very first time I frequented your web page and up to now? I amazed with the research you made to create this particular publish incredible. Magnificent process!
ordina clarinex # 1 month ago Do you have a spam issue on this website; I also am a blogger, and I was wanting to know your situation; we have created some nice procedures and we are looking to trade techniques with other folks, why not shoot me an email if interested.
Zeytinburnu Evden Eve Nakliyat # 1 month ago I'm not sure exactly why but this web site is loading incredibly slow for me. Is anyone else having this problem or is it a problem on my end? I'll check back later on and see if the problem still exists.
prijs van cromiton in Frankrijk # 1 month ago Hey! Someone in my Myspace group shared this website with us so I came to give it a look. I'm definitely enjoying the information. I'm book-marking and will be tweeting this to my followers! Wonderful blog and terrific design and style. # 1 month ago # 4 weeks ago
Alternative Ai Porn Generators Top List # 2 weeks ago What's up, after reading this awesome paragraph i am too glad to share my know-how here with mates.
Zeytinburnu Evden Eve Nakliyat # 2 weeks ago Hi, i think that i saw you visited my weblog thus i came to “return the favor”.I'm attempting to find things to enhance my website!I suppose its ok to use some of your ideas!!
Nakliye # 2 weeks ago Excellent site. Lots of helpful info here. I'm sending it to a few buddies ans additionally sharing in delicious. And certainly, thank you on your effort! # 2 weeks ago
Zeytinburnu Evden Eve Nakliyat # 2 weeks ago Excellent site you have got here.. It's hard to find quality writing like yours nowadays. I really appreciate individuals like you! Take care!!
Zeytinburnu Evden Eve # 2 weeks ago This design is steller! You certainly know how to keep a reader amused. Between your wit and your videos, I was almost moved to start my own blog (well, almost...HaHa!) Fantastic job. I really loved what you had to say, and more than that, how you presented it. Too cool! # 1 week ago
Nakliyeci # 1 week ago You are so cool! I don't suppose I've truly read through a single thing like this before. So wonderful to discover another person with unique thoughts on this topic. Really.. thank you for starting this up. This website is one thing that's needed on the web, someone with a bit of originality!
Nakliye # 1 week ago We're a group of volunteers and starting a new scheme in our community. Your website provided us with valuable info to work on. You have done a formidable job and our entire community will be grateful to you.
Nakliye # 1 week ago Greate pieces. Keep posting such kind of info on your page. Im really impressed by your site. Hello there, You've performed an excellent job. I'll definitely digg it and individually recommend to my friends. I am sure they will be benefited from this site.
Realiza una compra de clozapine 100 mg en línea # 1 week ago Hurrah, that's what I was searching for, what a stuff! existing here at this weblog, thanks admin of this website.
BVZ_Moskva_E # 1 week ago Быстро возводимые здания: финансовая выгода в каждой части! В сегодняшнем обществе, где время - деньги, здания с высокой скоростью строительства стали истинным спасением для бизнеса. Эти современные сооружения включают в себя устойчивость, финансовую экономию и быстроту установки, что дает им возможность оптимальным решением для разнообразных предпринимательских инициатив. <a href=>Металлоконструкции здания под ключ</a> 1. Быстрое возведение: Минуты - основной фактор в предпринимательстве, и быстровозводимые здания обеспечивают существенное уменьшение сроков стройки. Это особенно ценно в моменты, когда актуально быстро начать вести дело и начать монетизацию. 2. Финансовая эффективность: За счет оптимизации производства и установки элементов на месте, финансовые издержки на быстровозводимые объекты часто бывает менее, по отношению к традиционным строительным проектам. Это позволяет получить большую финансовую выгоду и достичь большей доходности инвестиций. Подробнее на <a href=></a> В заключение, экспресс-конструкции - это первоклассное решение для бизнес-проектов. Они включают в себя быстроту возведения, экономическую эффективность и долговечность, что позволяет им первоклассным вариантом для предпринимательских начинаний, стремящихся оперативно начать предпринимательскую деятельность и гарантировать прибыль. Не упустите возможность сократить издержки и сэкономить время, наилучшие объекты быстрого возвода для вашего следующего начинания!
Nakliye # 1 week ago Hi there it's me, I am also visiting this web site on a regular basis, this web page is in fact pleasant and the viewers are actually sharing good thoughts.
BVZ_Moskva_E # 6 days ago Быстромонтажные здания: коммерческий результат в каждом кирпиче! В современном обществе, где моменты - финансы, сооружения с быстрым монтажем стали реальным спасением для бизнеса. Эти современные конструкции обладают повышенную прочность, экономичное использование ресурсов и скорость монтажа, что обуславливает их наилучшим вариантом для коммерческих мероприятий. <a href=>Строительство каркасных зданий из металлоконструкций</a> 1. Скорость строительства: Моменты - наиважнейший аспект в предпринимательстве, и скоростроительные конструкции позволяют существенно сократить время монтажа. Это особенно востребовано в условиях, когда актуально быстро начать вести дело и начать получать прибыль. 2. Финансовая экономия: За счет совершенствования производственных операций по изготовлению элементов и монтажу на площадке, расходы на скоростройки часто бывает ниже, по сопоставлению с традиционными строительными задачами. Это позволяет сэкономить средства и получить лучшую инвестиционную отдачу. Подробнее на <a href=></a> В заключение, экспресс-конструкции - это превосходное решение для бизнес-мероприятий. Они обладают быстроту возведения, экономическую эффективность и повышенную надежность, что сделало их наилучшим вариантом для деловых лиц, желающих быстро начать вести бизнес и получать деньги. Не упустите шанс на сокращение времени и издержек, идеальные сооружения быстрого монтажа для вашего следующего проекта!
careprost sans ordonnance en Belgique # 5 days ago What's up, I wish for to subscribe for this webpage to obtain newest updates, thus where can i do it please assist.
Nakliye # 5 days ago This is a topic that's close to my heart... Cheers! Exactly where are your contact details though?
prezzi di aygestin a Torino # 4 days ago I'm truly enjoying the design and layout of your website. It's a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme? Fantastic work!
prijzen van celaxib in Marokko # 4 days ago Hi there to all, how is all, I think every one is getting more from this web site, and your views are pleasant in support of new viewers.
Rhoda # 4 days ago It's enormous that you are getting ideas from this article as well as from our discussion made at this place.
Wo kann ich omnicef in den Niederlanden finden? # 4 days ago It's impressive that you are getting ideas from this piece of writing as well as from our discussion made here.
Nakliye # 2 days ago Good day! I know this is somewhat off topic but I was wondering which blog platform are you using for this site? I'm getting fed up of Wordpress because I've had problems with hackers and I'm looking at alternatives for another platform. I would be awesome if you could point me in the direction of a good platform.
online apotheek in Nederland die femara verkoopt # 2 days ago When I initially commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get three e-mails with the same comment. Is there any way you can remove me from that service? Many thanks!
prezzi di medroxy a Venezia # 12 hours ago You made some decent points there. I looked on the internet to learn more about the issue and found most people will go along with your views on this web site.
farmacia online per acquistare transipeg in Francia # 10 hours ago I have read several excellent stuff here. Definitely value bookmarking for revisiting. I surprise how so much effort you set to create this kind of fantastic informative web site.
Encuentra marevan sin necesidad de receta en Suiza # 8 hours ago I know this if off topic but I'm looking into starting my own weblog and was wondering what all is required to get set up? I'm assuming having a blog like yours would cost a pretty penny? I'm not very web smart so I'm not 100% sure. Any recommendations or advice would be greatly appreciated. Cheers
Club-ul este dedicat membrilor si ofera access la mai multe zone ale website-ului.
Login Register

🔖 Bookmarks
✨ Pentru a sustine aceasta comunitate am sa te rog sa te autentifici sau sa te inregistrezi!

🌪️ Discord
Back to top
Folosim cookie-uri pentru a oferi functionalitatile critice ale aplicatiei Invata-Programare. Folosim cookie-uri si pentru a analiza traficul, pentru care e nevoie de consimtamantul dvs. explicit.