+ 1

Is their anydifference between sql and my sql

19th Apr 2017, 9:28 AM
Jyosna Dronavalli
6 Antworten
+ 5
SQL is the language. mySQL is one of the "tool" to communicate between PHP and a database by sending SQL requests.
19th Apr 2017, 9:36 AM
Geoffrey L
Geoffrey L - avatar
+ 5
I don't use mySQL so I won't be able to answer you about that. For me I use another one call "PDO". That's a powerful object which include methods to write safe requests. The idea of PDO is you instanciate a new PDO object, You setup the connection to access your database, You open a connection, You write a request, PDO prepare the request by safely remplacing variables inside the request with there values, You trigger the request PDO return a object with matching result(s) You close the connection with the database for safety You handle the result of PDO.
19th Apr 2017, 9:48 AM
Geoffrey L
Geoffrey L - avatar
+ 5
A good way to learn SQL, except by learning with Sololearn, is to use Phpmyadmin on a dummy database to prevent break something. Then when you click on button inside Phpmyadmin, each time Phpmyadmin is making a SQL request, it will write the SQL request it just use. You can see SQL behavior that way and directly test your own request inside Phpmyadmin to see what happen
19th Apr 2017, 10:17 AM
Geoffrey L
Geoffrey L - avatar
+ 1
how can I learn my SQL because most of the jobs were based upon my sql
19th Apr 2017, 9:39 AM
Jyosna Dronavalli
+ 1
pls forward the po software link to learn
19th Apr 2017, 10:43 AM
Jyosna Dronavalli
+ 1
SQL stands for Structured Query Language which is domain specific language and most used in Rational Database Manage Systems(RDBMS). MySQL, PostgreSQL, MSSQL, Oracle, and so forth are differenct implemention of SQL language. The SQL commands in this tutorial are implemented in most RDBMS system, so that you can use the command to Query Data on differenct RDBMS. In short SQL is a computer language to work with database, and MySQL is one of the database system.
19th Apr 2017, 11:29 AM
鐘翊修
鐘翊修 - avatar