SELECT N Percent of Records in MySQL
The ability to select a certain percentage of records from a query or database table can be important when working with lots of data. Luckily this is easy to do…
0 Comments
January 25, 2021
How to Select a Random Sample of Records in MySQL
The ability to select a random sample of records from query or database table can be important when working with lots of data. Luckily this is easy to do in…
January 25, 2021
Counting Relationships in Neo4j
When working with different graphs in Neo4j, it is often important to count the number of relationships between different nodes. Below are examples of common relationship counting tasks. The data…
January 25, 2021
Delete all Nodes and Relationships in a Neo4j Database
Deleting Nodes and Relationships Deleting all nodes and relationships in a Neo4j database is very simple. Here is an example that does just that: MATCH (n) DETACH DELETE n; The…
January 25, 2021
Load a Tab Delimited File into Neo4j
Neo4j is a popular graph database which provides an easy way to import text files using the Cypher query language and a LOAD CSV clause. LOAD CSV by default expects…
January 25, 2021
Running Neo4j 3.x on Docker
Neo4j is the world’s leading graph database. Fortunately, Neo Technology publishes official Neo4j Docker images which makes it very easy to get started. Once you have Docker running, simply use…
January 25, 2021
How to Select Random Records in MySQL
The ability to select random records from a table in MySQL can be helpful. Luckily this is easy to do with the RAND() function. RAND() returns a random floating point…
January 25, 2021