MySQL Question :/

Renton

Not sure if im posting this in the right place, So im gonna post it on the programming board aswell...

Anyhoo.

Basically, Im writing a program, but I need it to be able to access a MySQL Database by opening a tcp/ip connection to the database server and get / put information.

Anyone got any ideas of what kind of commands it uses ? or any docs related to it ?

Any help appreciated.

Gavin

Mysql ( and most modern DB systems ) use SQL. Or Sequel. It's a very simple language for making queries, inserting data etc..

have a look at www.sqlcourse.com...
also of course the mysql website has plenty of info..

Gav

Static

Not sure what programming language you're using but....

if it's PHP, there are built in PHP functions for accessing the DB.

if it's Perl, there are optional modules (search for Mysql on search.cpan.org) that you use.

if it's java, look up the JDBC tutorial on java.sun.com


If you're simply talking about Mysql itself, then follow verb's suggestion, that site is a really good intro.

flamegrill

If however the program is a windows based application you can setup a mysql server in your ODBC Data Sources in your control panel and then use ODBC function calls in what ever language you are using.

Note: there are ODBC drivers for both Windows and Unix.


if you have any more questions just tell us what lanugage/Opertating system you are using.

Static

PHP,Perl and Java won't need to use ODBC, so avoid that if you can. Makes the code much less simple and much less portable.

Asp and VB etc will. It depends on what you're at.

Molotov

If you need help, you always give me a call and I'll get you sort you out with some top of the industry quality training in the subject.

http://www.qa.com/ireland