there is no more difference in sql and mysql except syntex.
actually all most syntex is same. in mysql there is some
features which is seen like easy to understandable.
SQL is stand for Structured Query Language, while My SQL is
Open Source Database Package.
SQL is used for Handling i.e(Data Retrieval, Data Deletion,
Data Modification) data which are stored in Mysql Database
Engine in the form of Tables, field(Rows) , Tupples (Columns).
SQL (Structure Query Language) is a language that helps one
to manipulate the data in a database by its
SELECT,UPDATE,DELETE etc commands.Whereas MySQL is a
database server which houses database on which sql queries
are run.....
SQL can be used with various other db packages apart from
mysql so therz nothing similar about both ,each one serves
a diff purpose
Sql is the regular RDBMS and depends on which database u are
using like
TSQL for microsoft
PLSQL for oracle and
MSSQL is for IBM databases
means this MSSQL is the RDBMS which is used to work with IBM
database.
MYSQL is the type of RDBMS and SQL is the main language for
retrieveing the data.
in a master-master replication with two masters and
alternate slaves running on two systems.can i have a script
or any mysql command to know which one is right now acting
as master.
if we want to load data from a text file into a mysql table,
but the columns in table are 1st: code(int) and 2nd:
city(varchar), but in text file the format is 1st cityname
and then code separeted by delimeters. how to load?