Hi ,
Result for Show Grants is as under
SQL result
Host: localhost
SQL-query: SHOW GRANTS FOR aldixit@localhost;
Grants for aldixit@localhost
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'aldixit'@'localhost'
IDENTIFIED BY PASSWORD 'xxxxxxxxxxxxxx'
GRANT SELECT ON `mysql`.* TO 'aldixit'@'localhost' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `samir`.* TO 'aldixit'@'localhost' WITH GRANT OPTION
Table Strecture areas in samir database
Database samir - table areas running on Shreya Intranet
areas
Field Type Null Default Links to Comments
acd varchar(5) No 0
aname varchar(30) No
depot char(3) No 0
repseq int(2) No 0
abbr char(3) No
state char(2) No
noreps float(5,2) No 0.00
Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 365 acd
depot INDEX None depot
repseq INDEX None repseq
Space usage :
Type Usage
Data 11,544 Bytes
Index 15,360 Bytes
Overhead 448 Bytes
Effective 26,456 Bytes
Total 26,904 Bytes
Row Statistic :
Statements Value
Format dynamic
Rows 365
Row length � 30
Row size � 74 Bytes
SQL For Areas
CREATE TABLE areas (
acd varchar(5) NOT NULL default '0',
aname varchar(30) NOT NULL default '',
depot char(3) NOT NULL default '0',
repseq int(2) NOT NULL default '0',
abbr char(3) NOT NULL default '',
state char(2) NOT NULL default '',
noreps float(5,2) NOT NULL default '0.00',
PRIMARY KEY (acd),
KEY depot (depot),
KEY repseq (repseq)
) TYPE=MyISAM;
Table strecture for Stockists table in samir database
Database samir - table Stockists running on Shreya Intranet
Stockists
Field Type Null Default Links to Comments
cucode varchar(7) No Stockist Code
d_code char(3) No depots -> depotid Depot
cu_code varchar(4) No Stockist
cu_nm varchar(40) No Stockist Name
area varchar(5) Yes NULL areas -> acd Area
a_nm varchar(30) No Area Name
d_name varchar(15) Yes NULL Depot Name
stkfullname varchar(204) Yes NULL Full Name
repseq int(3) Yes NULL Rep . Seq
Indexes :
Keyname Type Cardinality Field
repseq INDEX 4 repseq
area INDEX 1349 area
cucode INDEX 5396 cucode
Space usage :
Type Usage
Data 708,888 Bytes
Index 191,488 Bytes
Total 900,376 Bytes
Row Statistic :
Statements Value
Format dynamic
Rows 5,396
Row length � 131
Row size � 167 Bytes
SQL For Stockists
CREATE TABLE Stockists (
cucode varchar(7) NOT NULL default '',
d_code char(3) NOT NULL default '',
cu_code varchar(4) NOT NULL default '',
cu_nm varchar(40) NOT NULL default '',
area varchar(5) default NULL,
a_nm varchar(30) NOT NULL default '',
d_name varchar(15) default NULL,
stkfullname varchar(204) default NULL,
repseq int(3) default NULL,
KEY repseq (repseq),
KEY area (area),
KEY cucode (cucode)
) TYPE=MyISAM;
Updating Only areas:
Affected rows: 1
SQL-query : [Edit] [Create PHP Code]
update areas set aname = 'BALAGHAT' where acd = '78193'
Updation Succesful
Updating Only Stockist
Affected rows: 1
SQL-query : [Edit] [Create PHP Code]
update Stockists set a_nm = 'BALAGHAT' WHERE area = '78193'
Updation Succesful
Multi-Table Update with user aldixit
SQL-query :
update Stockists, areas set a_nm = aname WHERE area = acd
MySQL said:
update command denied to user: 'aldixit@localhost' for table 'areas'
Multi-Table Update with root user
Affected rows: 1
SQL-query : [Edit] [Create PHP Code]
update Stockists, areas set a_nm = aname WHERE area = acd
Updation Succesful
I have extensively tested this with different users but the query results are same
Regards
Ajit Dixit
-------------------------------------------------
This mail sent through http://shreya.co.in/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
