Hi all, I just came across this little tid-bit of information today and thought I'd share it, seeing as it's potentially very useful to anyone trying to export records from MySQL and then import them into a 'repeating' field in Filemaker Pro. When importing a text file of single-field records, Filemaker considers the ASCII character 29 to be a repeating field seperator. So, you may wonder how you can export records terminated by ASCII-29 using MySQL... You can get ASCII-29 by using hexadecimal representation - it's simply 0x1d. So, to export a certain field like this, you simply do: SELECT field FROM table WHERE something = 'foo' INTO OUTFILE '/path/to/whatever.txt' LINES TERMINATED BY 0x1d Then just transfer it to your Mac/PC and import this text file into the repeating field of the record you desire. Et voila! Regards, ------------------------------------------------ Basil Hussain ([EMAIL PROTECTED]) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
