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
>
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) UNSIGNE
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
http://dev.mysql.com/doc/refman/5.1/en/storage-engine-compare-
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:
