Re: Matematica Beginner/Student and Mysql
- To: mathgroup at smc.vnet.net
- Subject: [mg122486] Re: Matematica Beginner/Student and Mysql
- From: Armand Tamzarian <mike.honeychurch at gmail.com>
- Date: Sun, 30 Oct 2011 04:20:05 -0500 (EST)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- References: <j8dtds$kff$1@smc.vnet.net>
On Oct 28, 8:42 pm, ejules <webereju... at 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`"]; conn = OpenSQLConnection[ DatabaseLink`JDBC[ "MySQL(Connector/J)", "localhost:3306/testdatabase"], "Username" -> "root", "Password" -> ""]; your connection to testdatabase should now be open. So try this out out: SQLExecute[conn, "SELECT * FROM testdatabase LIMIT 10"] Mike