What?
This is an article to document how to output the most frequently used words in a MySQL database column.
How?
Note this only applies to MySQL.
So the following query will return a count ...
What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).
How?
So for demonstration ...
Applies To:
MS SQL Server 2008 R2
MS Windows 7 Enterprise (Client)
MS Excel 2010
What?
A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...
What?
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...
Applies to
Transact-SQL (T-SQL)
What?
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
Why?
I have a table that ...
What?
So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly.
How?
This has to be ...
What?
This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...
What?
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this.
How?
Taken from the best forum for programming Qs&As:
http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...
What?
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...
Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum:
Quick Count
=INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&"")))
...
The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. ...
Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue ...
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this:
I googled this for ages and found different suggestions ...
Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed).
Basically what I used to do is something similar to the ...
... or different columns) with equals and starts_with conditions.
The only operator that is supported for encrypted fields is equals.
When you use "equals" for multiple conditions, and if one of your conditions ...
What?
Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay.
Why?
Our use-case is a data migration from eBay to a fresh instance ...
... form is called "Staff" and the subform is called "Usual Shift" containing the columns "Day", "Start Time", and "End Time":
//
// select applicable staff
l_ApplicableStaff = Staff[ID != 0];
for eac ...
... on each row and then the campaigns as columns.
What we want:
Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3
---------------- --------------- -------------- -------------- ...
What?
An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products.
Why?
Our use-case is that we retrieve the 100 most ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.