|
If the client library is working as intended and the query executes successfully, the amount of columns should never change:
SELECT user.user AS user,
|
user.host AS host,
|
user.password AS password,
|
concat(user.user,user.host,user.password,user.Select_priv,IFNULL(db,'')) AS userdata,
|
user.Select_priv AS anydb,
|
db.db AS db
|
FROM mysql.user LEFT JOIN mysql.db
|
ON user.user=db.user AND user.host=db.host
|
WHERE user.user IS NOT NULL AND user.user <> ''
|
The query will always return either no result at all or a result set with 6 columns of data.
|