From: Johan De Meersman Date: June 17 2011 7:35am Subject: Re: Encoding "Table Name" and "Filed Name" List-Archive: http://lists.mysql.com/mysql/225282 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_36ea750b-6ff8-4914-b0eb-ac1397380efd" --=_36ea750b-6ff8-4914-b0eb-ac1397380efd Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Vikram A" > I agree, its impossible to do manual look ups. But our aim is to > avoid the use of DB with out code. Also we have ensured, 'secret > data is encrypted using some functions with key'. > I shall follow both encode i.e, 1) filed and table name, 2) data > level? Or only data level is enough by having accounts as you > suggested? Data level encodes are usually considered good enough, although there's nothing to stop you from encrypting the field names if you feel so enclined. I predict you *will* need to make manual queries sooner or later, though :-p -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --=_36ea750b-6ff8-4914-b0eb-ac1397380efd--