YoungManRiver
IS-IT--Management
All,
I was trying to create a list of files, over the week-end and write into MySQL. Same as DOS cmd "dir path\*.* /s /b > dir_list.txt", but into MySQL instead.
Kept getting an error on the "." from the filename.ext. I looked up the error and the MySQL manual says "." is a reserved word, not usable in database or table names, but says nothing about not being able to use as data in a field.
I know I've written full filenames into MySQL before using the "filename.ext" format, so figure it is something in the mysql.ini file.
To change this what am I looking for?
I know the obvious work around is to create another field for "ext" and then parse the file lines around the "." but prefer not to do this.
Thanks all for your help! It is much appreciated!
YMR
I was trying to create a list of files, over the week-end and write into MySQL. Same as DOS cmd "dir path\*.* /s /b > dir_list.txt", but into MySQL instead.
Kept getting an error on the "." from the filename.ext. I looked up the error and the MySQL manual says "." is a reserved word, not usable in database or table names, but says nothing about not being able to use as data in a field.
I know I've written full filenames into MySQL before using the "filename.ext" format, so figure it is something in the mysql.ini file.
To change this what am I looking for?
I know the obvious work around is to create another field for "ext" and then parse the file lines around the "." but prefer not to do this.
Thanks all for your help! It is much appreciated!
YMR