skip to Main Content

how to optimize the below MYSQL query

the below query it scans more rows while the table has an index on it but not using that index for that column. Query; SELECT * FROM st_aepsrequest_log WHERE `snd_transno` IN ( SELECT pwcashout_transno FROM st_aeps_transaction_master a WHERE a.`entry_date` >=…

VIEW QUESTION

How has this mysql string been encoded and how can I replicate it? – PHP Versions

Here are the hex values of two strings stored in a MySQL database using two different methods. 20C3AFC2BBC2BFC3A0C2A4E280A2C3A0C2A4C2BEC3A0C2A4C5A1C3A0C2A4E2809A20C3A0C2A4C2B6C3A0C2A4E280A2C3A0C2A5C28DC3A0C2A4C2A8C3A0C2A5E280B9C3A0C2A4C2AEC3A0C2A5C28DC3A0C2A4C2AFC3A0C2A4C2A4C3A0C2A5C28DC3A0C2A4C2A4C3A0C2A5C281C3A0C2A4C2AEC3A0C2A5C28D20C3A0C2A5C2A420C3A0C2A4C2A8C3A0C2A5E280B9C3A0C2A4C2AAC3A0C2A4C2B9C3A0C2A4C2BFC3A0C2A4C2A8C3A0C2A4C2B8C3A0C2A5C28DC3A0C2A4C2A4C3A0C2A4C2BF20C3A0C2A4C2AEC3A0C2A4C2BEC3A0C2A4C2AEC3A0C2A5C28D20C3A0C2A5C2A5 and E0A495E0A4BEE0A49AE0A48220E0A4B6E0A495E0A58DE0A4A8E0A58BE0A4AEE0A58DE0A4AFE0A4A4E0A58DE0A4A4E0A581E0A4AEE0A58D20E0A5A420E0A4A8E0A58BE0A4AAE0A4B9E0A4BFE0A4A8E0A4B8E0A58DE0A4A4E0A4BF20E0A4AEE0A4BEE0A4AEE0A58D20E0A5A5 They represent the string काचं शक्नोम्यत्तुम् । नोपहिनस्ति माम् ॥. The former appears to be encoded badly, but works in…

VIEW QUESTION

Unzip not handling utf-8 in Node Alpine Docker image: how to set correct locale?

With this zip file, this Node script successfully outputs the files: const child_process = require('child_process') const util = require('util') const exec = util.promisify(child_process.exec) exec(`unzip -Z1 metamorpR.zip`).then(zip_contents => { if (zip_contents.stderr) { throw new Error(`unzip error: ${zip_contents.stderr}`) } console.log(zip_contents.stdout) }) metamorpR.z5…

VIEW QUESTION
Back To Top
Search