Mysql

[ptaylor]

Can you please give me a example of how to connect, search, add and deleted a record from mysql database please?

Thanks
Phil

[rsts]

I've only used sqlite, but the principles are the same.

Have you tried a search? There should be examples available. If you can't find anything relevant, let us know.

Welcome to the PureBasic forums.

cheers

You might see if this helps - http://www.purebasic.fr/english/viewtopic.php?t=26413

[netmaestro]

Flype has a userlibrary for this which includes full sourcecode so you should find it instructive:

http://www.purebasic.fr/english/viewtop ... rlibraries

[Pantcho!!]

Making this is more related to SQL language.

Connecting a database and Querying is the most easy thing you can do.
(using flype lib or Paul's MDB lib)
but how to do it that is the quetion.

for quick tutorial:
http://www.w3schools.com/sql/default.asp

[ptaylor]

Thank you for providing a good example and it works for windows. What if you going to use mysql for linux what code you would use to open, read, write and search for a record? Does the dll only work for windows and not linux?

Thanks
Phil

[Rook Zimbabwe]

I think the SQL commandset within PB will do what you need... in fact I know it can as I do it in several programs.

Use the DatabaseUpdate() command... this holds the correct SQL request.

Read the tutorials in the HELP file to see how to structure your request.

What command are you attempting to execute? Maybe I could provide a better example.