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 ...
... 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 ...
... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well:
Note that any IDs used in the snippets ...
... var json_Row = new Array();
var json_Arg = new Object();
// get some values beforehand which allows us to compare to the rows already present in the subform
// first column to add ...
What?
A quick article to display a value in a column in a widget in Zoho Analytics.
Why?
Because I keep forgetting how to do it.
How?
I've done this for a query that amalgamated all the ...
... the parent form to hide the columns I don't need the user to see (I'll populate these by code):
hide Attachments.Parent_Record;
hide Attachments.Document_Name;
hide Attachments.Downloaded;
Here ...
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.