1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Whats The Difference Between SQL And Mysql

Discussion in 'MySQL' started by webtechno2, Jan 28, 2009.

  1. #1
    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.:confused:
    SEMrush
     
    webtechno2, Jan 28, 2009 IP
    SEMrush
  2. druidelder

    druidelder Peon

    Messages:
    286
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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.
     
    druidelder, Jan 28, 2009 IP
    Halobitt likes this.
  3. webtechno2

    webtechno2 Banned

    Messages:
    149
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    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.
     
    webtechno2, Jan 28, 2009 IP
  4. mwasif

    mwasif Active Member

    Messages:
    818
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    You have many options to use query editor for MySQL e.g. HeidiSQL, navicat and so on. Checkout a list of MySQL GUIs.
     
    mwasif, Jan 28, 2009 IP
  5. webtechno2

    webtechno2 Banned

    Messages:
    149
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    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.:)
     
    webtechno2, Jan 28, 2009 IP
  6. w0tan

    w0tan Peon

    Messages:
    77
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #6
    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.
     
    w0tan, Jan 30, 2009 IP
  7. eyespi

    eyespi Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    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.
     
    eyespi, Feb 4, 2009 IP
  8. vntutor

    vntutor Banned

    Messages:
    1,721
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #8
    That is right. You cannot make a comparison between SQL (query language) and MySQL (DBMS)
     
    vntutor, Feb 4, 2009 IP
  9. kellywriter

    kellywriter Banned

    Messages:
    81
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #9
    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
     
    kellywriter, Feb 9, 2009 IP
  10. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #10
    MySQL uses with php and sql with .asp

    MySQL for linux or unix platforms
    SQL works for Windows.
     
    Jalpari, Feb 9, 2009 IP
  11. locjan

    locjan Peon

    Messages:
    201
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #11
    which one use to Worpress, MYSQL or SQL?
     
    locjan, Feb 9, 2009 IP
  12. nhc1987

    nhc1987 Notable Member

    Messages:
    2,678
    Likes Received:
    240
    Best Answers:
    0
    Trophy Points:
    280
    #12
    MySQL :)

    PHP - MySQL
    ASP.NET - SQL
     
    nhc1987, Feb 9, 2009 IP
  13. zealus

    zealus Active Member

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    93
    #13
    FYI,
    ASP/ASP.NET will work with mySQL as well as PHP will work with MS SQL. It's a matter of connection properties.
     
    zealus, Feb 10, 2009 IP
  14. NightMare49

    NightMare49 Member

    Messages:
    109
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #14
    thank guys because of you i understood the difference between MSSQL and MYSQL
     
    NightMare49, Feb 21, 2009 IP
  15. dmivie

    dmivie Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #15
    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.
     
    dmivie, Feb 22, 2009 IP
  16. quantum physics

    quantum physics Peon

    Messages:
    110
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #16
    why not try re-downloading,it generally works in the first attempt,but exceptions are always there.
    Give it another shot.
     
    quantum physics, Feb 24, 2009 IP