Simple Machines Blogs > Developers' Blog

Database Changes in SMF 2.0 - Part 2

<< < (2/15) > >>

Thantos:
I'll list them out

int
string
text
array_int
array_string
date
float
identifier
raw

In addition {prefix}, {query_see_board}, {query_wanna_see_board} are all magically replaced with $db_prefix, $user_info['query_see_board'], $user_info['query_wanna_see_board'] respectfully.

karlbenson:
I appreciate everythings a work in progress.

Is there a way to find out whether a certain mysql command would be supported.
Obviously I want to avoid functions that are mysql only in my current mods, to avoid making things harder when it comes to update for 2.0.

Specifically the command I'm referring to is INSERT SELECT.
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

It is supported by PostGreSql.

Thantos:
AFAIK INSERT SELECT is generic SQL command that should be supported by most (if not all) database engines.  Heck even MS Access has INSERT SELECT.

metallica48423:
Thanks for the Info, Thantos.

Pretty much the same as php resource types in terms of type casting.  (well, it is the same... duhh *slaps self*) :P

karlbenson:
Thanks. Thats good to know.
INSERT SELECT has saved me 1000's of queries in a mod i'm working on.

Navigation

[0] Message Index

[#] Next page

[*] Previous page