Quote:
Originally Posted by BettingSherlock
So i'll get much bigger files, can live with that.
|
you are embedding the data into SQL statements? sort of like
steganography?
you're dead from the outset
the first step would be the CREATE TABLE statement
you will be unable to come up with one SQL statement that can run on all databases
well, you might be able to, but you'll be using a very small subset of the broad range of datatypes that various database systems support
take TINYINT, for instance... in ANSI SQL this would have to be SMALLINT because there is no TINYINT
TEXT would be very problematic, as the ANSI SQL equivalent is CHARACTER LARGE OBJECT, but not every database system supports that syntax
and so on...
distributing a CSV would seem like a far simpler strategy -- users who have databases will know how to load it, and users who don't have databases (e.g. they have excel) can also use it