This one time, at band camp, John Scott <[EMAIL PROTECTED]> wrote:
> 1. Is sqlite able to store files (document files, pictures, zip files) which are > bigger than 1 mb?? because normally a databse stores only strings. Yes, most databases can store Binary information in BLOBs, (Binary Large OBject) > 2. If yes. How fast is it to extract a file outof the database or import it into the > database? Just a little slower than with the file system > 3. The database has 10 columns and 1000 entries. Can I ask the database to find > entries which have in the third column the string "great"?? Does it take long??? Yes, SELECT * FROM tablename WHERE third_col_name LIKE '%great%' > 4. I think I have to be very familier with the language sql. Does someone have good > tutorials or introductions?? http://www.google.com.au/search?q=sql+tutorial&ie=UTF-8&oe=UTF-8&hl=en&btnG=Google+Search&meta= Kind regards Kevin -- ______ (_____ \ _____) ) ____ ____ ____ ____ | ____/ / _ ) / _ | / ___) / _ ) | | ( (/ / ( ( | |( (___ ( (/ / |_| \____) \_||_| \____) \____) Kevin Waterson Port Macquarie, Australia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
