Printable View
Hi,
I have never used or looked at SQL software in my life. I would like to learn SQL Server but don't know which is better - MySQL or MS SQL? What is the difference between the two?
I have downloaded and installed MySQL 6.0(is this the latest version?) and I now need to learn how to install and set it up? Anyone know where I can get such material that can assist with the learning?
Let me know.
Thank you,
The difference between MySQL and SQL server?
MySQL is open source and free to use. SQL Server is the database server made by MS, expensive and closed source.
Both use SQL; Structured Query Language. Both use the same syntax to create queries (with some minor differences).
Are you installing MySQL on linux/bsd or Windows? Not that it really matters once it's installed, they all work the same.
http://dev.mysql.com/tech-resources/...sql_intro.html
I have never really used SQL but to support it I just installed 2005/2008 express which is free from MS and play with that.
We use it for software we support.
DSL is giving hassels today but i dont have a link.
I see you are in Capetown so try the local ftp - ftp://ftp.agasa.co.za. If you are using Internet solutions as your backbone the DL from MS is mirrored at akamai so it will be a local download if you are using a local only account. If you are using SAIX (telskum) then its a 50/50 gamble if it will be mirrored.
You can PM me as we live in the same area and we can chat if you like.
Cheers.
He's just trying to learn; he can get the Express version for free: http://www.microsoft.com/express/sql/Quote:
SQL Server is the database server made by MS, expensive and closed source.
Clarification (OK, I know... soapbox... but SQL is my thing. I will be brief): The term SQL has a couple of meanings. Technically speaking, SQL (Structured Query Language) is a programming language used to access relational databases (RDBMS). SQL can also be used to generically refer to RDBMS. e.g. It's a SQL DB.
To confuse the matter a bit, Microsoft named their RDBMS (based on Sybase) product, SQL Server. Other widely used RDBMS include DB2, oracle, Sybase, mysql. There are many differences between these RDBMS.
SQL (the language) can be used to manipulate data in RDMS (e.g. queries). This is called DML (Data Manipulation Language). SQL can also be used to manage (e.g. create, update, delete) database objects. This is called DDL (Data Definition Language).
If you want to learn Structured Query Language (SQL) from an application programmer (e.g. focus on DML or queries) perspective, then either mysql or MS SQL will suffice. As mentioned ^, the syntax on queries will vary slightly (most SQL engines have customized their syntax. However ANSI SQL will work across most DBMS). I would lean towards the Microsoft offering, because the Dev Studio is nice, especially in 2005/2008 and I am assuming you have windoze desktop. As Neg pointed out, the Express version will be fine for learning.
The MS SQL Site has plenty of docs to get u started. Install is a snap.
http://www.microsoft.com/sqlserver/2...s/default.aspx
Also, google "SQL primer" and you will find an abundant number of sites with basics.
Good Luck.
Sorry CSR but SQL doesn't stand for anything...
http://antionline.com/showpost.php?p=937012&postcount=3
lol...Quote:
Sorry CSR but SQL doesn't stand for anything...
News to me. I would be curious to know where you got the quote.
When I worked for IBM (long time ago), I met the IBMers that that developed the first version of SQL which was based on Dr Codd's System R Internal Research Project. The first version of SQL was developed at IBM by Andrew Richardson, Donald C. Messerly and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM's original relational database research/internal product, System R. IBM was granted a patent for their version of SQL (Structured Query Language) in 1985, while the SQL language was not formally standardized until 1986 by the American National Standards Institute (ANSI) as SQL-86.
P.S....
How do you know when a lawyer is lying?... His lips are moving. ;)Quote:
So technically, SQL doesn’t stand for anything ‘cause IBM’s lawyers say so…
Holy **** man you ARE old! lolQuote:
Originally Posted by Cheap Scotch Ron
Where did I get that quote...
I don't remember. It was in some corse text but I can't remember what class.
Yeah, but I'm like a wine... I get better with age. ;)
haha?Quote:
Originally Posted by Cheap Scotch Ron