Report, edit, etc...Posted by -bilal92- on 2006-09-07 at 01:29:45
I want to know whats the difference between SQL and MySQL are they both equally important? What I thought was that SQL is the scripting part and...MySQL I dont know what it is. Lol im confused can someone help me?
Report, edit, etc...Posted by Centreri on 2006-09-07 at 15:44:19
SQL is the language used to interact with the MySQL database program, usually through a language such as php in the form of a query or through the MySQL interface (the text box at the top).
Report, edit, etc...Posted by -bilal92- on 2006-09-07 at 19:20:46
can it interact with microsoft access or any other databas program?
Report, edit, etc...Posted by fatimid08 on 2006-09-08 at 07:13:21
MS Access uses the SQL language to query it's database, just as MySQL does, or just as Microsoft SQL Server 2005 does. The basic syntax and keywords are the same, although some database providers support different advanced keywords and features. On the whole, if you keep your database queries simple, they can work on about any popular type of databases.
Report, edit, etc...Posted by -bilal92- on 2006-09-08 at 21:56:29
cool thanks now just need to learn how to use access 2003 
hmmm
hmmmReport, edit, etc...Posted by Pyro-Fire on 2006-09-15 at 08:33:00
SQL is the language used while calling a query
mysql_query("SQL CODE")
MYSQL is the "plugin-in" if you will, that allows interaction between the sql server / the user / the website VIA a server scripting language like (in this case) PHP
Example:
Header code:
<?php
$sql = mysql_connect("database","username","password")
$username = $_POST['username'];
$password = $_POST['password'];
mysql_select_db("my_db", $sql);
?>
SQL code:
<?php
$sql_query = "SELECT username FROM members WHERE username = '$username'"
?>
MYSQL Code:
<?php
$query_output = mysql_query($sql_query)
if($query_output['password']=$password)
{
setcookie("cookie_name","cookie data",time()+3600*24*30);
}
?>
Note: i assume your coding in php. and mysql/sql isnt restricted to JUST php...
mysql_query("SQL CODE")
MYSQL is the "plugin-in" if you will, that allows interaction between the sql server / the user / the website VIA a server scripting language like (in this case) PHP
Example:
Header code:
CODE
<?php
$sql = mysql_connect("database","username","password")
$username = $_POST['username'];
$password = $_POST['password'];
mysql_select_db("my_db", $sql);
?>
SQL code:
CODE
<?php
$sql_query = "SELECT username FROM members WHERE username = '$username'"
?>
MYSQL Code:
CODE
<?php
$query_output = mysql_query($sql_query)
if($query_output['password']=$password)
{
setcookie("cookie_name","cookie data",time()+3600*24*30);
}
?>
Note: i assume your coding in php. and mysql/sql isnt restricted to JUST php...