Page 1 of 1

SQL Tutorial

Posted: Sun Jul 15, 2012 3:33 am
by Cage
Is there an updated SQL tutorial that works with PB 4.61? I have found a few but they were for older versions, and would not work with the newest version. Any help would be greatly appreciated.

Re: SQL Tutorial

Posted: Sun Jul 15, 2012 12:03 pm
by Bisonte
Wich SQL ?
SQLite, MySQL, PostGreSQL (native in PB) ?
The Syntax of the SQL-"Language" ?
PB ?

Re: SQL Tutorial

Posted: Sun Jul 15, 2012 7:18 pm
by Cage
Native SQL in Pure Basic 4.61 or MySql.

Re: SQL Tutorial

Posted: Sun Jul 15, 2012 7:26 pm
by ts-soft
SQL are Strings-Sequences, this have nothing to do with PureBasic. If you use MySQL: http://www.mysqltutorial.org/
You require a ODBC-Driver for MySQL for using in PB.

Re: SQL Tutorial

Posted: Sun Jul 15, 2012 9:37 pm
by IdeasVacuum
It depends whether or not you need to access a database on your local machine or one that is on a Server. This is explained in the PB Help and PB is very easy to use with SQLite (Local DB) and PostgreSQL (Server DB).

The help has a PB example (Database.pb) and links to the appropriate website for each specific SQL program.
http://www.purebasic.com/documentation/ ... index.html

There are many books on the subject (no surprises there). One of the best intros to SQL imho is:
SQL in Easy Steps