How To ?

MySql Rollup function : The  GROUP BY  clause permits a  WITH ROLLUP  modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations.  ROLLUP  thus enables you to answer questions at multiple levels of analysis with a single query. For example,  ROLLUP  can be used to provide support for OLAP (Online Analytical Processing) operations. Suppose that a  sales  table has  year ,  country ,  product , and  profit  columns for recording sales profitability: CREATE TABLE sales ( year INT, country VARCHAR(20), product VARCHAR(32), profit INT ); To summarize table contents per year, use a simple  GROUP BY  like this: mysql> SELECT year, SUM(profit) AS profit FROM sales GROUP BY year ASC; +------+--------+ | year | profit | +------+--------+ | 2000 | 4525 | | 2001 | 3010 | +------+--------+ ...

Installing Python Package in offline System (Production System) : Mostly we have work  to work in production system , where there is no internet connectivity , so  question is this how we are going to  install package in offline system. so i am telling you my experience , how i have done it in steps  : Step 1: --  Off course you have to download package in from a internet , so how to do it ...     A :- Make a directory in desktop , where you want to download the package :     B:-  pip install pysftp --download="/home/usr/sfpt" Ex. I have downloaded  package for sftp : pysftp  , shown a  screen shot for your reference  :             so all dependence python will also be downloaded  .  as show in mentioned pic : Step 2: So now you are having  .whl file along pysft-0.2.9.tar.gz . .whl file are python   built-package format fo...

Q -   What are prime and non prime attribute  ? Ans : Prime Attributes –   Attribute set that belongs to any candidate key are called Prime Attributes. If A is Candidate Key, and X→A, then, X is also Candidate Key .  Non Prime Attribute –  Attribute set does not belongs to any candidate key are called Non                  Prime  Attributes .  For Understanding   about Prime and Non Prime Attribute below are few example  . 

Q : How to add group then user in linux . ? Ans : 1: add group by using command groupadd 2: add a user into the group by   command  useradd  -G   . for adding a user in multiple group  just seperate user by  useradd -G , ,   3:  now add password to  user by command passwd 4:  ensure that user has been added to group use command id ,you will see information         of user id ,group id  . 5:  add a existing user to existing group           usermod -a -G         -a option is used for adding user in supplementry group . 6  :  adding user  to  a derive .         useradd  -d /directory               ->  this will add user to a directory .       Now come to  password        use command          pa...

Q: what are different version of c# and their framework support  ? Ans : c#1.0 ,1.2,2.0,3.0,4.0,5. and 6.0 are different version of c# .  Frame work  - dot net version  .Net Framework 1.0  =  c#1.0  visual studio 2002  .Net Framework 1.1   = c#1.2 Visual studio 2003  .Net Framework 2.0  =  c# 2.0    = visual studio 2005  .Net Framework 2.0 ,3.0, 3.5   =  c#3.0 =  visual studio 2008 , visual studio 2010  .Net Framework 4.0  = c#4.0   visual studio 2010  .Net Framework 4.5  = c#5.0  = visual studio 2012, 2013  .Net Framework 4.6  = c#6.0  = visual studio 2015 Q : what are method in c# ? Ans : Method or function(will have return type) will be used  for writing a programme in more manageable way , syntax for methods  :  [attribute]   access-modifiers  return type  method name(parameter)    {   ...

Installing MySql 5.6 in  My Linux Server RHEL6 , but problem was that there was no internet connectivity in server . so for installing  MySql need to download  three .rpm file , that you can download from any other   another internet connected pc  and put those rpm file in RHEL6 Machine . MySQL-server-5.6.16-1.el6.X86_64.rpm MySQL-client-5.6.16.el6.x84_64.rpm MySQL-embeded-5.6.16-1.el6.x86_64.rpm i have installed all three rpm by using command : rpm -ivh server   then  rpm -ivh embeded  then rpm - client . but when i started service ,service shows ,there is no mysql service available in ,so i tried to uninstall by using command rpm -ev .rpm file .......................................... but  it is showing rpm file is not installed . after searching from multiple troubleshoot ,i have found a solution to uninstall rpm file by using below mentioned command  : rpm -ev --nonscripts   make sure , remove .rpm extension fro...

Hello  Friends ,In this topic  we will discuss about  administrator task  and few basic concept , how Resolve the basic problems in My Sql  . First You should know about variables or parameter  that are used by the MySql Application  because as load will be increase in database ,then you should know which parameter is going to be  change for smooth performance of mysql .. Q : how to check variable list in Mysql ? Ans :  Mysqladmin variables or   show variables  command in msysql cli . can be used to get the variable list  of msql . For example  Few Variable List :  have_innodb  for  checking inndob enable or not  have_isam    for indicates whether ISAM tables are available . key_buffer_size  : sets the size of buffer used for indexes shared among thread .  log  : indicate whether logging is enable for all queries or not . Q : What are support config file  used ...