Skip to main content
Mathematica

Return to Question

Added dependency on external package
Source Link
MarcoB
MarcoB
  • 67.7k
  • 18
  • 96
  • 197

I have a table in a MySQL-DB which is of datatype "bit". The name of this column is "abk".

If I write the following statement:

SQLSelect[connNeeds["DatabaseLink`"]

SQLSelect[
  conn, 
  {"dbtable_tooltips"}, 
  {"begriff_en", "abk"}, 
  SQLMemberQ[deffindcrit,        SQLColumn["geltungsbereich"]]
  SQLColumn["geltungsbereich"]]]]

Mathematica just respondsreturns the statement without doing thatunchanged.

On the other hand if I send a statement with a wrong column-name (one that does not exist), it tells me that it doesn't exist.

So I think, that it realises that there is this column is there, and the name is correct, but something else is wrong.

I have a table in a MySQL-DB which is of datatype "bit". The name of this column is "abk".

If I write the following statement:

SQLSelect[conn, 
  {"dbtable_tooltips"}, 
  {"begriff_en", "abk"}, 
  SQLMemberQ[deffindcrit,        
  SQLColumn["geltungsbereich"]]]

Mathematica just responds the statement without doing that.

On the other hand if I send a statement with a wrong column-name (one that does not exist), it tells me that it doesn't exist.

So I think, that it realises that there is this column and the name is correct, but something else is wrong.

I have a table in a MySQL-DB which is of datatype "bit". The name of this column is "abk".

If I write the following statement:

Needs["DatabaseLink`"]

SQLSelect[
  conn, 
  {"dbtable_tooltips"}, 
  {"begriff_en", "abk"}, 
  SQLMemberQ[deffindcrit, SQLColumn["geltungsbereich"]]
]

Mathematica just returns the statement unchanged.

On the other hand if I send a statement with a wrong column-name (one that does not exist), it tells me that it doesn't exist.

So I think, that it realises that this column is there, and the name is correct, but something else is wrong.

edited tags
Link
J. M.'s missing motivation ♦
J. M.'s missing motivation ♦
  • 125.5k
  • 11
  • 407
  • 581
Formatted code
Source Link
MarcoB
MarcoB
  • 67.7k
  • 18
  • 96
  • 197

I have a table in a MySQL-DB which is of datatype "bit". The name of this column is "abk".

If I write the following statement: SQLSelect[conn, {"dbtable_tooltips"}, {"begriff_en", "abk"}, SQLMemberQ[deffindcrit, SQLColumn["geltungsbereich"]]]

SQLSelect[conn, 
  {"dbtable_tooltips"}, 
  {"begriff_en", "abk"}, 
  SQLMemberQ[deffindcrit,        
  SQLColumn["geltungsbereich"]]]

Mathematica just responds the statement without doing that.

On the other hand if I send a statement with a wrong column-name (one that does not exist), it tells me that it doesn't exist.

So I think, that it realises that there is this column and the name is correct, but there is something else which is wrong.

I have a table in a MySQL-DB which is of datatype "bit". The name of this column is "abk".

If I write the following statement: SQLSelect[conn, {"dbtable_tooltips"}, {"begriff_en", "abk"}, SQLMemberQ[deffindcrit, SQLColumn["geltungsbereich"]]]

Mathematica just responds the statement without doing that.

On the other hand if I send a statement with a wrong column-name (one that does not exist), it tells me that it doesn't exist.

So I think, that it realises that there is this column and the name is correct, but there is something else which is wrong.

I have a table in a MySQL-DB which is of datatype "bit". The name of this column is "abk".

If I write the following statement:

SQLSelect[conn, 
  {"dbtable_tooltips"}, 
  {"begriff_en", "abk"}, 
  SQLMemberQ[deffindcrit,        
  SQLColumn["geltungsbereich"]]]

Mathematica just responds the statement without doing that.

On the other hand if I send a statement with a wrong column-name (one that does not exist), it tells me that it doesn't exist.

So I think, that it realises that there is this column and the name is correct, but something else is wrong.

Source Link
JJJanezic
JJJanezic
  • 277
  • 1
  • 8