Subversion Repositories SmartDukaan

Rev

Rev 2398 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2398 Rev 3620
Line 8... Line 8...
8
 
8
 
9
MASTER_AFF_NAME=$1
9
MASTER_AFF_NAME=$1
10
AFF_NAME=$2
10
AFF_NAME=$2
11
AFF_URL=$3
11
AFF_URL=$3
12
 
12
 
13
mysql -uroot -pshop2020 user -e "insert into affiliate(master_affiliate_id, name, url, added_on) values((select id from masteraffiliate where name = '${MASTER_AFF_NAME}'), '${AFF_NAME}', '${AFF_URL}', now());" 
13
mysql -uroot -pshop2020 -h192.168.190.114 user -e "insert into affiliate(master_affiliate_id, name, url, added_on) values((select id from masteraffiliate where name = '${MASTER_AFF_NAME}'), '${AFF_NAME}', '${AFF_URL}', now());" 
14
mysql -uroot -pshop2020 user -e "SELECT * FROM affiliate where name = '${AFF_NAME}';" 
14
mysql -uroot -pshop2020 -h192.168.190.114 user -e "SELECT * FROM affiliate where name = '${AFF_NAME}';"