Posts

SQL by Abhilash

Image
 SQL:- sql is structured query language. All SQL queries are as below:- show databases:- mysql> show databases; +--------------------+ | Database           | +--------------------+ | amit               | | information_schema | | mysql              | | performance_schema | | sys                | +--------------------+ 5 rows in set (0.00 sec) create database:- mysql> create database demo; Query OK, 1 row affected (0.04 sec) use database demo; mysql> use demo; Database changed create table student:- create table student(name varchar(30),id int not null primary key,address varchar(50),marks int); mysql> create table student(name varchar(30),id int not null primary key,address varchar(50),marks int); Query OK, 0 rows affected (0.09 sec) use of desc:- mysql> desc student; +---------+-------------+------+-----+---------+-------+ |...
Post a Comment
Read more

Linux basic commands and bash shell scripting by Abhilash

Image
Getting Started with Linux Commands and Bash Shell Scripting by Abhilash:- pwd:-it prints the full path of current working directory ls:-it is the list command which shows all files and directories that present in current working directory {blue:- dir/folder,white:-files,green:-executable files} ls -a:-lists all files including hidden files(hidden files name begin with dot) ls -l:-lists all attributes of all files in current directory ls -t:- here -t option represents the order of modification i.e.the last modified placed first ls -S:- it gives the biggest file in size first in the output ls --version:-it checks the version of ls command cd:-it is used to change the directory clear and exit:-it is used to clear the terminal and close the terminal cat:-it can be used to view some file,it can be used to create some file using cat > {here we need to enter some details when the prompt came here and then we can save the file using ctl D) ex:- cat > newfile.txt {here we created the fil...
Post a Comment
Location: Maharashtra, India
Read more