Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #5980
| From | Chris Degnen <degnen@cwgsy.net> |
|---|---|
| Newsgroups | comp.soft-sys.math.mathematica |
| Subject | Re: Matematica Beginner/Student and Mysql |
| Date | 2011-10-29 11:13 +0000 |
| Organization | Steven M. Christensen and Associates, Inc and MathTensor, Inc. |
| Message-ID | <j8gn5l$5af$1@smc.vnet.net> (permalink) |
| References | <j8dtds$kff$1@smc.vnet.net> |
On Oct 28, 10:42 am, ejules <webereju...@gmail.com> 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 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 Needs["DatabaseLink`"] conn1 = OpenSQLConnection[JDBC["mysql", "localhost:3306/ testdatabase"], Username -> "root", Password -> ""]; SQLTableNames[conn1]
Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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