I'm trying to import data from *txt to MySQL database with PHPMyAdmin. Using LOAD DATA INFILE. Text file looks like:
Graph 1, order 7.
0000000
0000000
0000000
0000000
0000000
0000000
0000000
Graph 2, order 7.
0000001
0000000
0000000
0000000
0000000
0000000
1000000
Graph 3, order 7.
0000001
0000001
0000000
0000000
0000000
0000000
1100000
This is an adjacency matrix. I need to store only binary values, without Graph x, order x.
Or to store in 2 fields: 1 - for "Graph..." and 2 - for "000...". Help me to make a request. I tried this
LINES TERMINATED BY '7.'
but works bad :(