Often I need to extract a list of articles IDs from my MySql databases but getting the result in the default column is not enough and it can be easier to convert the result from a column into a one line list of comma separated results, for instance from
Select id from myTable
ID |
---|
64 |
85 |
25 |
63 |
but your expected output is 64, 85, 25, 63
To concatenate multiple rows results into a single mySql field you can use the group_concat built-in function (to make sure your MySql version has this function you would like to check in the manual).
Let’s see a real life example query where we can apply this function. In my db I have a list of additional information items identified by ID related to a specific website entry/profile. The query below allows me to collect all the IDs of the entries that relate to ‘www.example.com’
SELECT GROUP_CONCAT(additional_information_id) FROM `company_profile_additionalinformation` WHERE profile_website ='www.example.com' ;
Please note the result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. This can be changed. Check the manual for more information .
If you would like to enable mod_rewrite in your apache, for friendly URLs or other redirect requirements, please follow these instructions.
I have about 3 PCs in my office at the moment and the main router for my connection is downstairs at about 20m distance so the wisest thing to do was to reuse one of my old routers as a switch to connect all of the PCs together.
In order to fix the resolution of Ubuntu, that by default comes as small as 600×400, I suggest to work on the X11 config file to try to achieve a more flexible setting that would enable your monitor set-up to go wider.
If you have a Thomson TG585v7 used on O2 and thus with the O2 firmware you might like to replace this firmware with something more flexible and powerful. Moreover, in my experience, the O2 firmware will not allow you to run the router on another broadband service so let’s replace it following these general guide steps :
Would you like to build and easily manage your audience by means of email marketing straight from your web presence? Then let us bring you the right solution to your business needs. Our Mailout solution can easily integrate within your web presence and is easy to administer and use for both customer base definition, segmentation, copy creation and editing and user tracking.
Connecting your application with the most common Social Media could make the difference between a site going viral and never being noticed
Art Bizmate we have extensive experience in the development of scalable Facebook applications with the potential to reach million of users on Social Networking websites like Facebook.
common errors while installing unixODBC on unix/solaris
Small placeholder on how to extraxt tar.gz files.
the command to check all the system partitions is
df
to view the partition details in a more readable format with Gigabytes, Kilobytes etc use the h option
df -d
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.