hi everyone in this lecture we will see what are the available comments and we will perform the basic operations so to open SQLite simply you can do that by typing sqlite3 then it will open a little CL line like command line interface with the name is Q light so here if you want to lease the all available commands you can use the command something like dot help so here all the SQL SQLite commands will start with dot remember this and I am using dart help so you can see it gave all the available SQLite commands and with the name in the description so it is important to know these commands so we will see what are the important comments so if you see dot databases if you use this command it will list names and files of attached databases and DB info dot DB info it will show the status information about the current database and we can turn on the echo and also we can turn off by using dart echo and we can use dot exit to exit this program and we can turn on the logs by using dot log and also we can open a file by using dot open followed by file name and dot output we will use dot output to send output to the any file it is something like we are redirecting the output to a particular file and we can exit the program by using the dot quit along with dot dot show it is used to see the current values or the current settings so we will see that so if you use dot show it will display all the current settings currently echo is off and explained off headers of an output standard output so we are not redirecting to any file and stats off so these are the current settings and before going and before performing any operations we will do you know we will format our output for now remember that in the next lecture we will see how this is helpful but for now just wait we are turning on the header header on and also mode we are going to column mode and also timer on which means yet turning on the header every time before displaying the output it will display a beautiful header so that it is easy for us to understand what is the data about and also we change the mode to column which means the result are the output will be displayed like a table like rows and columns it is easy to identify the data and also we are turning on the timer for each and every command at the end of the command we will see the time the we can in future we can see like we can track when did we executed this command so make sure to change these formatting options ok now that we are good with the formatting I want to discuss an important that is the SQLite master what is SQLite master the master table which holds the key information about our database tables so we will see what is that just type dot schema followed by SQLite underscore master so you will get this output here we will have table name root page SQL and the type is text integer text so remember for now SQLite master it is the master table which holds the key information about our database and before using any commands I want to introduce few few concepts about SQLite that is SQLite is case sensitive which means if use dot help we got a beautiful output with the you know different different types of commands which are available and with the description if I use help with the caps dot help record ever unknown command are invalid arguments which means this dart help with lower case letters is not equal to dot help with upper case letters which means SQLite is case sensitive and another thing is if you want to comment anything you can use two hyphens like if I want to use a dot help followed by some name you want to write any comments you can write by using two hyphens then you can write this is my commented stating statement so you can write something like this any of the SQLite statement will start with the key words something like select or insert or delete etcetera and before starting anything and we will also see the few statements which are useful they are in SQLite we have and also are Clause if you want to combine two conditions we can combine two conditions by using and also by using our clothes and we can change the table by using the command alter and if you want to begin any transaction statement we can do that by using the keyword begin

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…