hi Steve,
after you login with the new account , you can use the command
show grants;
to check which permission had been already granted to this account as below.
mysql show grants;
+-+
| Grants for r...@localhost |
hi HaidarPesebe,
one way to do this is :
1. save the excel to xxx.csv
2. then use the mysql SQL statement LOAD DATA INFILE
for example :
LOAD DATA INFILE 'c:\\test\\xxx.csv'
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
best regards
liuyann
From: haidarpes...@gmail.com
To:
hi , Octavian
you can try this SQL.
=
select agents.id, agents.name,
(select count(*) from clients where agent=agents.id),
(select sum(value) from sales where agent=agents.id)
from agents
where agent.id=100
=
hi,
I run your code , but worked propertly. I suggested to check the table USERS ,
ROLES, is the column userid / roleid same data type (INT(10) UNSIGNED ) with
your userroles table ?
==
mysql create table users (userid INT(10)
hi Faizal,
in this case, usualy we choose the MyISAM engine, as it will more fast than the
innodb.
here is the comparision for hte MyISAM vs InnoDB for you reference.
13.1. Comparing Transaction and Nontransaction Engines
hi Carloswil,
could you do below check:
1. show processlists; // is there any session logined by this user account?
2. select CURRENT_USER() ; // ensure you are logining with r...@localhost, not
the r...@%
best regards
liuyann
Date: Wed, 30 Sep 2009 09:37:28 -0400
Subject: