SQL Tutorial
SQL Tutorial
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
Wich SQL ?
SQLite, MySQL, PostGreSQL (native in PB) ?
The Syntax of the SQL-"Language" ?
PB ?
SQLite, MySQL, PostGreSQL (native in PB) ?
The Syntax of the SQL-"Language" ?
PB ?
Re: SQL Tutorial
Native SQL in Pure Basic 4.61 or MySql.
Re: SQL Tutorial
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.
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.

Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.

-
- Always Here
- Posts: 6426
- Joined: Fri Oct 23, 2009 2:33 am
- Location: Wales, UK
- Contact:
Re: SQL Tutorial
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
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.
If it sounds simple, you have not grasped the complexity.