I typically use prepared statements with an API similiar to the kind of string formatting that you demonstrated, and in my experience it is not exactly typical (though neither it is atypical) for the SQL statement to be able to fit on a single line even then (presumably your mileage varies with recommended/enforced line widths).Quote:
Originally Posted by bithub
Because the database software (in my case, SQLite) does not support them. There may be other reasons when using database software designed to compete with Oracle rather than fopen(), considering that Mario F. mentioned something about "those cases where the DDL is meant to go inside the code".Quote:
Originally Posted by bithub
By the way, have we had this discussion before? I have a sense of deja vu.