Hello, A new question has been asked in "CONNECT" by danielkrysiak: -------------------------------- Hi,
I have data in CSV files. Partitioned inside a directory, one file per day, alive (constantly written to, insert at the end). I want to load them on-line (not once a day). Normally I would write peace of code, that remembers the last file and place, so it can easily go back and continue. But the Connect engine looks like a great ready solution for this kind of thing. I'm just not sure about: 1. I can't use indexes, because the file is changed all the time. Can I somehow make sure the data will be visible in a "connect table" always in the same order? 2. About "Multiple File Tables". Whats the order of data inside them? 3. What about simple file format change: add column at the end. Will data from older files be visible in "Multiple File Table" as null? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/loading-csv-files/ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
