Skip to main content

SQL : Creating tables in mysql


We can create table in mysql with create table command. A simple SQL for creating a table named pytable is shown below. First select the database in which the table has to be created. Here an already existing database pydatabase base is used.

mysql > use pydatabase;

After that use the following SQL

mysql> create table pytable (

pyid int not null,
pyname varchar(100) not null,
pycode char(2),
pydate date,
pynum float(8,2),

primary key (pyid) 
);

So once the table is created we will get the message

Query OK, 0 rows affected (0.08 sec)








To view the structure of the table created use the describe command.






mysql> describe pytable;
+--------+--------------+------+-----+---------+-------+
| Field  | Type         | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+-------+
| pyid   | int(11)      | NO   | PRI | NULL    |       |
| pyname | varchar(100) | NO   |     | NULL    |       |
| pycode | char(2)      | YES  |     | NULL    |       |
| pydate | date         | YES  |     | NULL    |       |
| pynum  | float(8,2)   | YES  |     | NULL    |       |
+--------+--------------+------+-----+---------+-------+
5 rows in set (0.01 sec)




















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 : How to get record count from zipped file




























 Sometimes we may need to get records count from file . For that we can use wc -l , command with file name. In some situation the file will be in compressed format . wc -l will not directly work with zipped files . In this case we can do zcat the file and pipe the word count command with it.   Example :  Let say we have a file cricketData.dat.gz   To get word count from the file use :  zcat cricketData.dat.gz | wc -l   This will give the record count.




















Post a Comment









Read more




























Python : How to create your own module in python




























 Python modules are easy to create and imported in to your python program.     How to create a module?     The python program itself can be called as a python module. All the function which you find that can be grouped together can be put into the file. Here a simple example to print the text on display is used and called as techinfotalks.  #!/usr/bin/python # Python Module  def func_hi():         print "Welcome to the module" #End      How to use the module in program?     You just import the module created by calling the import.After that directly call the function which ever you need.The module named techinfotalks is imported as named as ti.    #!/usr/bin/python import techinfotalks as ti  print "Calling funcion in module" ti.func_hi()  #End of program  




















Post a Comment









Read more