hi everyone welcome to this lecture in this lecture we will see how to delete a table delete a table our drop a table is both are the same they can’t do that by using the command drop so use drop as I mentioned use these statements I mean use uppercase alphabets to use these statements that is drop table followed by okay before that let’s check the available databases database so if you see we have one database temp so we can drop the table by using drop table followed by database name that is temp dot and the table name in our case the table name is food and it should end with a semicolon as I mentioned that command should be the lower case here I have food but drop table temp dot sort maybe it is saved in the main dot so the table food is part of main database not temp database we will try to drop the another table that is student followed by semicolon if you see the list of available tables by using dot table so we don’t have any tables so in the next lectures we will see more about rows and columns thank you

Tags:






Youtube
Facebook
Google Plus
Twitter
TutorialDrive


Apache Zookeeper Tutorial

Apache Kafka Tutorial

Apache Kafka Security

Elasticserarch n Kibana

Java 8 Tutorial

Log4J Tutorial

Apache Storm Tutorial

SQLite Tutorial

Apache Ant Tutorial

Related Posts

blog

Apache Kafka Commands Cheat sheet

Spread the loveKafka Topics List existing topics bin/kafka-topics.sh –zookeeper localhost:2181 –list Purge a topic bin/kafka-topics.sh –zookeeper localhost:2181 –alter –topic mytopic –config retention.ms=1000 … wait a minute … bin/kafka-topics.sh –zookeeper localhost:2181 –alter –topic mytopic –delete-config retention.ms
Read more…

blog

What is Apache Maven | Apache Maven complete tutorial from scratch pdf

Spread the love In this post you will learn the complete tutorial of Apache Maven build tool What is Maven ? Apache Maven is a software project management and comprehension tool. Based on the concept
Read more…

blog

Practical Guide for Web Development in 2018

Spread the loveWelcome to my practical guide  for web development in 2018 in terms of  technology and career. Before we start I just want to  mention a few things, you don’t need to learn  everything that
Read more…