Whats The Difference Between SQL And Mysql

Hello Friends Need Your Help.Can Anybody Explain Me Whats The Difference Between SQL And Mysql? For PHP And Asp.net Which Database Is required?
Can Anybody Tell Me Which Is The Best And Most Popular Editor?
Waiting for ur reply.
Thanks.

 

I think your question is what is the difference between MSSQL and MySQL. SQL (standard query language) is the basic language to extract data from databases. All major databases (and most small ones) utilize some form of SQL.

The differences between MSSQL and MySQL are more than I will number here, but here are the major points. MSSQL is a Microsoft software option for databases. There is a free version, but generally speaking if you want to own a full version of MSSQL it will cost a pretty penny. MySQL used to be free, but there are some versions (like the enterprise edition) that now cost some money. There are some syntax differences. There are certain functions that are either unique to one or the other (for example MSSQL has a superset of SQL called Transact-SQL) or that operate slightly differently.

You can use either database with both PHP and ASP.Net. Generally you will see MySQL with PHP because both products can be had for free. You generally see MSSQL with ASP.Net because both products are Microsoft. However, they both work well with both products.

Editor for what? SQL statements? If you are using MSSQL it would be the included query analyzer.

 

Thanks For Clearing My Doubt.Actually I Have MSSQL Original Licensed Version But Some Syntax are not working.means i am learning SQL from w3schools what they have provide syntax that are not compatible with MSSQL so I want to know about the Mysql.
In Mssql in order to create a table we use the following command.--------CREATE TABLE DEBASIS
(
ST_ID INT, NAME VARCHAR(30),ADDRESS VARCHAR(40),PHONE VARCHAR(12)
)

Once i downloaded one script there i have seen one database.txt file written in some sql queries which i have given below


CREATE TABLE `tb_ads` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(150) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
`tipo` varchar(150) collate latin1_general_ci NOT NULL,
`visitime` varchar(150) collate latin1_general_ci NOT NULL,
`ident` varchar(150) collate latin1_general_ci NOT NULL,
`fechainicia` varchar(150) collate latin1_general_ci NOT NULL,
`paypalname` varchar(150) collate latin1_general_ci NOT NULL,
`paypalemail` varchar(150) collate latin1_general_ci NOT NULL,
`plan` varchar(150) collate latin1_general_ci NOT NULL,
`bold` varchar(150) collate latin1_general_ci NOT NULL,
`highlight` varchar(150) collate latin1_general_ci NOT NULL,
`url` varchar(150) collate latin1_general_ci NOT NULL,
`description` varchar(150) collate latin1_general_ci NOT NULL,
`category` varchar(150) collate latin1_general_ci NOT NULL,
`members` varchar(150) collate latin1_general_ci NOT NULL default '0',
`outside` varchar(150) collate latin1_general_ci NOT NULL default '0',
`total` varchar(150) collate latin1_general_ci NOT NULL default '0',
KEY `id` (`id`)
)


so i want to know that the above queries are written in which Query editor.
Thanks.

 

You have many options to use query editor for MySQL e.g. HeidiSQL, navicat and so on. Checkout a list of MySQL GUIs.

 

Thanks a lot for ur reply.today i have downloaded the MYsql-5.1.3-win32 but it couldn't installed in my system but anyway thanks for ur reply.
Good Night.

 

All database management systems use SQL. However, each database software package will have slight differences. For example, MSSQL provides the TOP command, which is something you only find in MSSQL.

SQL is an ANSI standard language, which means you if you write code that only uses the standard specific syntax, it will work in most databases.

 

Actually both of these scripts can be used to create a table in MSSQL. The first script creates a very simple table where you have detailed only the datatypes of the columns.

The second script provides more details about the columns. Not only is the datatype provided, but it tells what collation each column should be (if you're expecting chinese characters, say, you want a different collation), that the columns do not allow nulls and provide a default value for certain key columns where an empty space isn't desired.

 

That is right. You cannot make a comparison between SQL (query language) and MySQL (DBMS)

 

I think you are talking about MS sql server and mysql. MS SQL server works on windows while mysql works on both windows and linux

 

MySQL uses with php and sql with .asp

MySQL for linux or unix platforms
SQL works for Windows.

 

which one use to Worpress, MYSQL or SQL?

 

MySQL

PHP - MySQL
ASP.NET - SQL

 

FYI,
ASP/ASP.NET will work with mySQL as well as PHP will work with MS SQL. It's a matter of connection properties.

 

thank guys because of you i understood the difference between MSSQL and MYSQL

 

I now understand the differences too. Now I just have to figure out how's best to use them. I am new to the database thing.

 

why not try re-downloading,it generally works in the first attempt,but exceptions are always there.
Give it another shot.