Skip to main content

mysql : creating database


To create a database in mysql do the following steps.

mysql> create database pydatabase;

This will create a database named pydatabase.


To list all the databases available use the below command

mysql> show databases;




+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| pydatabase         |

+--------------------+

4 rows in set (0.02 sec)











To use a particular database instance use the command










mysql> use pydatabase;








Database changed





This will change to database pydatabase.











To display all the tables present in a database use the command










mysql > show tables;




























Labels:





























Comments











Post a Comment






























Popular posts from this blog



















UNIX : How to ignore lines with certain names 




























  Sometimes we need to ignore multiple lines with certain words and get the list out of the file. usually it will be a log file to read . The below grep command can be used to ignore multiple words present in a text file.   Lets say the file contain   $ cat list.txt  apple  orange  apple  banana  papaya   Now we need to ignore line with orange , banana and papaya . So we can use the below grep command.   $ cat list.txt | grep -Ev "orange|banana|papaya"  apple  apple   It will ignore lines with the words in -v part of grep.  




















Post a Comment









Read more




























UNIX : unpack and pack using tar 




























 Tarball or tar is a utility in linux to unpack or pack the files.   Lets say we have a file name hello.tar.gz which is packed and compressed.   To unpack the file use the below command    > tar xvzf hello.tar.gz     This is unpack the compressed tarball file to the directory hello in current location.   To pack a list of files to a compressed tarball file , we can follow the below steps.   Let say we have the following list of files in Hello directory.   > cd Hello   > ls  helloworld.py  README.txt   Move back to parent directory and give the below command.   > cd ..    > tar zcvf hello.tar.gz Hello    This will create the compressed tar file in the current location   




















Post a Comment









Read more