posted 17 years ago
Well, 90+% of normal SQL stuff works fine. E.g. the Select, Insert, Delete. It's the "odd" stuff you have to look out for. Like the LIMIT statements, Subqueries, some functions, and key constraints (with 5.0).
jForum uses prepared statements that are stored in a plain text file (under the config/database/<db type> directory). There are two of three different query sets for MySQL that work for different MySQL versions. Plus some configuration properties like the db uses subselects one, and the like.
If one of the pre-packaged query sets don't work, it's easy for someone who knows SQL but not code to tweak them to match their version. Fortunately, this hasn't happened a lot recently.
[originally posted on jforum.net by monroe]