Changes between Version 22 and Version 23 of DatabaseBasedAnalysis/table2sql
- Timestamp:
- 11/07/18 15:13:19 (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis/table2sql
v22 v23 101 101 }}} 102 102 103 In this example, '' FileId'' is the name of the SQL column for which the data type ''UNSIGNED INT'' should be used. The second column (UNSIGNED INT) is a basic SQL data type. The option can be given more than once.103 In this example, ''!FileId'' is the name of the SQL column for which the data type ''UNSIGNED INT'' should be used. The second column (UNSIGNED INT) is a basic SQL data type. The option can be given more than once. 104 104 105 105 == Table Creation == … … 192 192 MTime.fTime.fMilliSec [Long64_t] (MilliSec) 193 193 }}} 194 which means that the leaf MTime.fTime.fMilliSec is detected to be a Long64_t which is filled into a column called MilliSec. Leaves with non basic data types are ignored automatically and are marked as (-n/a-). User ignored columns are marked as (-ignored-).194 which means that the leaf MTime.fTime.fMilliSec is detected to be a Long64_t which is filled into a column called !MilliSec. Leaves with non basic data types are ignored automatically and are marked as (-n/a-). User ignored columns are marked as (-ignored-). 195 195 196 196 The complete `INSERT` query can be printed with `--print-insert`. Note that this can be a quite long output.