How to concat (with comma separated) query result in MySQL

 Let say you have a query that return multiple row, but you want it return in single line separated by comma. 

Example query that returns result in rows:

SELECT invoiceNo FROM payment WHERE paymentStatus = '3' AND paymentYear = DATE_FORMAT(now(),'%Y') AND paymentAmountNett != '0.00' and billpaymentChannel='Cap';

How to trim the explode string in PHP

$string = 'ABC, DEF, GHI';

$expl = array_map('trim', explode(',', $string));

NPM - 'cross-env' is not recognized as an internal or external command

 How to solve this problem? super easy:

1. Remove node_modules folder
2. Remove package-lock.json
3. Run npm install

Create bootable USB from .iso file - Linux

Plug-in USB drive into your computer. Open up terminal and type :

fdisk -l

You'll see listing of drives available on your computer. Normally the USB drive will be shown like this :

/dev/sdb1 or /dev/sdc1

Now run this command:

sudo umount /dev/sd<?><?>

where first question mark is letter and second question mark is number. Then run this command:

sudo dd bs=4M if=the_image_file.iso of=/dev/sd<?><?>

Wait until finish and run command sync

Done!

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I ran this command:

LOAD DATA INFILE '/root/tk_worker_latestjan17.csv' INTO TABLE tk_worker_temp FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

I got the following error:

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

Solution:

1. Run this command  SHOW VARIABLES LIKE "secure_file_priv"; to show the configured directory.
2. Move the file to the directory specified by secure-file-priv 

Thank you

Laravel 4 - unserialize(): Error at offset

Enter both command below:

php artisan cache:clear <enter>
php artisan key:generate <enter>

Done!

VMWARE Player 6.0.3 running on Centos 6 "Could not open /dev/vmmon: No such file or directory. Please make sure that the kernel module `vmmon' is loaded."

Before this I'm using the older version of vmplayer on Centos 6. Everything work fine. Last week I upgraded the vmware player to 6.0.3 and I got problem to load the guest OS. The VMware player complain that "Could not open /dev/vmmon: No such file or directory. Please make sure that the kernel module `vmmon' is loaded."

After a long time searching for a solution, finally I found it. Just follow the simple stpes below:

1. Open your terminal
2. Type sudo mv /usr/lib/vmware/modules/binary /usr/lib/vmware/modules/binary.old
3. Then type sudo vmware-modconfig --console --install-all --appname="VMware Player" --icon="vmware-player"

Now I can start guest OS without any problem. Hope it helps!