SQL Tutorial

Windows specific forum
Cage
New User
New User
Posts: 9
Joined: Wed Oct 27, 2010 4:02 pm

SQL Tutorial

Post 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.
User avatar
Bisonte
Addict
Addict
Posts: 1305
Joined: Tue Oct 09, 2007 2:15 am

Re: SQL Tutorial

Post by Bisonte »

Wich SQL ?
SQLite, MySQL, PostGreSQL (native in PB) ?
The Syntax of the SQL-"Language" ?
PB ?
PureBasic 6.21 (Windows x64) | Windows 11 Pro | AsRock B850 Steel Legend Wifi | R7 9800x3D | 64GB RAM | RTX 5080 | ThermaltakeView 270 TG ARGB | build by vannicom​​
English is not my native language... (I often use DeepL.)
Cage
New User
New User
Posts: 9
Joined: Wed Oct 27, 2010 4:02 pm

Re: SQL Tutorial

Post by Cage »

Native SQL in Pure Basic 4.61 or MySql.
User avatar
ts-soft
Always Here
Always Here
Posts: 5756
Joined: Thu Jun 24, 2004 2:44 pm
Location: Berlin - Germany

Re: SQL Tutorial

Post 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.
PureBasic 5.73 | SpiderBasic 2.30 | Windows 10 Pro (x64) | Linux Mint 20.1 (x64)
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
Image
IdeasVacuum
Always Here
Always Here
Posts: 6426
Joined: Fri Oct 23, 2009 2:33 am
Location: Wales, UK
Contact:

Re: SQL Tutorial

Post 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
IdeasVacuum
If it sounds simple, you have not grasped the complexity.
Post Reply