Help learning MySQL/SQL!

[FlyingSpoon]

What would be more better to learn?

MySQL OR SQLite or SQL whatever it is called dbConnect one ,

( Connecting to PHPMyAdmin database )

[botder]

SQLite is a kind of compact form of MySQL. The syntax is almost the same and you should have no problems if you start with SQLite or MySQL. Anyway, I suggest you to start with MySQL, because it will cover the SQLite syntax.

[WhoAmI]

By using dbConnect you are able to connect to SQLite and MySQL database.

SQL

dbConnect( "sqlite", "file.db" ) 

MySQL

host = "localhost"; 
name = "database_name"; 
user = "user"; 
password = "password"; 
  
dbConnect( "mysql", "dbname=" .. name .. ";host=" .. host, user, password, "share=1" ) 

[xXMADEXx]

What you'll want to learn depends on what you want to be capable of.

SQLite and MySQL have basically the same syntax (Very little differences).

What it really comes down to is speed and accessibility.

SQLite will be faster than MySQL because its a file directly on the file, however you cannot access these files from a website. MySQL offers PHPMyAdmin, so you can view the file from a web server, however it's a remote server so it will take a little more time to execute query's.

Check this tutorial: viewtopic.php?f=148&t=38203