MISCELLANEOUS Archives - An artist's personal website

Add a user and grant privilege in mysql

Posted on October 25, 2017March 22, 2018 by akash073

CREATE USER 'mcp'@'localhost' IDENTIFIED BY 'password';

1	CREATE USER 'mcp'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON * . * TO 'mcp'@'localhost';

1	GRANT ALL PRIVILEGES ON * . * TO 'mcp'@'localhost';

FLUSH PRIVILEGES;

1	FLUSH PRIVILEGES;

for more information https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

mysql -u root -pabc

1	mysql -u root -pabc

create database #Export

mysqldump -u [uname] -p[pass] db_name > db_backup.sql

1	mysqldump -u [uname] -p[pass] db_name > db_backup.sql

#import

mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

1	mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

git workflow

Posted on July 18, 2017July 18, 2017 by akash073

master develop feature/”feature-name” hotfix/”hot-fix-name” feature is created from development and hotfix is created from master. Details…

Ansible in ubuntu

Posted on May 5, 2017 by akash073

#HelloWorld.yaml — – name: This is a hello-world example hosts: 127.0.0.1 connection: local user: root Details…

Some useful linux command of ubuntu

Posted on May 5, 2017May 16, 2018 by akash073

#For configuring SSL in apache sudo apt-get install openssl sudo apt-get install libssl-dev openssl x509 Details…

Some Useful Tips For Clean Coding

Posted on March 21, 2017March 23, 2017 by akash073

First of all coding is a art…There are some rule to follow .. 1.Naming of Details…

Install Elastic Search on Windows 10

Posted on December 17, 2016December 17, 2016 by akash073

01.First Download Elastic Search engine https://www.elastic.co/guide/en/elasticsearch/reference/current/windows.html 02.Extract and Go to C:\elasticsearch\bin 03.Open CMD by shift+right Details…

Some use full link for quick implementation of works

Posted on December 17, 2016June 7, 2017 by akash073

#mvc3 generic repository pattern https://www.codeproject.com/Articles/640294/Learning-MVC-Part-Generic-Repository-Pattern-in ###DDD implementation http://www.zankavtaskin.com/2013/09/applied-domain-driven-design-ddd-part-1.html ##DDD termiology a) Value Object b) Entity Details…

select sm.Model,sum(CASE when sm.WarrantyAvailable=1 then 1 else 0 end) Warranty,
sum(CASE when sm.WarrantyAvailable<>1 then 1 else 0 end) NonWarranty
from WSMS.dbo.Requisition r
left join WSMS.dbo.RequisitionDetail rd
on r.RequisitionID=rd.RequisitionID
inner join WSMS.dbo.ServiceMaster sm
on r.ServiceId=sm.ServiceID
where rd.ItemCode not in ('SPAR.MOBL.00000','SPAR.MOBL.99999')
and rd.ItemStatus='Used'
group by sm.Model

1

2

3

4

5

6

7

8

9

10

select sm.Model,sum(CASE when sm.WarrantyAvailable=1 then 1 else 0 end) Warranty,

sum(CASE when sm.WarrantyAvailable<>1 then 1 else 0 end) NonWarranty

from WSMS.dbo.Requisition r

left join WSMS.dbo.RequisitionDetail rd

on r.RequisitionID=rd.RequisitionID

inner join WSMS.dbo.ServiceMaster sm

on r.ServiceId=sm.ServiceID

where rd.ItemCode not in ('SPAR.MOBL.00000','SPAR.MOBL.99999')

and rd.ItemStatus='Used'

group by sm.Model

#ROW NUMBER OVER PARTITION BY

select DATEDIFF(day, ReleaseDate, GETDATE()) AGES
from (
select Model,ReleaseDate ,
Row_number() OVER( partition BY Model ORDER BY ReleaseDate) RowNumber
from tblCellPhoneDepriciationPrice  p 
) X where X.RowNumber=1

1

2

3

4

5

6

select DATEDIFF(day, ReleaseDate, GETDATE()) AGES

from (

select Model,ReleaseDate ,

Row_number() OVER( partition BY Model ORDER BY ReleaseDate) RowNumber

from tblCellPhoneDepriciationPrice p

) X where X.RowNumber=1

#update Details…

Category: MISCELLANEOUS