Neo4j Study
Installation
Neo4j service is not installed
D:\Tools\neo4j-community-5.5.0\bin>neo4j.bat start
Directories in use:
home: D:\Tools\neo4j-community-5.5.0
config: D:\Tools\neo4j-community-5.5.0\conf
logs: D:\Tools\neo4j-community-5.5.0\logs
plugins: D:\Tools\neo4j-community-5.5.0\plugins
import: D:\Tools\neo4j-community-5.5.0\import
data: D:\Tools\neo4j-community-5.5.0\data
certificates: D:\Tools\neo4j-community-5.5.0\certificates
licenses: D:\Tools\neo4j-community-5.5.0\licenses
run: D:\Tools\neo4j-community-5.5.0\run
Starting Neo4j.
Neo4j service is not installed
Unable to start. See user log for details.
Run with '--verbose' for a more detailed error message.
Install neo4j service
neo4j.bat windows-service install
Start neo4j
D:\Tools\neo4j-community-5.5.0\bin>neo4j.bat start
Directories in use:
home: D:\Tools\neo4j-community-5.5.0
config: D:\Tools\neo4j-community-5.5.0\conf
logs: D:\Tools\neo4j-community-5.5.0\logs
plugins: D:\Tools\neo4j-community-5.5.0\plugins
import: D:\Tools\neo4j-community-5.5.0\import
data: D:\Tools\neo4j-community-5.5.0\data
certificates: D:\Tools\neo4j-community-5.5.0\certificates
licenses: D:\Tools\neo4j-community-5.5.0\licenses
run: D:\Tools\neo4j-community-5.5.0\run
Starting Neo4j.
Started neo4j. It is available at http://localhost:7474
There may be a short delay until the server is ready.
打開http://localhost:7474
第一次進入時，使用默認用戶名和密碼 neo4j/neo4j 登錄并修改密碼
neo4j/password
Usage
# create a node
CREATE(a:Database {name: 'as400'})
Create(b:Database {name:'oracle'})
# create relation
MATCH (a:Database {name: 'as400'}), (b:Database {name: 'oracle'})
CREATE (a)-[:Migrate]->(b)
# query nodes
match (a:Database) return a;
Table Nodes
CREATE(a:Table {name:"CAR_FRA_INFO", description:"CAR_FRA_INFO",type:"as400"});
CREATE(a:Table {name:"CAR_MAIN", description:"CAR_MAIN",type:"as400"});
CREATE(a:Table {name:"HOLI", description:"HOLI",type:"as400"});
CREATE(a:Table {name:"LSPC_REPORT_INFO", description:"LSPC_REPORT_INFO",type:"as400"});
CREATE(a:Table {name:"PH23295", description:"PH23295",type:"as400"});
CREATE(a:Table {name:"PRFACD", description:"PRFACD",type:"as400"});
CREATE(a:Table {name:"PRFACL", description:"PRFACL",type:"as400"});
CREATE(a:Table {name:"PRFACO", description:"PRFACO",type:"as400"});
CREATE(a:Table {name:"PRFACP", description:"PRFACP",type:"as400"});
CREATE(a:Table {name:"PRFADE", description:"PRFADE",type:"as400"});
CREATE(a:Table {name:"PRFADEP", description:"PRFADEP",type:"as400"});
CREATE(a:Table {name:"PRFADL", description:"PRFADL",type:"as400"});
CREATE(a:Table {name:"PRFAFL", description:"PRFAFL",type:"as400"});
CREATE(a:Table {name:"PRFAFR", description:"PRFAFR",type:"as400"});
CREATE(a:Table {name:"PRFAFRP", description:"PRFAFRP",type:"as400"});
CREATE(a:Table {name:"PRFAHL", description:"PRFAHL",type:"as400"});
CREATE(a:Table {name:"PRFAIC", description:"PRFAIC",type:"as400"});
CREATE(a:Table {name:"PRFAID", description:"PRFAID",type:"as400"});
CREATE(a:Table {name:"PRFAIH", description:"PRFAIH",type:"as400"});
CREATE(a:Table {name:"PRFAIL", description:"PRFAIL",type:"as400"});
CREATE(a:Table {name:"PRFAPD", description:"PRFAPD",type:"as400"});
CREATE(a:Table {name:"PRFAPH", description:"PRFAPH",type:"as400"});
CREATE(a:Table {name:"PRFAPL", description:"PRFAPL",type:"as400"});
CREATE(a:Table {name:"PRFAPO", description:"PRFAPO",type:"as400"});
CREATE(a:Table {name:"PRFAPP", description:"PRFAPP",type:"as400"});
CREATE(a:Table {name:"PRFAPR", description:"PRFAPR",type:"as400"});
CREATE(a:Table {name:"PRFAPS", description:"PRFAPS",type:"as400"});
CREATE(a:Table {name:"PRFARE", description:"PRFARE",type:"as400"});
CREATE(a:Table {name:"PRFAREL", description:"PRFAREL",type:"as400"});
CREATE(a:Table {name:"PRFAVN", description:"PRFAVN",type:"as400"});
CREATE(a:Table {name:"PRFCBR", description:"PRFCBR",type:"as400"});
CREATE(a:Table {name:"PRFCED", description:"PRFCED",type:"as400"});
CREATE(a:Table {name:"PRFCEL", description:"PRFCEL",type:"as400"});
CREATE(a:Table {name:"PRFCEO", description:"PRFCEO",type:"as400"});
CREATE(a:Table {name:"PRFCER", description:"PRFCER",type:"as400"});
CREATE(a:Table {name:"PRFCER_COLLECT", description:"PRFCER_COLLECT",type:"as400"});
CREATE(a:Table {name:"PRFCER_PAYMENT", description:"PRFCER_PAYMENT",type:"as400"});
CREATE(a:Table {name:"PRFCET_MAIN", description:"PRFCET_MAIN",type:"as400"});
CREATE(a:Table {name:"PRFCFRA", description:"PRFCFRA",type:"as400"});
CREATE(a:Table {name:"PRFCIN", description:"PRFCIN",type:"as400"});
CREATE(a:Table {name:"PRFCMF", description:"PRFCMF",type:"as400"});
CREATE(a:Table {name:"PRFCML", description:"PRFCML",type:"as400"});
CREATE(a:Table {name:"PRFCMLH", description:"PRFCMLH",type:"as400"});
CREATE(a:Table {name:"PRFCMS", description:"PRFCMS",type:"as400"});
CREATE(a:Table {name:"PRFCNL", description:"PRFCNL",type:"as400"});
CREATE(a:Table {name:"PRFCOM", description:"PRFCOM",type:"as400"});
CREATE(a:Table {name:"PRFCOMH", description:"PRFCOMH",type:"as400"});
CREATE(a:Table {name:"PRFCOMT", description:"PRFCOMT",type:"as400"});
CREATE(a:Table {name:"PRFCON", description:"PRFCON",type:"as400"});
CREATE(a:Table {name:"PRFCTPEX", description:"PRFCTPEX",type:"as400"});
CREATE(a:Table {name:"PRFDE1", description:"PRFDE1",type:"as400"});
CREATE(a:Table {name:"PRFDE1H", description:"PRFDE1H",type:"as400"});
CREATE(a:Table {name:"PRFDE1HP", description:"PRFDE1HP",type:"as400"});
CREATE(a:Table {name:"PRFDE1P", description:"PRFDE1P",type:"as400"});
CREATE(a:Table {name:"PRFDE2", description:"PRFDE2",type:"as400"});
CREATE(a:Table {name:"PRFDE2H", description:"PRFDE2H",type:"as400"});
CREATE(a:Table {name:"PRFDE3", description:"PRFDE3",type:"as400"});
CREATE(a:Table {name:"PRFDE3H", description:"PRFDE3H",type:"as400"});
CREATE(a:Table {name:"PRFDE4", description:"PRFDE4",type:"as400"});
CREATE(a:Table {name:"PRFDE4H", description:"PRFDE4H",type:"as400"});
CREATE(a:Table {name:"PRFDES1", description:"PRFDES1",type:"as400"});
CREATE(a:Table {name:"PRFDOC", description:"PRFDOC",type:"as400"});
CREATE(a:Table {name:"PRFDUL", description:"PRFDUL",type:"as400"});
CREATE(a:Table {name:"PRFDUV", description:"PRFDUV",type:"as400"});
CREATE(a:Table {name:"PRFECTL", description:"PRFECTL",type:"as400"});
CREATE(a:Table {name:"PRFEINF", description:"PRFEINF",type:"as400"});
CREATE(a:Table {name:"PRFEML", description:"PRFEML",type:"as400"});
CREATE(a:Table {name:"PRFENT", description:"PRFENT",type:"as400"});
CREATE(a:Table {name:"PRFEXP", description:"PRFEXP",type:"as400"});
CREATE(a:Table {name:"PRFFAC", description:"PRFFAC",type:"as400"});
CREATE(a:Table {name:"PRFFACS", description:"PRFFACS",type:"as400"});
CREATE(a:Table {name:"PRFFIN", description:"PRFFIN",type:"as400"});
CREATE(a:Table {name:"PRFFPAR", description:"PRFFPAR",type:"as400"});
CREATE(a:Table {name:"PRFFRA", description:"PRFFRA",type:"as400"});
CREATE(a:Table {name:"PRFFRA_SUB", description:"PRFFRA_SUB",type:"as400"});
CREATE(a:Table {name:"PRFFRAH", description:"PRFFRAH",type:"as400"});
CREATE(a:Table {name:"PRFFRAP", description:"PRFFRAP",type:"as400"});
CREATE(a:Table {name:"PRFFRAS", description:"PRFFRAS",type:"as400"});
CREATE(a:Table {name:"PRFFRE", description:"PRFFRE",type:"as400"});
CREATE(a:Table {name:"PRFFRS", description:"PRFFRS",type:"as400"});
CREATE(a:Table {name:"PRFHAN", description:"PRFHAN",type:"as400"});
CREATE(a:Table {name:"PRFIDF", description:"PRFIDF",type:"as400"});
CREATE(a:Table {name:"PRFIDI", description:"PRFIDI",type:"as400"});
CREATE(a:Table {name:"PRFIDIH", description:"PRFIDIH",type:"as400"});
CREATE(a:Table {name:"PRFIDLH", description:"PRFIDLH",type:"as400"});
CREATE(a:Table {name:"PRFIDS", description:"PRFIDS",type:"as400"});
CREATE(a:Table {name:"PRFIDSH", description:"PRFIDSH",type:"as400"});
CREATE(a:Table {name:"PRFIHI", description:"PRFIHI",type:"as400"});
CREATE(a:Table {name:"PRFIHIH", description:"PRFIHIH",type:"as400"});
CREATE(a:Table {name:"PRFIHL", description:"PRFIHL",type:"as400"});
CREATE(a:Table {name:"PRFIHLH", description:"PRFIHLH",type:"as400"});
CREATE(a:Table {name:"PRFILC", description:"PRFILC",type:"as400"});
CREATE(a:Table {name:"PRFINF", description:"PRFINF",type:"as400"});
CREATE(a:Table {name:"PRFINH", description:"PRFINH",type:"as400"});
CREATE(a:Table {name:"PRFINS", description:"PRFINS",type:"as400"});
CREATE(a:Table {name:"PRFINSH", description:"PRFINSH",type:"as400"});
CREATE(a:Table {name:"PRFINSP", description:"PRFINSP",type:"as400"});
CREATE(a:Table {name:"PRFIPH", description:"PRFIPH",type:"as400"});
CREATE(a:Table {name:"PRFIPHH", description:"PRFIPHH",type:"as400"});
CREATE(a:Table {name:"PRFLOC", description:"PRFLOC",type:"as400"});
CREATE(a:Table {name:"PRFLOG", description:"PRFLOG",type:"as400"});
CREATE(a:Table {name:"PRFMUT", description:"PRFMUT",type:"as400"});
CREATE(a:Table {name:"PRFNCON", description:"PRFNCON",type:"as400"});
CREATE(a:Table {name:"PRFNTA", description:"PRFNTA",type:"as400"});
CREATE(a:Table {name:"PRFNUM", description:"PRFNUM",type:"as400"});
CREATE(a:Table {name:"PRFPAR", description:"PRFPAR",type:"as400"});
CREATE(a:Table {name:"PRFPHD", description:"PRFPHD",type:"as400"});
CREATE(a:Table {name:"PRFPHDH", description:"PRFPHDH",type:"as400"});
CREATE(a:Table {name:"PRFPRO", description:"PRFPRO",type:"as400"});
CREATE(a:Table {name:"PRFPSL", description:"PRFPSL",type:"as400"});
CREATE(a:Table {name:"PRFRUA", description:"PRFRUA",type:"as400"});
CREATE(a:Table {name:"PRFRUAC", description:"PRFRUAC",type:"as400"});
CREATE(a:Table {name:"PRFSIT", description:"PRFSIT",type:"as400"});
CREATE(a:Table {name:"PRFSITH", description:"PRFSITH",type:"as400"});
CREATE(a:Table {name:"PRFSITP", description:"PRFSITP",type:"as400"});
CREATE(a:Table {name:"PRFSTJ", description:"PRFSTJ",type:"as400"});
CREATE(a:Table {name:"PRFSTJH", description:"PRFSTJH",type:"as400"});
CREATE(a:Table {name:"PRFSUJ", description:"PRFSUJ",type:"as400"});
CREATE(a:Table {name:"PRFSUJH", description:"PRFSUJH",type:"as400"});
CREATE(a:Table {name:"PRFSUM", description:"PRFSUM",type:"as400"});
CREATE(a:Table {name:"PRFTAB", description:"PRFTAB",type:"as400"});
CREATE(a:Table {name:"PRFTEL", description:"PRFTEL",type:"as400"});
CREATE(a:Table {name:"PRFTYP", description:"PRFTYP",type:"as400"});
CREATE(a:Table {name:"PRFVEN", description:"PRFVEN",type:"as400"});
CREATE(a:Table {name:"PRFVENH", description:"PRFVENH",type:"as400"});
CREATE(a:Table {name:"PRFVENT", description:"PRFVENT",type:"as400"});
CREATE(a:Table {name:"PRFVEP", description:"PRFVEP",type:"as400"});
CREATE(a:Table {name:"PRFVEPH", description:"PRFVEPH",type:"as400"});
CREATE(a:Table {name:"SELO_APR_RELATION", description:"SELO_APR_RELATION",type:"as400"});
CREATE(a:Table {name:"SELO_LIST", description:"SELO_LIST",type:"as400"});
CREATE(a:Table {name:"SMSLOG", description:"SMSLOG",type:"as400"});
CREATE(a:Table {name:"PRFFRASAV", description:"PRFFRASAV",type:"as400"});
CREATE(a:Table {name:"PRFINSL", description:"PRFINSL",type:"as400"});
CREATE(a:Table {name:"PRFDE1L", description:"PRFDE1L",type:"as400"});
CREATE(a:Table {name:"PRFDE1LP", description:"PRFDE1LP",type:"as400"});
CREATE(a:Table {name:"PRFDE2L", description:"PRFDE2L",type:"as400"});
CREATE(a:Table {name:"PRFDE3L", description:"PRFDE3L",type:"as400"});
CREATE(a:Table {name:"PRFDE4L", description:"PRFDE4L",type:"as400"});
CREATE(a:Table {name:"PRFSITL", description:"PRFSITL",type:"as400"});
CREATE(a:Table {name:"PRFDULH", description:"PRFDULH",type:"as400"});
CREATE(a:Table {name:"PRFDUVH", description:"PRFDUVH",type:"as400"});
CREATE(a:Table {name:"PRFFRA_SUB_H", description:"PRFFRA_SUB_H",type:"as400"});
CREATE(a:Table {name:"PRFCTP", description:"PRFCTP",type:"as400"});
CREATE(a:Table {name:"PRFUSR", description:"PRFUSR",type:"as400"});
CREATE(a:Table {name:"PRFUSS", description:"PRFUSS",type:"as400"});
CREATE(a:Table {name:"PRFCET_VERIFY", description:"PRFCET_VERIFY",type:"as400"});
CREATE(a:Table {name:"PRFIDL", description:"PRFIDL",type:"as400"});
CREATE(a:Table {name:"CHECK_ROWS", description:"CHECK_ROWS",type:"as400"});
# Find tables belong to as400
MATCH (a:Table )-[r:BelongTo]->(b:Database {name:'as400'}) RETURN a, b, r