mathematica daten aus mysql |
05.12.2010, 21:33 | winti | Auf diesen Beitrag antworten » |
mathematica daten aus mysql ich hab ein problem mit mathematica bzw. mit mysql bzw. mit der kombination von beiden^^ leider hab ich dazu noch nix gefunden habt ihr ahnung wie man mit mathematica daten aus mysql auslesen kann? die verbindung habe ich scheinbar hinbekommen. allerdings bekomme ich auf sämtliche anfragen keine rückgabewerte. hier nochmal die verbindungsdetails: \!\(\* TagBox[GridBox[{ {"\<\"AllProceduresAreCallable\"\>", "False"}, {"\<\"AllTablesAreSelectable\"\>", "False"}, {"\<\"CatalogSeparator\"\>", "\<\".\"\>"}, {"\<\"CatalogTerm\"\>", "\<\"database\"\>"}, {"\<\"DatabaseMajorVersion\"\>", "5"}, {"\<\"DatabaseMinorVersion\"\>", "1"}, {"\<\"DatabaseProductName\"\>", "\<\"MySQL\"\>"}, {"\<\"DatabaseProductVersion\"\>", "\<\"5.1.53-community\"\>"}, {"\<\"DataDefinitionCausesTransactionCommit\"\>", "True"}, {"\<\"DataDefinitionIgnoredInTransactions\"\>", "False"}, {"\<\"DefaultTransactionIsolationLevel\"\>", "\<\"ReadCommitted\"\>"}, {"\<\"DeletesAreDetectedForForwardOnly\"\>", "False"}, {"\<\"DeletesAreDetectedForScrollInsensitive\"\>", "False"}, {"\<\"DeletesAreDetectedForScrollSensitive\"\>", "False"}, {"\<\"DoesMaxRowSizeIncludeBlobs\"\>", "True"}, {"\<\"DriverMajorVersion\"\>", "5"}, {"\<\"DriverMinorVersion\"\>", "1"}, {"\<\"DriverName\"\>", "\<\"MySQL-AB JDBC Driver\"\>"}, {"\<\"DriverVersion\"\>", "\<\"mysql-connector-java-commercial-5.1.7 \ ( Revision: ${svn.Revision} )\"\>"}, {"\<\"ExtraNameCharacters\"\>", "\<\"#@\"\>"}, {"\<\"IdentifierQuoteString\"\>", "\<\"`\"\>"}, {"\<\"InsertsAreDetectedForForwardOnly\"\>", "False"}, {"\<\"InsertsAreDetectedForScrollInsensitive\"\>", "False"}, {"\<\"InsertsAreDetectedForScrollSensitive\"\>", "False"}, {"\<\"IsCatalogAtStartOfTableName\"\>", "True"}, {"\<\"JDBCMajorVersion\"\>", "3"}, {"\<\"JDBCMinorVersion\"\>", "0"}, {"\<\"LocatorsUpdateCopy\"\>", "True"}, {"\<\"MaxBinaryLiteralLength\"\>", "16777208"}, {"\<\"MaxCatalogNameLength\"\>", "32"}, {"\<\"MaxCharLiteralLength\"\>", "16777208"}, {"\<\"MaxColumnNameLength\"\>", "64"}, {"\<\"MaxColumnsInGroupBy\"\>", "64"}, {"\<\"MaxColumnsInIndex\"\>", "16"}, {"\<\"MaxColumnsInOrderBy\"\>", "64"}, {"\<\"MaxColumnsInSelect\"\>", "256"}, {"\<\"MaxColumnsInTable\"\>", "512"}, {"\<\"MaxConnections\"\>", "0"}, {"\<\"MaxCursorNameLength\"\>", "64"}, {"\<\"MaxIndexLength\"\>", "256"}, {"\<\"MaxProcedureNameLength\"\>", "0"}, {"\<\"MaxRowSize\"\>", "2147483639"}, {"\<\"MaxSchemaNameLength\"\>", "0"}, {"\<\"MaxStatementLength\"\>", "65531"}, {"\<\"MaxStatements\"\>", "0"}, {"\<\"MaxTableNameLength\"\>", "64"}, {"\<\"MaxTablesInSelect\"\>", "256"}, {"\<\"MaxUserNameLength\"\>", "16"}, {"\<\"NullPlusNonNullIsNull\"\>", "True"}, {"\<\"NullsAreSortedAtEnd\"\>", "False"}, {"\<\"NullsAreSortedAtStart\"\>", "False"}, {"\<\"NullsAreSortedHight\"\>", "False"}, {"\<\"NullsAreSortedLow\"\>", "True"}, {"\<\"NumericFunctions\"\>", \ "\<\"ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,\ FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,\ TAN,TRUNCATE\"\>"}, {"\<\"OthersDeletesAreVisibleForForwardOnly\"\>", "False"}, {"\<\"OthersDeletesAreVisibleForScrollInsensitive\"\>", "False"}, {"\<\"OthersDeletesAreVisibleForScrollSensitive\"\>", "False"}, {"\<\"OthersInsertsAreVisibleForForwardOnly\"\>", "False"}, {"\<\"OthersInsertsAreVisibleForScrollInsensitive\"\>", "False"}, {"\<\"OthersInsertsAreVisibleForScrollSensitive\"\>", "False"}, {"\<\"OthersUpdatesAreVisibleForForwardOnly\"\>", "False"}, {"\<\"OthersUpdatesAreVisibleForScrollInsensitive\"\>", "False"}, {"\<\"OthersUpdatesAreVisibleForScrollSensitive\"\>", "False"}, {"\<\"OwnDeletesAreVisibleForForwardOnly\"\>", "False"}, {"\<\"OwnDeletesAreVisibleForScrollInsensitive\"\>", "False"}, {"\<\"OwnDeletesAreVisibleForScrollSensitive\"\>", "False"}, {"\<\"OwnInsertsAreVisibleForForwardOnly\"\>", "False"}, {"\<\"OwnInsertsAreVisibleForScrollInsensitive\"\>", "False"}, {"\<\"OwnInsertsAreVisibleForScrollSensitive\"\>", "False"}, {"\<\"OwnUpdatesAreVisibleForForwardOnly\"\>", "False"}, {"\<\"OwnUpdatesAreVisibleForScrollInsensitive\"\>", "False"}, {"\<\"OwnUpdatesAreVisibleForScrollSensitive\"\>", "False"}, {"\<\"ProcedureTerm\"\>", "\<\"PROCEDURE\"\>"}, {"\<\"ReadOnly\"\>", "False"}, {"\<\"SchemaTerm\"\>", "\<\"\"\>"}, {"\<\"SearchStringEscape\"\>", "\<\"\\\\\"\>"}, {"\<\"SQLKeywords\"\>", \ "\<\"ACCESSIBLE,ANALYZE,ASENSITIVE,BEFORE,BIGINT,BINARY,BLOB,CALL,\ CHANGE,CONDITION,DATABASE,DATABASES,DAY_HOUR,DAY_MICROSECOND,DAY_\ MINUTE,DAY_SECOND,DELAYED,DETERMINISTIC,DISTINCTROW,DIV,DUAL,EACH,\ ELSEIF,ENCLOSED,ESCAPED,EXIT,EXPLAIN,FLOAT4,FLOAT8,FORCE,FULLTEXT,\ HIGH_PRIORITY,HOUR_MICROSECOND,HOUR_MINUTE,HOUR_SECOND,IF,IGNORE,\ INFILE,INOUT,INT1,INT2,INT3,INT4,INT8,ITERATE,KEYS,KILL,LEAVE,LIMIT,\ LINEAR,LINES,LOAD,LOCALTIME,LOCALTIMESTAMP,LOCK,LONG,LONGBLOB,\ LONGTEXT,LOOP,LOW_PRIORITY,MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MIDDLEINT,\ MINUTE_MICROSECOND,MINUTE_SECOND,MOD,MODIFIES,NO_WRITE_TO_BINLOG,\ OPTIMIZE,OPTIONALLY,OUT,OUTFILE,PURGE,RANGE,READS,READ_ONLY,READ_\ WRITE,REGEXP,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RETURN,RLIKE,\ SCHEMAS,SECOND_MICROSECOND,SENSITIVE,SEPARATOR,SHOW,SPATIAL,SPECIFIC,\ SQLEXCEPTION,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,SSL,\ STARTING,STRAIGHT_JOIN,TERMINATED,TINYBLOB,TINYINT,TINYTEXT,TRIGGER,\ UNDO,UNLOCK,UNSIGNED,USE,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,VARBINARY,\ VARCHARACTER,WHILE,X509,XOR,YEAR_MONTH,ZEROFILL\"\>"}, {"\<\"SQLStateType\"\>", "\<\"SQL99\"\>"}, {"\<\"StoresLowerCaseIdentifiers\"\>", "True"}, {"\<\"StoresLowerCaseQuotedIdentifiers\"\>", "True"}, {"\<\"StoresMixedCaseIdentifiers\"\>", "False"}, {"\<\"StoresMixedCaseQuotedIdentifiers\"\>", "False"}, {"\<\"StoresUpperCaseIdentifiers\"\>", "False"}, {"\<\"StoresUpperCaseQuotedIdentifiers\"\>", "True"}, {"\<\"StringFunctions\"\>", \ "\<\"ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,\ CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,\ LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,\ MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,\ RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,\ SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER\"\>"}, {"\<\"SupportsAlterTableWithAddColumn\"\>", "True"}, {"\<\"SupportsAlterTableWithDropColumn\"\>", "True"}, {"\<\"SupportsANSI92EntryLevelSQL\"\>", "True"}, {"\<\"SupportsANSI92FullSQL\"\>", "False"}, {"\<\"SupportsANSI92IntermediateSQL\"\>", "False"}, {"\<\"SupportsBatchUpdates\"\>", "True"}, {"\<\"SupportsCatalogsInDataManipulation\"\>", "True"}, {"\<\"SupportsCatalogsInIndexDefinitions\"\>", "True"}, {"\<\"SupportsCatalogsInPrivilegeDefinitions\"\>", "True"}, {"\<\"SupportsCatalogsInProcedureCalls\"\>", "True"}, {"\<\"SupportsCatalogsInTableDefinitions\"\>", "True"}, {"\<\"SupportsColumnAliasing\"\>", "True"}, {"\<\"SupportsConvert\"\>", "False"}, {"\<\"SupportsCoreSQLGrammar\"\>", "True"}, {"\<\"SupportsCorrelatedSubqueries\"\>", "True"}, {"\<\"SupportsDataDefinitionAndDataManipulationTransactions\"\>", "False"}, {"\<\"SupportsDataManipulationTransactionsOnly\"\>", "False"}, {"\<\"SupportsDifferentTableCorrelationNames\"\>", "True"}, {"\<\"SupportsExpressionsInOrderBy\"\>", "True"}, {"\<\"SupportsExtendedSQLGrammar\"\>", "False"}, {"\<\"SupportsForwardOnlyResultSetReadOnlyConcurrency\"\>", "True"}, {"\<\"SupportsForwardOnlyResultSetType\"\>", "False"}, {"\<\"SupportsForwardOnlyResultSetUpdatableConcurrency\"\>", "True"}, {"\<\"SupportsFullOuterJoins\"\>", "False"}, {"\<\"SupportsGetGeneratedKeys\"\>", "True"}, {"\<\"SupportsGroupBy\"\>", "True"}, {"\<\"SupportsGroupByBeyondSelect\"\>", "True"}, {"\<\"SupportsGroupByUnrelated\"\>", "True"}, {"\<\"SupportsIntegrityEnhancementFacility\"\>", "False"}, {"\<\"SupportsLikeEscapeClause\"\>", "True"}, {"\<\"SupportsLimitedOuterJoins\"\>", "True"}, {"\<\"SupportsMinimumSQLGrammar\"\>", "True"}, {"\<\"SupportsMixedCaseIdentifiers\"\>", "False"}, {"\<\"SupportsMixedCaseQuotedIdentifiers\"\>", "False"}, {"\<\"SupportsMultipleOpenResults\"\>", "True"}, {"\<\"SupportsMultipleResultSets\"\>", "False"}, {"\<\"SupportsMultipleTransactions\"\>", "True"}, {"\<\"SupportsNamedParameters\"\>", "False"}, {"\<\"SupportsNonNullableColumns\"\>", "True"}, {"\<\"SupportsOpenCursorsAcrossCommit\"\>", "False"}, {"\<\"SupportsOpenCursorsAcrossRollback\"\>", "False"}, {"\<\"SupportsOpenStatementsAcrossCommit\"\>", "False"}, {"\<\"SupportsOpenStatementsAcrossRollback\"\>", "False"}, {"\<\"SupportsOrderByUnrelated\"\>", "False"}, {"\<\"SupportsOuterJoins\"\>", "True"}, {"\<\"SupportsPositionedDelete\"\>", "False"}, {"\<\"SupportsPositionedUpdate\"\>", "False"}, {"\<\"SupportsResultSetHoldCursorsOverCommitHoldability\"\>", "True"}, {"\<\"SupportsResultSetCloseCursorsAtCommitHoldability\"\>", "False"}, {"\<\"SupportsSavepoints\"\>", "True"}, {"\<\"SupportsSchemasInDataManipulation\"\>", "False"}, {"\<\"SupportsSchemasInIndexDefinitions\"\>", "False"}, {"\<\"SupportsSchemasInPrivilegeDefinitions\"\>", "False"}, {"\<\"SupportsSchemasInProcedureCalls\"\>", "False"}, {"\<\"SupportsSchemasInTableDefinitions\"\>", "False"}, {"\<\"SupportsScrollInsensitiveResultSetReadOnlyConcurrency\"\>", "True"}, {"\<\"SupportsScrollInsensitiveResultSetType\"\>", "True"}, {"\<\"SupportsScrollInsensitiveResultSetUpdatableConcurrency\"\>", "True"}, {"\<\"SupportsScrollSensitiveResultSetReadOnlyConcurrency\"\>", "False"}, {"\<\"SupportsScrollSensitiveResultSetType\"\>", "False"}, {"\<\"SupportsScrollSensitiveResultSetUpdatableConcurrency\"\>", "False"}, {"\<\"SupportsSelectForUpdate\"\>", "True"}, {"\<\"SupportsStatementPooling\"\>", "False"}, {"\<\"SupportsStoredProcedures\"\>", "True"}, {"\<\"SupportsSubqueriesInComparisons\"\>", "True"}, {"\<\"SupportsSubqueriesInExists\"\>", "True"}, {"\<\"SupportsSubqueriesInIns\"\>", "True"}, {"\<\"SupportsSubqueriesInQuantifieds\"\>", "True"}, {"\<\"SupportsTableCorrelationNames\"\>", "True"}, {"\<\"SupportsReadCommitedTransactionIsolationLevel\"\>", "True"}, {"\<\"SupportsReadUncommitedTransactionIsolationLevel\"\>", "True"}, {"\<\"SupportsRepeatableReadTransactionIsolationLevel\"\>", "True"}, {"\<\"SupportsSerializableTransactionIsolationLevel\"\>", "True"}, {"\<\"SupportsTransactions\"\>", "True"}, {"\<\"SupportsUnion\"\>", "True"}, {"\<\"SupportsUnionAll\"\>", "True"}, {"\<\"SystemFunctions\"\>", \ "\<\"DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_\ INSERT_ID,VERSION\"\>"}, {"\<\"TimeDateFunctions\"\>", \ "\<\"DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,\ QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,\ FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,\ CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_\ UNIXTIME,SEC_TO_TIME,TIME_TO_SEC\"\>"}, {"\<\"UpdatesAreDetectedForForwardOnly\"\>", "False"}, {"\<\"UpdatesAreDetectedForScrollInsensitive\"\>", "False"}, {"\<\"UpdatesAreDetectedForScrollSensitive\"\>", "False"}, hoffe hier gibs jemand der ahnung davon hat |
|
Verwandte Themen
Die Beliebtesten » |
Die Größten » |
Die Neuesten » |
|