views:

28

answers:

0

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 :(