Stupidly Simply???

[mrtweaver]

Ok this is probably stupidly simple but for some reason the answer is eluding me

I have the following code:

$mySQLStatement = "Create if not exist table 12345 ( ...........);"

_EzMySQL_Exec ($mySQLStatement)

of course this is the simplified version, but i do know that this works and it does create the table as laid out.

What i want to do is be able to use a variable for the table name. But for some reason it dont like it, keeps comming back as SQL syntax error

And the only thing i change is where it says table, i have tried the following:

('" & $var &'")

'" & $var &"'

" $var "

plus a few other, so what would be the proper syntax for using a variable here?

 

 

[jchd]

SQL schema names should never be delimited by single quotes, they are for string literals.

If your schema name (alias, table, column, index, trigger, vue, whatever) contains whitespaces or some special characters, then you need to enclose it in double quotes sqare brackets or back-quotes. Engines differ about which delimiters it recognizes.

$table = 'this is my weird table name'
$Statement = 'create table if not exists [' & $table & '] ( ... );'
$Statement = 'create table if not exists "' & $table & '" ( ... );'
$Statement = 'create table if not exists `' & $table & '` ( ... );'