Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

Matematica Beginner/Student and Mysql

  • To: mathgroup at smc.vnet.net
  • Subject: [mg122430] Matematica Beginner/Student and Mysql
  • From: ejules <weberejules at gmail.com>
  • Date: Fri, 28 Oct 2011 05:35:43 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com

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




  • Prev by Date: Re: Combine sqrts in denominator
  • Next by Date: Re: Formatting in XLS(X) files
  • Previous by thread: Re: List plot with random size for each point
  • Next by thread: Re: Matematica Beginner/Student and Mysql