MathGroup Archive 2011

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

Search the Archive

Re: Matematica Beginner/Student and Mysql

  • To: mathgroup at
  • Subject: [mg122453] Re: Matematica Beginner/Student and Mysql
  • From: Chris Degnen <degnen at>
  • Date: Sat, 29 Oct 2011 07:09:23 -0400 (EDT)
  • Delivered-to:
  • References: <j8dtds$kff$>

On Oct 28, 10:42 am, ejules <webereju... at> wrote:
> 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 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

conn1 = OpenSQLConnection[JDBC["mysql", "localhost:3306/
   Username -> "root", Password -> ""];

  • Prev by Date: Re: Coin Toss Sim
  • Next by Date: Re: Strings with different Styles in a Grid
  • Previous by thread: Re: Matematica Beginner/Student and Mysql
  • Next by thread: Re: Matematica Beginner/Student and Mysql