Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #5963

Matematica Beginner/Student and Mysql

From ejules <weberejules@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Matematica Beginner/Student and Mysql
Date 2011-10-28 09:42 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j8dtds$kff$1@smc.vnet.net> (permalink)

Show all headers | View raw


Hello Everybody.. I hope this is the right place to post...

I'm student and currently trying to connect a mysql database running
locally on 127.0.0.1:3306 localhost, including the database
Testdatabase with table Testtable.
I try now to connect with Mathematica:

Needs["DatabaseLink`"];
SqlConnection[
 JDBC["MySQL(Connector/J)", "localhost:3306/testdatabase"],
 "Name" -> "TestDB", "Username" -> "root", "Password" -> ""]
conn1 = OpensqlConnection["TestDB"]
SQLTableNames[conn1]

Unfortunately my Ouptut is only a echo of what i wrote but not the
result i'm looking for
afterwards i would like to send standard sql queries to retrieve
data...
Anyone could help me? Step by step? I never used Mathematica before,
but as my datasets are pretty large and manipulating data in tables is
very convienient, i would really appreciate any help..

Thank you! ejules

Back to comp.soft-sys.math.mathematica | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

Matematica Beginner/Student and Mysql ejules <weberejules@gmail.com> - 2011-10-28 09:42 +0000
  Re: Matematica Beginner/Student and Mysql A Retey <awnl@gmx-topmail.de> - 2011-10-29 11:10 +0000
  Re: Matematica Beginner/Student and Mysql Chris Degnen <degnen@cwgsy.net> - 2011-10-29 11:13 +0000
  Re: Matematica Beginner/Student and Mysql David Reiss <dbreiss@gmail.com> - 2011-10-29 11:09 +0000
  Re: Matematica Beginner/Student and Mysql ejules <weberejules@gmail.com> - 2011-10-29 11:13 +0000
  Re: Matematica Beginner/Student and Mysql Armand Tamzarian <mike.honeychurch@gmail.com> - 2011-10-30 09:20 +0000

csiph-web