Connection to MySQL Database

[NickRH]

Thanks Steve, I`ll have a look into Navicat. Hopefully by the time we all meet again i`ll have it up and running. I`ll also try our IT department as they already use several SQL databases and we might have something I can just use.

Hopefully I`ll be able to attend the next meet, i`m in a new company now so still getting a feel for attending events, etc

[swatts]

I've uploaded a video on SQL, Navicat etc

Hope it helps

[NickRH]

Thank you Steve, I`ll have a look at that.

I`ve been given a copy of MyWorkbench from MySQL by IT, seems ok so far .....

[swatts]

I always found myworkbench to be great for database design but not so good for SQL creation. That said it gets updated fairly often.

I think it may be a good subject for the group.

[NickRH]

I would have to agree, I`ve tried the `Create New Table` SQL code generator in My Workbench and the SQL code did not work. I had to modify it myself ..... not great. But its reasonably friendly to use apart from that.

I`m not sure how many of us use SQL but I would imagine the majority do. I think your right it might be a useful subject.

[Ian_Billingsley]

Hi Steve,

Im currently working with a My SQL database and would really appreciate it if you could let me have a copy of the modified tcp connection tool kit if its easy to get your hands on?

Are you guys still planning to discuss the my sql database subject at the next user group meeting?

Cheers

Ian

[swatts]

I'll try and get it to you Tuesday mate, I'm having 2 days off in Brighton   

[CRoebuck]

Folks,

I've been using the MySQL toolkit from Saphir for the past 18 months. It comes with good documentation and makes connection very simply for first timers. I agree that paying for something feels kind of wrong when there are free toolkits available but in this case the customer needs access in future to the source. Having them use a supported albeit paid for toolkit made sense.

There are enough syntax changes between MySQL and SQL Server 2012 to make building queries enough of a pain anyway.....

Chris

[Ian_Billingsley]

Thank you both.

Steve, enjoy the delights of Brighton!

Chris, thanks for the tip. I shall have a look at the Saphir toolkit.

Hope your both well.

[swatts]

Right Ian,

Back from Brighton.

The files you need are here

>>CSLUG>> MySQL.zip

it's in LV2013 and if you open the lvlib you'll find an example.

If you need help creating queries, I use this tool https://www.youtube.com/watch?v=y2aSaiWKrv0

It's about £80 from Navicat

With regards the next meeting, I think it's going to end up being drinks after the CLD Summit (as most of us will be around then)