Hi Folks,
I'm in need to connect from my SQL 2008R2 (64 bit) server, to my MySQL
database server...
I found this page:
http://www.mysql.com/downloads/connector/net/
This page has the 32 bit drivers, but I *believe* I would need 64 bit,
since it's being installed on the 64 bit SQL server, correct
> From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
> Sent: July 1, 2010 7:58 AM
> To: David Stoltz
> Cc: mysql@lists.mysql.com
> Subject: Re: phpMyAdmin and other management tools
>
> Hi Dave,
>
> I recommend you to use "Toad for MySQL".
>
> It h
Hi Folks,
I'm currently using phpMyAdmin to manage the mySQL databases. I'm
wondering what most people like to use? I know there is "mySQL
Workbench", which I haven't really fooled with yet
Can anyone comment on what they use and why?
Thanks!
Dave
Awesome - thanks all for that clarification!
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Wednesday, June 30, 2010 1:42 PM
To: David Stoltz
Cc: mysql@lists.mysql.com
Subject: Re: INSERT with auto increment
generally, it is:
INSERT INTO TABLE1 (fieldname
Hi All,
In MS SQL, if the table has an identity field/primary key which is set
to auto increment, you can leave the value out of an INSERT statement,
and the next highest value will be automatically inserted...
For instance, with a two column table I could do "INSERT INTO TABLE1
VALUES('stu
Actually,
That table isn't supposed to have a PK, so I removed that, and it
works...same effect you suggested.
Thanks!
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Wednesday, June 23, 2010 12:29 PM
To: David Stoltz
Cc: mysql@lists.mysql.com
Subject: Re:
Hi Folks,
I use an online SQL Design tool to design my tables, etc. This generates
script code that I can run in phpMySQL to create the tables, etc.
The below code is causing an error - see below:
CREATE TABLE `testresults` (
`id_employees` INTEGER DEFAULT NULL ,
`id_test_test` INTEGE
